First, I'd like to say that this forum has been extremely helpful since I signed up - you guys are great!
Here is the current issue I'm having.
We have a report called Accounting Posting that's generated online for our POS system. We export to Excel, and it creates a file for us to download.
In that file, it lists many values (necessary, and unnecessary) - across 4 different Sheets.
The sheets are always named BF01, BF03, BF04, BF05 every time we run this report.
I created an additional sheet called AP Formula that runs a VLOOKUP across all the cells in the other sheets, to consolidate the information into 4 neat columns. The problem I have, is that whenever I copy the data from the AP Formula into a new document, or into another Accounting Posting report, it pastes it as
=VLOOKUP(A9, '[Accounting Posting 2013 - 03 - 21.xlsx]BF01'!G$1:H$60,2,FALSE)
Instead of
=VLOOKUP(A9, BF01!G$1:H$60,2,FALSE)
I tried using the Indirect function in conjunction with VLOOKUP but I could not get it to work
Here is the current issue I'm having.
We have a report called Accounting Posting that's generated online for our POS system. We export to Excel, and it creates a file for us to download.
In that file, it lists many values (necessary, and unnecessary) - across 4 different Sheets.
The sheets are always named BF01, BF03, BF04, BF05 every time we run this report.
I created an additional sheet called AP Formula that runs a VLOOKUP across all the cells in the other sheets, to consolidate the information into 4 neat columns. The problem I have, is that whenever I copy the data from the AP Formula into a new document, or into another Accounting Posting report, it pastes it as
=VLOOKUP(A9, '[Accounting Posting 2013 - 03 - 21.xlsx]BF01'!G$1:H$60,2,FALSE)
Instead of
=VLOOKUP(A9, BF01!G$1:H$60,2,FALSE)
I tried using the Indirect function in conjunction with VLOOKUP but I could not get it to work