Hi,
I don't even know if this is possible?
I am wanting to create an excel document that uses the contents of a cell to decide which worksheet in another workbook to lookup to.
Basically, it would look something like this:
So, in the first instance, In line 1, I am want to do a lookup using SKU 1 in the other workbook ( in the source file, each SKU will have its own worksheet).
I am then wanting to count how far down the queue they are (they will be in date order). The user will add in the SKU details and order no. The Workbook name can be done easily using vlookup, its the orders before this order that I don't know how to do - and this is the one linked to the SKU worksheet which is changeable
Please can anyone help?
I don't even know if this is possible?
I am wanting to create an excel document that uses the contents of a cell to decide which worksheet in another workbook to lookup to.
Basically, it would look something like this:
| SKU | Order No | Workbook name | Orders before this order |
| 1 | 1234 | Test 1 | 245 |
| 2 | 1547 | Test 2 | 564 |
So, in the first instance, In line 1, I am want to do a lookup using SKU 1 in the other workbook ( in the source file, each SKU will have its own worksheet).
I am then wanting to count how far down the queue they are (they will be in date order). The user will add in the SKU details and order no. The Workbook name can be done easily using vlookup, its the orders before this order that I don't know how to do - and this is the one linked to the SKU worksheet which is changeable
Please can anyone help?
