Is it possible to have a different footer on the bottom of each printed page that is printed from one tab? I know you can have the tab name be placed on the header/footer, but not sure if I can somehow create a different footer for the same worksheet
Tab name is Coil Pricing
3 page document
Page 1- footer to read HV-1A
Page 2- footer to read CV-9
Page 3- footer to read HV-1A accy
My only other option is to move this to Word where I know I can do this, but then I am back another question I posted once but with little luck and that is can you do a V-lookup from within Word for data stored in an excel file?