I have 2 sheets with a column of unsorted names.
example
I have the name Final Assault in cell AP1840 of the first sheet. In cell AS1840 I want to print the data for final assault from column F of the second sheet(called sheet2). The title Final Assault occurs in column E of sheet2.
I need to drag the formula down in the first sheet.There are some blank rows in the first sheet.Many of the titles in the first sheet
will not be in sheet 2.
The data in neither sheet can be sorted.
Thanks very much
Chester12
example
I have the name Final Assault in cell AP1840 of the first sheet. In cell AS1840 I want to print the data for final assault from column F of the second sheet(called sheet2). The title Final Assault occurs in column E of sheet2.
I need to drag the formula down in the first sheet.There are some blank rows in the first sheet.Many of the titles in the first sheet
will not be in sheet 2.
The data in neither sheet can be sorted.
Thanks very much
Chester12