Forum Discussion
Solved
Collect certain cell infos + name of sheet into a mastersheet
Hello, I have a very big excel sheet with 50+ tabs/sheets all labeled a certain way. I collected searchvolume of keywords and other informations like difficulty score. I'm able to get the to...
troyyy See attached.
I used Power Query to obtain all the sheet names from your file and copied them back into the Mastersheet. Then I entered the formulas as described earlier. It took about a minute to create this. I prefer PQ over VBA as it's more flexible and much easier. But that's a personal opinion.
Hey Riny van Eekelen,
that seems like doesn't work for me.
Or can you demonstrate it on the sheet?
My challenge is to collect the sheet name and then add from the individual sheet cells B400, C400 and D400.
When I add the formula to the sheet nothing happens.
I want to do this in bulk. And I feel like I need a macro to do this?!
Cheers
Troy
that seems like doesn't work for me.
Or can you demonstrate it on the sheet?
My challenge is to collect the sheet name and then add from the individual sheet cells B400, C400 and D400.
When I add the formula to the sheet nothing happens.
I want to do this in bulk. And I feel like I need a macro to do this?!
Cheers
Troy
troyyy See attached.
I used Power Query to obtain all the sheet names from your file and copied them back into the Mastersheet. Then I entered the formulas as described earlier. It took about a minute to create this. I prefer PQ over VBA as it's more flexible and much easier. But that's a personal opinion.
- Thanks Riny van Eenkelen, that helps a lot.
I understand that Power Query seems to be the better approach over VBA.
You really helped a lot.
it's much apprechiated.
Cheers
Troy