Type in one cell and data copies into another cell
 

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!

Type in one cell and data copies into another cell
 

You can do this with a worksheet_change macro. Right click sheet tabview
codeleft window select worksheetright window select worksheet_change. fill
in your macro

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"slavenp" wrote in message
...
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!

Type in one cell and data copies into another cell
 

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

"slavenp" wrote:

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!