Searching Column Question

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

Hi All,

I'm having a problem searching some of my excel sheets and hope someone
might have a way to do this. I need to search a workbook with multiple
sheets for a specific value only in one column. For an example I have
a inventory workbook with lots of sheets. All sheets have a column for
barcodes (column F) and I need to search this column for a specific
barcode number on all sheets simultaneously. Can this be done?
Thanks.

Brad
 
Brad
I don't believe you can limit your search to only one column on each
sheet without VBA. But if the barcode numbers appear only in one column of
each sheet, then it wouldn't matter if you searched all the columns.
To set up a search of all the sheets, select one sheet. Then hold down
the Ctrl key of your keyboard and select all the other sheets you want to
search. This is called grouping the sheets. Let the Ctrl key up and do
Edit - Find. HTH Otto
 
Otto/Brad

Excel 2002.

I set up three identical columns on each of four sheets.

Grouped the four sheets.

Selected entire middle column(B) on sheet1 of grouped sheets..

Edit>Find>criterion>Find all.

Excel Find returned only those found in Column B of each sheet.

Gord Dibben Excel MVP

Brad
I don't believe you can limit your search to only one column on each
sheet without VBA. But if the barcode numbers appear only in one column of
each sheet, then it wouldn't matter if you searched all the columns.
To set up a search of all the sheets, select one sheet. Then hold down
the Ctrl key of your keyboard and select all the other sheets you want to
search. This is called grouping the sheets. Let the Ctrl key up and do
Edit - Find. HTH Otto
Click to expand...
 
Thanks Gord. That's a new one for me. Otto
Gord Dibben said:
Otto/Brad

Excel 2002.

I set up three identical columns on each of four sheets.

Grouped the four sheets.

Selected entire middle column(B) on sheet1 of grouped sheets..

Edit>Find>criterion>Find all.

Excel Find returned only those found in Column B of each sheet.

Gord Dibben Excel MVP
Click to expand...
 
Back
Top