I've written the attached code and can't figure out what i'm doing wrong. I'm trying to copy, sort, and paste information from a bunch of sheets. The below code goes into a death spiral copying and pasting only from the first sheet in my workbook. What's wrong with my code? Why won't it continue through the loop?
Please Login or Register to view this content.
Last edited by sjennings007; 12-23-2015 at 06:55 PM.
simply loops through each of the sheets in the workbook. The easy way, but slow and inefficient, is to select the sheet as the first line of code in the loop.Please Login or Register to view this content.
Better would be to use With sh ... End With and "connect" the ranges using a "dot" (.)
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
That worked, kinda. now the sorting (if statements) isn't working. it just lumps it into my "else" statement.
Can you post the current code?
If posting code please use code tags, see here.
I think I figured it out. Thanks for the help.
You're welcome. Thanks for the rep.
I'm struggling to picture what your workbook, worksheets, data and structure look like. Where's the data start and finish? I can see you want to copy and transpose data but I'm confused about what you need to end up with.
Suggest you post a sample workbook with some typical data.
Regards, TMS
We have a spreadsheet for every customer. I'm trying to copy the information into one spreadsheet in a database format. Since the customers may be located in different locations i'm trying to separate the information between the three regions. The info is confidential, but that's the lay of the land.
Mock it upThe info is confidential
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks