LinkBack URL
About LinkBacks
Hi Experts! I'm have a workbook with 152 sheets and i'm trying to copy the last 6 columns of these sheets into 1 sheet. Other than doing manually, is there a formula? I'm totally zero when it comes to macros... Thanks in advance!
Hi Experts! I'm have a workbook with 152 sheets and i'm trying to copy the last 6 columns of these sheets into 1 sheet. Other than doing manually, is there a formula? I'm totally zero when it comes to macros... Thanks in advance!
Hi and welcome to the forum
Having 152 sheets to begin with sounds insane - how do you even find anything??
to be able to make suggestions on combining the last 6 sheets, we will need some idea of whats on them, and how you want them combined?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi Ford.... Thanks for the welcome! It's actually a catalogue.... i had it converted from pdf to excel.. that explains the number of pages.the last 6 columns of every sheet have, i presume, the same header.. and i want to combine it into 1 sheet for ease of use... is it possible?
so, do you want to combine all column H (for instance) into 1 column, or will you be having 152*6 columns on the new sheet?
what is in these columns?
it's 1 sheet with 6 columns.... of all 152 sheets... how do i upload the file here? Thanks!!
Hi Ford, managed to upload the file but had to delete some pages as it was above the limit...
Try this untested code with a dummy workbook instead of the original file or duplicate the original file and try it...
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi! Unfortunately no...
Prompt :
Run-time error '91':
Object variable or With block variable not set
Change this line
ToPlease Login or Register to view this content.
Please Login or Register to view this content.
Hi Guru! THanks!!! Got it!! Much appreciated!
Glad it helps you and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks