I am using the Vlookup function looking up values in a Pivot Table. The
problem I have is the column that I want to return is continuously changing.
i.e the col_index_num one day maybe 12 and the next it may be 13 and so on as
the pivot table grows. Does anyone know how I can ...

I have a workbook that creates a monthly task calendar in one of the
spreadsheets.  in that sheet, there is a list of tasks in Column A, while
Column B contains the formula :
=IF(ISERROR(VLOOKUP(A3,'calendar~data'!$B$5:$O$36,14,0)),"",VLOOKUP(A3,'calendar~data'!$B$5:$O$36,14 ...

i need to create a drop-down list using the name of the workbook existing in
a folder, so i can select one of them and run a macro...i saw this action
once but i can't do it, i don't know where are these options...and when you
add a new file or workbook to the folder ir appears ...

I'm trying to figure out a better way to do this - since the formula is
already too long for the cell (and I don't want to split it between two
cells, I want to find a better, more automatic way.
So this is my formula (same thing repeated with more cells)

How can I have excel go to defined cells when pressing ENTER after entering
info in a cell
(from cell Aa1 input info press Enter and go to H16 to input info in that
cell press ENTER  go to A45 and so on)

This function works:
=SUMPRODUCT(AND(($H$9<>"x"),($C$9+30<TODAY()))*($D$9=D77),$E$9)
But when I update it to this one, it gives a $0 result and there
should be a number.

I have reviewed every Vlookup post and I don't think I have seen this type of
question.
I have "groups of information" on Sheet 1:
Columns B-G, K-P, T-Y, AC-AH, AL-AQ, AU-AZ, BD-BZ, BM-BR, BV-CA

For the sake of expediency let's say I have 2 worksheets. 1 is the master
sheet that I use for data input on a monthly basis. #2 would be an individual
sheet that a line on #1 refers to. Each month I enter data into 7 cells in a
row on sheet 1 and the info goes to the respective ...

I am wondering if 3D references for the MODE function work? I tried to find
the mode of a bunch of numbers across multiple worksheets using this function
but keep getting a #REF! error.

I would like to alternate footer layout in an Excel document. Is this possible?

Just realized, I also need help with another aspect of my project.  I
need to print a report which always refers to the previous Thursday.
Specifically, in the header I have "Report for (Date)" where (Date) is
the previous Thursday.  I'd like to automate the dating process as I

I know that I am charged 14.99 for every shipment I am sent.  I also know
that a shipment can have either one or two units (a 14.99 charge either way).
If I know that 70% of my shipments are of two units, what is my per unit
shipping charge?

00456 Tickford Dr.---->456 Tickford Dr.
0785 Fort St.---------->785 Fort St.
000309 Old Rock Dr.-->309 Old Rock Dr.
How do I remove the leading zeros for these addresses?

I'm just a beginner at writing macros.  And I'm really lost with proper
syntax in order to point to the desired directory location where we need the
file saved.
I recorded the macro, and then edited respective to tab names, etc.  I'm

I have two worksheets
Worksheet 1 has a summary of data that is gathered from worksheet 2
(detailed data)
Worksheet 2 has the date in the A column and data for each day in