Surprised as I was the speed of my first question being answered i though i might pose another after another fruitless search
I have now 2 open sheets in the same workbook
sheet 1 contains 549 rows of data but after each row I need to paste the contents of sheet2 Rows 1-57 (inclusive)
So the psudo code would be
for each row in sheet1
paste sheet2(rows 1-57)
once again I am sure there is a simple way around it but i keep getting it wrong
Thanks
Last edited by diamanthian; 01-19-2013 at 10:23 AM. Reason: add psuedo code
Hi,
Do you mean that you want to ADD 57 rows after each row and paste rows 1:57 from sheet 2.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
yes,
I suppose it would be insert 57 blank rows after each row in sheet1
copy sheet2 row1:57 and paste into the new blank rows
recursively for each row in sheet1
so I would end up with 57 pasted rows after each of the initial 549 rows in sheet2
so sheet 1 would end up having 31293 rows
sorry if its confusing, I can see the numbers in my head, its just hard to put it into writing
for each row in sheet1
insert 57 blank rows after sheet1(current row)
copy sheet2(rows 1:57)
paste sheet2(rows 1:57) into sheet1(57 blank rows)
Next row [so would this become current_row +57?)
Hi,
Something like the following perhaps
Please Login or Register to view this content.
Again,
I can't thank the users of this forum enough!
it would have taken me hours to figure it out, and it would have been more long winded
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks