Forum Discussion
Siva29prakash
Nov 05, 2019Copper Contributor
Excel indirect reference to normal reference
Greetings everyone, I am creating a employees current position list in Excel. I have already got their full details in a Excel workbook for each containing personal details, education, experienc...
JKPieterse
Nov 05, 2019Silver Contributor
Are all the 200 files in one folder?
- Siva29prakashNov 05, 2019Copper Contributor
Thank you for reply.
Yes, all the files are in one folder.
Since I have all my employee ID and as the employee ID will not be continuous. I have listed it in a separate workbook in "Sheet1's" A column and with indirect reference like shown below for "Date of birth"
=indirect("'["&$a2&"]personal_details'!$B$6",1)
Similarly for the "Date of joining"
Is there any other way with direct referencing so that I will not having the problem to open all the 200 employee files at the same time.
While replying this I got a idea that can we concate this to a text and make it workable.
Let me try this and reply you.
Thanks in advance.
With regards,
Sivaprakash