View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Frank T Frank T is offline
external usenet poster
 
Posts: 2
Default matching data on worksheet

I am trying to match data from column a to rest of worksheet, (b-av), 22
columns.
Weekly, the office sends an inventory workbook containing approx 5000 rows
and columns from a to av (22 columns).
I then insert a new column (A) and paste item numbers I want to find in the
rest of the worksheet, columns b-av, and 500 rows.
I want to match my selected items from column a to all in the information in
the rest of the worksheet of 5000 rows and 22 columns.
How do I do this?