Quote:
Originally Posted by Spencer101
Hi,
This is easily done using INDEX and MATCH but it would rely on a slight change to your spreadsheet.
Rather than having just a month in row 2 and a year in row 1, if you combined them so the date in B2 on the orderbook tab showed as Jan-12 and all date cells followed that format, including the date cells on the data tab. Would that be suitable for you?
If so I will show the formula you need. If not I will have another think. :)
|
Hi Thanks for your reply, that sound like a good idea, i am not sure how to use index and match as i usually just use the Vlookup and Hlookup.
I would be bring the date in via SQL into a Excel template where a pivot table would be updated using refresh or a macro, the reason for the layout of the spreadsheet that it would be a pivot table of the order-book.
If we could not format in pivot table i could lok at bring the data into the spreadsheet via query and change the date there to Jan-12.
Ill have a look at this also,
Similar Threads
Threaded Mode
