lPinkFloyd
Board Regular
- Joined
- Nov 22, 2003
- Messages
- 92
I have a workbook with several sheets that are formatted the same. I also have a sheet that has some rows that have no data in them except text in one of the cells. The rows I am coping have the same format as the sheet I am inserting them in. I need to copy the rows because the format of the sheets (color).
Presently I select and copy the rows, then I return to sheet I want to insert them in using Insert Copied Cells from the right click menu.
This works out fine, but I would like to make a macro button that would copy the rows and insert them in the row I select.
Presently I select and copy the rows, then I return to sheet I want to insert them in using Insert Copied Cells from the right click menu.
This works out fine, but I would like to make a macro button that would copy the rows and insert them in the row I select.
