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. |
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. |
All times are GMT +1. The time now is 12:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com