Hi,
I am trying to pull values from one worksheet to another in the same workbook. The values required on Sheet1 are 30 rows apart. Is there a way of automatically adding 30 rows to the cell references on Sheet2?
Sheet1 values are in cells A30, A60, A90, A120, A150, A180, A210 etc.
The values from these are required in Sheet2 as follows:
Sheet1 A30 - Sheet2 A1
Sheet1 A60 - Sheet2 A2
Sheet1 A90 - Sheet2 A3
Sheet1 A120 - Sheet2 A4
Sheet1 A150 - Sheet2 A5 etc.
Simply dragging down the formula after adding several entries unfortunately doesn't work.
Any ideas?
Bookmarks