Hi All
I have a workbook with multiple rows. I want to create multiple pages of sheet 2 based on how many rows I have in sheet 1. Then import information from each row on sheet 1 into various cells in sheet 2. Can anyone help me please. I have seen lots of thread on creating multiple sheets but I want to duplicate pages of a worksheet within itself. I am in a bit of a bind with time so any help would be grately appreciated. TIA
ItsAllBee,
Something like this should work for you. It wasn't readily apparent what column in 'Sheet1' populates which fields in 'Sheet2'. You should be able to replace the text entries ("Date", "Order Ref", etc) with the actual cell references. I included how to do so as comments in the code:
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
You are a God send! There was a missing End If statement but now works! Thank you so much :D
You're very welcome. Sorry about the missing End If, I put the code up untested
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks