Forum Discussion
Pulling multiple data to auto fill in another worksheet
- Thank you so much - I have been thinking about this for hours
Hey Machala-
Hope you're doing well. I saw that you had some external workbooks referenced in your workbook. If you are trying to reference external workbooks using the INDIRECT() function, then both workbooks will need to be open. Otherwise the function can't process. i.e. INDIRECT() won't work if your workbook is closed.
If you have all of this information in one workbook this becomes much easier. If this is the case can you provide a better working example file that contains a before and after scenario, so the community members can test their solutions.
Hi Matt
Thanks for your reply, sorry didn't really make myself very clear - I think that I made it more complicated than it needed to be. What I need to know if it's possible with one formula to autofill all of the various cells in the summary sheet (copy attached) with the corresponding information in the WLA sheet without having to put individual formulas in each cell in the summary sheet - i.e. to almost read across the headers in the summary sheet and find the corresponding cell in the WLA sheet.
All the referencing will be within the same spreadsheet so hopefully this will make it much easier as you say.
Thanks for your help