Forum Discussion
Solved
Pulling multiple data to auto fill in another worksheet
Hi, apologies if this has been asked before but I don't seem to find the answer and if it is possible at all. I have a spreadsheet with multiple tabs for a workload allocation (one per staff memb...
- Thank you so much - I have been thinking about this for hours
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
Try using a formula like this....
- Thank you so much - I have been thinking about this for hours
Glad you were able to get it working. Please feel free to post back to the community in the future if you have any other questions.