Hi,
The attached file contains a stripped down version of a report summary. As a novice I am just not getting the iteration code right so that at the end of each row brought to the Report page has its sheet name added in a final column (column N). It seems to be looping but not capturing the correct sheet name i.e. It is doing 1st, 2nd, 3rd Sheet then 1st, 2nd, 3rd Sheet again rather than 1st , 2nd, 2nd, 3rd, 3rd, 3rd Sheets.
Any help would be appreciated thank you.
Last edited by Sorjas; 07-18-2014 at 06:23 AM.
Hi Sorjas
Try this Code
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Thank you John. The rewritten code has worked a treat and I am very grateful.
From my understanding and it maybe wrong lol.
1. This line of code is adding the sheet name in the loop:
2. I notice when stepping through the lines of code the rows are copied to the report tab and only the first row of each sheet has the sheet name added. The code then calls routine Fill_Blanks which appears to go back and look at what cells are blank in column N (missing the sheet name) and adds these below the last row above that has that sheet name?Please Login or Register to view this content.
If I have not understood the way the code you have kindly provided is actually working, please let me know. Thank you once again!
Darren
Hi Darren
Your analysis of what the Code is doing is correct.
You're welcome...glad I could help. Thanks for the Rep.
Solved - please delete post.
Last edited by Sorjas; 07-22-2014 at 02:18 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks