Insert copied row from another tab

[iepofanof]

Hi all,

I have a macro that copies a complete row (in this case row 2) and past it in a new row below the selected cell.
I've tried to move the row that i want to copy to a different tab but i didnt succeed.
So for example i want to have the information i want to copy in row 1 in tab X
copied to the row below a selected cell in tab Y
Can someone help? Thanks!!

Please Login or Register  to view this content.

[Kaper]

As I understand you have now active Sheet X and want to copy it a row below the cell which was active while Sheet Y was Active.
The active cell is related to ActiveSheet so you shall add activating the target sheet after copying row into clipboard

By the way - you seem to rely on pasting while inserting new row. I'd probably prefer separate these two steps - insertion of new row (if it's needed) and pasting of the clipboard contents.

[iepofanof]

Hi Thanks for the reply. I will try to explain what the macro does.
In the image below you can see the numbers.
1) i want to add an order on saturday (ZA) so i select one of the cells in row 15
2) i activate the macro with the button
3) The macro unhides the predefined basic orderform row nr 2, copies the complete row and hides it again.
4) it pasts the data in 16 row below the selected row 15

What i want is that step 3 is not in the same active sheet but in a different sheet. Also the unhiding and hiding part is not necessary anymore.

So to summarize the steps i want to achieve;
1) i want to add an order on saturday (ZA) so i select one of the cells in row 15 in sheet X
2) i activate the macro with the button in sheet X
3) The macro copies the predefined basic orderform row nr # from sheet Y.
4) it pasts the data in 16 row below the selected row 15 in sheet X

Hopes it makes more sense now?

Excel.png

[Kaper]

So if I understand the description, this shall do the job.
Note that first the empty row is inserted below cuttent selection nand then row2 from sheet Y is copied into this newly inserted row. (so in a sense points 3 and 4 are applied in reversed order)

Please Login or Register  to view this content.

I preparred a dummy test workbook

[iepofanof]

Wow! This is exactly what i needed. Thanks!! Also thanks for the tips.

[Kaper]

Perfect!
And thanks for marking thread SOLVED and for reputation point