lookup
Apply Autofilter to column B and select x from the filter pull-down.
Then highlight the visible data (just the columns you want to take)
and click <copy then <paste this into the new worksheet.
Hope this helps.
Pete
On Nov 13, 9:40*am, jy wrote:
Hello
i'm not sure which function i should use.
column A has numbers from 5000 to 5999
column B i have put a "x" in the cell of the row i wish to populate the
other worksheet
column C last name
column D first name
and so on
in the other worksheet i would like to populate only the row that have the
"x" in the cell
i would also like to populate only certain column of that row in that new
spreadsheet
thank you
JY
|