Dear forum experts,
I have this issue of many worksheets (up to +20) and one sheet that has to sum it all.
I need a formula that look for the sheet name that = cell value and then gets the value into the correct row.
If the cell (A1) has text string of " Shop 01 Andrew" then look for sheet with same name and get the values from row range
I attach an example file with a result as well
Regards
Last edited by soli004; 07-29-2014 at 09:59 AM.
See attached
Can also use
Formula:
Please Login or Register to view this content.
Last edited by Hawkeye16; 07-29-2014 at 08:04 AM.
Despite the high cost of living, it remains very popular.
Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!
Thanks Hawkeye16,
Works as wanted
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks