Type in one cell and data copies into another cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two worksheets that will be holding the same information, but in a
different order. I would like to be able to type the data into worksheet1
next a specific heading and on worksheet2 it copies next to the same heading
(although its on a different row). Hope ya can help!
 
You can do this with a worksheet_change macro. Right click sheet tab>view
code>left window select worksheet>right window select worksheet_change. fill
in your macro
 
Look at VLOOKUP:

=VLOOKUP(A3,Sheet1!A:B,2,0)

Assumes headers/data in columns A & B of Sheet1

A3 on Sheet2 contains the header

VLOOKUP returns value corresponding to A3 header from column B on sheet1

HTH
 
Back
Top