Dear Friends,
Is there a macro I could record for Copying Row Data & Insert 3 Rows & Paste Copied Data In Those Rows?
I have to add these 3 rows based on certain values in Column A. Presently, if I find that value in Column A, e.g. if the value is in row 5, I select 3 rows below Row 5 then do ALT + I & R to add 3 empty rows. Then copy Row 5 and paste in newly created rows.
Can this function Alt + I & R and Copy & Paste be done in a macro?
I tried macros but it goes back to original Row where macro was recorded.
Thank you
Bookmarks