Hi there, I wondered how I could copy and paste the following code for 4 rows and then start the new code and copy that for 4 rows and so on and so forth. I have 1000's of rows to do this with so I would like this automated if possible.
Thanks!
631610
row
row
row
row
611310
row
row
row
row
611610
i cant see any sequence there
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hi Martin,
its like this
612130
612220
612230
612110
There are 4 rows in between each sequence and I need to copy and paste them down but I have thousands of lines.
use another column assuming your data starts in say a2 in say b2 put =a2 in b3 put
=IF(A3="",B2,A3) fill down to end. you can copy and paste special/ values over the original then delete the column
Last edited by martindwilson; 12-15-2012 at 05:07 PM.
Thanks Martin, Perhaps I am doing it wrong, I have a circular reference....
you wont if you follow the instructions! what have you put and in what cells
Last edited by martindwilson; 12-15-2012 at 05:11 PM.
Thanks Martin, it was me being an idiot, it works!!! Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks