How to Copy Specific Data from one sheet to another

[ALLUSE]

Hello Members

I have a excel sheet with two columns. First column has same word (e.g. Address) at cell A1, cell A8, cell A15.... Second Column has Addresses at B1, B8 and B15...... I want to get addresses B1, B8, B15 etc on second sheet at A1 cell, A2 cell and so on... Any formula or method... Please help

 

[Trebor76]

Hi ALLUSE,

Welcome to MrExcel!!

Put this formula into cell A1 of the tab you want the output in...

=OFFSET(Sheet1!$B$1,IF(ROW()=1,0,7*(ROW()-1)),0)

...and copy down as required. You may to change the sheet reference if the data in not in Sheet1 (where I've bolded).

Regards,

Robert