How to search for a text string in one worksheet and have it return the whole row

  • Thread starter Thread starter Sheik Yourbootey
  • Start date Start date
S

Sheik Yourbootey

I need some help please.
I am working with a multi sheet workbook (sales forecasts from different
regions) and would like to be able to write a formula that looks in a
certain column (product line) for a text string on each spreadsheet. Once
it ids the text value i want to copy that row to the new spreadsheet.

Any suggestions from the wise ones on the board.

TIA.
 
Thanks for the pointer, however I am not too comfortable or familiar with
VBA. Is there anyway to accomplish this, even if its execution is
somewhat manual, with somekind of IF and COPY formula.

Please let me know.
 
well i need to copy it to a separate worksheet. not sure if there is any
distinction between that and diplaying it. i want to automate the
extraction of the data.
 
well i need to copy it to a separate worksheet. not sure if there is any
distinction between that and diplaying it. i want to automate the
extraction of the data.
Click to expand...

If I have a value in A1 and copy it to C1, then change the value in A1, the
value in C1 does not change.

If I have a value in A1 and put the formula =A1 in C1, then change the value
in A1, the value in C1 tracks the value in A1.

The former is copying, the latter is displaying.

Now that you know the distinction, can you answer the question?
 
Back
Top