Forum Discussion
Machala Sentance
Jun 21, 2018Brass Contributor
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...
- Jun 25, 2018Thank you so much - I have been thinking about this for hours
Machala Sentance
Jun 25, 2018Brass Contributor
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
Matt Mickle
Jun 25, 2018Bronze Contributor
Try using a formula like this....
- Machala SentanceJun 25, 2018Brass ContributorThank you so much - I have been thinking about this for hours
- Matt MickleJun 25, 2018Bronze Contributor
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.