I have a list of workbooks (customer requests) - placed in different folders, one per request)
folder has an increasing number
I want to create an overview excel sheet that reads the same values from each request workbook like:
each workbook is called
CR_1130.xlsx
CR_1131.xlsx
my idea is to put in the CR numbers (1130) in the overview sheet and then the sheet would use this as the reference for the lookups/index or how it should be done.
Can somebody help me with this?
folder has an increasing number
I want to create an overview excel sheet that reads the same values from each request workbook like:
type | name | by who | for whom | created | cust.req | del.time | |
1130 | |||||||
1131 | |||||||
1132 |
each workbook is called
CR_1130.xlsx
CR_1131.xlsx
my idea is to put in the CR numbers (1130) in the overview sheet and then the sheet would use this as the reference for the lookups/index or how it should be done.
Can somebody help me with this?