LinkBack URL
About LinkBacks
Hello,
I'm looking for a basic macro code that can help loop through all the worksheets except "Summary" Sheet and "Consolidated" Sheet to copy a range C14 to CH & lastrow data to the "Consolidated" Sheet.
Thank you for your help.
Hello,
I'm looking for a basic macro code that can help loop through all the worksheets except "Summary" Sheet and "Consolidated" Sheet to copy a range C14 to CH & lastrow data to the "Consolidated" Sheet.
Thank you for your help.
Maybe:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
I got error reported back on line c= ..... Just to clarify, I would like data from all the worksheets excluding the Summary and Consolidated sheet range from A14 to the last row of CH copy and paste to consolidated sheet.Originally Posted by xladept
Try:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Oh, I didn't get it - looks like Mumps has given you the solution - maybe next time
It worked great. Thanks guys.
You're welcome and thanks for the rep!
My pleasure.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks