View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
roy.okinawa
 
Posts: n/a
Default Transferring data between worksheets

I need a formula that will allow me to do this:

Worksheet 2 is the master file and contains various information. Worksheet
1 is the input sheet. If Column A sheet 1 matches Column A sheet 2, copy
data from Column B sheet 2 and input into Column B sheet 1.

Is this possible? Thanks.