Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,595
- Office Version
- 365
- 2016
- Platform
- Windows
I am struggling to code the following routine.
In worksheet 2, I have counted the number of rows of data and came up with a value. (eg. 25)
I need to copy these rows over to worksheet 1, which is dynamically named based on the cell value at A2 (WPE), but the available rows I have to paste to is 22.
So, as an example, if the number of rows needed to paste over to worksheet "WPE" is >22 (true), I need to insert 7 rows after row 8 (in "WPE"), ensuring these new rows hold the same formulae and formatting as the other 18.
In worksheet 2, I have counted the number of rows of data and came up with a value. (eg. 25)
I need to copy these rows over to worksheet 1, which is dynamically named based on the cell value at A2 (WPE), but the available rows I have to paste to is 22.
So, as an example, if the number of rows needed to paste over to worksheet "WPE" is >22 (true), I need to insert 7 rows after row 8 (in "WPE"), ensuring these new rows hold the same formulae and formatting as the other 18.
