I've made a sheet "Plan" with data and a corresponding sheet that's meant for printing "Printable Report" (with only the important info in it).
From time to time I want to insert new rows (data) in my sheet "Plan".
In the following macro the active cell in sheet "Printable Report" is not the corresponding active cell in sheet "Plan", unless I manually activate the corresponding cell.
So the inserted row in sheet "Printable Report" happens on the place where the cell was selected last time.
For example, cell C75 (row 75) was activated last time in sheet "Printable Report".
And now I want to insert a new row 24 between the current rows 23 en 24 in sheet "Plan".
With this macro the new inserted row in sheet "Printable Report" will take place in row 75 which is of course not correct...
How can I select the corresponding cell from the other sheet?
Using offset ?
Bookmarks