Microsoft Excel

130K

Solutions

192

Articles & Videos

37K

Contributors

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Related Topics

  1. Microsoft Office
  2. Visual Basic Classic
  3. VB Script
  4. Microsoft Applications
  5. Spreadsheets
  6. Microsoft Access
  7. VBA
  8. Microsoft Word
  9. Programming
  10. Visual Basic.NET
Refine results

hi
In the attached sheet, how can I combine the Vlookup with the indirect function in the May 2017 sheet so that the salary is found for each individual based on their works number and the sheet that…

315 views
Revamp Your Training Process
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Hi,

i need to remove all the custom formatting of all unused cells of the workbook, as it does not have much data but file size is more than 10 MB.

can anyone please help with the VBA to do …

313 views

Hi,
I also want to capture values of M/C/O, on either Column 3 or 4 of Sheet5. How to adjust Scan_list4, of the attached file?

516 views

Good Day!Please help me on this..

1. I want to copy the data from these columns ID Code,Name,Store,Product Code, Brand,Form,Days,Category and Sales Using VBA.
 
2. Paste these values to another …

1823 views

I have several reports that are submitted monthly using raw data imported into EXCEL.

Requirements –
>Keep a running balance charged to the customer’s account per month.  This is reflected in the …

1232 views

Hello,

Is there a way to VLOOKUP (or something else) off more than one field to bring back a results?  The problem I have is, I have a file number and a date field. Then I have other report with …

519 views

How do I find the position of the last space " " before the (say) fifth period in a text string?

eg

1. aa 2. bbb 3. ccc ccc 4. ddd dd 5. eeeeeeee 6. ffffffffff 7. g g g .........

So I would …

1845 views

Hi,

i need to send out workbook to users to fill the data in them, but when i get the data, they mess up the whole formatting. for example they paste on columns that has color background and also …

213 views

i have a boss, which is a old lady and does not understand excel table structured references, every time i sent her the file, she asks me to convert the formula reference back to explicit cell …

310 views

I had this question after viewing VBA how to delete all objects regardless of its type from all worksheets in workbook …

212 views
Technology Partners: We Want Your Opinion!
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

I had this question after viewing VBA to clear/put no-fill the cells background color for all sheets of active workbook …

515 views

i have received a mess, so many entire rows and entire columns background colored and text colored.

i need help with VBA that restores all of the cells background colors and font to the default. by…

525 views

when i open a file received from our company  partner, it states the following error.

how do i find the trace of the cells that is causing this error, so that i can fix it.

212 views

I would like to have Unique Customer List in Userform from Sheet (Sales) Col A

319 views

hi I have a list of values so I want a formula that if someone picks - for example in an A frame, Standard spec, clear span and which has a measurement close to one of the entries in the width column …

422 views

I've got this formula set up
=SUMIFS(D:D,A:A,$N17)/GETPIVOTDATA("[Measures].[Distinct Count of WeekNo 2]",$N$16,"[Range].[Employee]","[Range].[Employee].&[Dave]")

How do I reference the [Dave] …

1217 views

Hi

I need to change
FAB
GAB
HAB
IAB

to
FAC
GAC
HAC
IAC

how to do this using formula?

1233 views

Within VBA I am trying to determine how to:

Sum Column A record Count in Worksheet A  * 2 + Sum Column A record Count in Worksheet B
Compare with the Sum from  Column A record Count in Worksheet C…

729 views

Good Day! I have these code below which it gives me an error of "We can't paste because copy area and paste area arent the same size".. Please help what is wrong with these code... :(

(CODE)

339 views
Enroll in May's Course of the Month
Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Hi all, anyone can help me to solve my problem. I want save my Power Point 2010 from Excel VBA? Here I attach my Workbook. I already write code for save the PowerPoint but it does not work as what I …

525 views

Hi Experts,

I've got a fairly simple recorded macro that attempts to clean up a phone number list by removing "(", ")", "-" and spaces but while it is removing the "-" and spaces, it is not …

725 views

Permutations then count all the instances in your spreadsheet

need to count  all the combination of an 4 numbers combination
they are 24 combinations

for example  if i enter 1067  need count

718 views

Hi Experts,

So, I want to use VBA to color the cell in Column C of Sheet1 if 1st three numbers * (Area Code portion of the phone #) match any of the numbers in  Column A (Area Code) on Sheet2. I'd …

2241 views

Permutations then count all the instances in your spreadsheet

need to count  all the combination of 2 numbers

for example  if i enter 67  need count

67 how many
76 how many  ocurrence in …

819 views

I was wondering if anyone could please help me with creating a userform through my pre-established workbook to allow me to add data to any worksheet of my choosing through one User Form.

Thanks for…

418 views
Show more content
201506-LO-Top-001

Microsoft Excel

130K

Solutions

192

Articles & Videos

37K

Contributors

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Related Topics

  1. Microsoft Office
  2. Visual Basic Classic
  3. VB Script
  4. Microsoft Applications
  5. Spreadsheets
  6. Microsoft Access