Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating Pageheaders Using Vertical Lookups
I have a data table with dates in it. I need to populate
the page header using a lookup table. For Example: Date: feb Table with dates: Jan 01/01/03 feb 02/01/03 apr may Data Table Code: 001 002 003 004 1/1/03 02/01/03 03/01/03 For Example, I want to look up code 004 to get the date listed as Feb in the table with dates and stick it in a page header. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating Pageheaders Using Vertical Lookups
Activesheet.pageSetup.LeftHeader = Application.Vlookup(something,
tableref,2,false) Regards, Tom Ogilvy "Marc" wrote in message ... I have a data table with dates in it. I need to populate the page header using a lookup table. For Example: Date: feb Table with dates: Jan 01/01/03 feb 02/01/03 apr may Data Table Code: 001 002 003 004 1/1/03 02/01/03 03/01/03 For Example, I want to look up code 004 to get the date listed as Feb in the table with dates and stick it in a page header. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a vertical report export into a vertical report? | Excel Discussion (Misc queries) | |||
Vertical line isn't vertical! | Charts and Charting in Excel | |||
Vertical line isn't vertical! | Excel Discussion (Misc queries) | |||
Vertical line in a histogram (vertical bar chart) | Excel Discussion (Misc queries) | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions |