I have a database that I need to clean up.
I don't want to go through and delete all the empty rows as it will take me way too much time.
I have a 2 sheet spreadsheet. Sheet 1 has my raw database (names, address, phone number, etc). Sheet 2 will be used to collect data from sheet 1.
In sheet2 a2 i have done =Sheet1!A3 which returns the data 'John Citezen' (this is an example and not a real name), all good.
The next data I want to put in Sheet2 A3 is 12 cells below Sheet1 A3 (continues 24 cells below, 36cells below,48 cells below,etc). I don't know what formula to put in so that it will find my original cell (Sheet1A3) then bring back the data which is 12 rows below that cell.
I want to be able to put a formula in Sheet2 cell A3 which will bring the data from Sheet1!A15, then be able to drag that down to complete my data collection.
I have tried this in sheet2:
In Sheet2 cell A2 I have put the formula =Sheet1!A3 - This returns the persons name
In Sheet2 cell A3 I have put the formula=Sheet1!A15 - This returns the 2nd persons name
When i Highlight Sheet2 a2 & a3 and fill down, the following appears in Sheet 2 cell A4 --> =Sheet1!A5 which is not what i want. I want it to be =Sheet1!A27 --> and I want sheet 2 cell A5 to be =Sheet1!A39 and so on.
Thanks in advance for your time.
Bookmarks