Hi Guys,
I've asked around the office, googled and still can't find out how to go about this.
I have 2 worksheets, Sheet1 where information is entered and Sheet2 which extracts the key info and summarises and presents in comparable format.
The formulas that I'm having issues with are in Sheet2, and are as follows:
Cell B1 ='Sheet1'!E1
Cell B2 ='Sheet1'!E16
Cell B3 ='Sheet1'!E31
etc.
I need to continue this pattern downwards for 50-100 rows. Clicking and dragging simply increses the increment by 1 instead of 15 like I would need. Is there any way of simplifying this, as I don't really want to do this manually if possible?!!
Thanks in advance!
Bookmarks