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.
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
I understand that Power Query seems to be the better approach over VBA.
You really helped a lot.
it's much apprechiated.
Cheers
Troy