Hello,
I have created a workbook, containing about 120 worksheets.
I would like to copy the data in rows 83 and 84 in a worksheet called 'Sjabloon' to rows 83 and 84 of several other worksheets.
I thought it would be easy to use a macro and creating a shortcut key to easily copy the row into the worksheet I activate, but when I record the macro, the worksheet I pasted the rows in while recording is used in the formulas with its name, so the macro doesn't work in the other worksheets.
This is the macro I get when recording it:
So my problem is, that I don't want the specific sheet "Alda Pinxten" to be in the formula. I want [I]the worksheet I activate before pressing the shortcut key[I]to be in there instead, so that I can paste the rows onto rows 83 and 84 of every worksheet I click on.
To be as specific as possible:
I would like it to be so, that if I activate a certain sheet and then press Ctrl+Shift+F, rows 83 and 84 of the worksheet called 'Sjabloon' get pasted onto rows 83 and 84 of the active sheet.
Can anyone help me with this?
Thanks a lot in advance!
Bookmarks