If there were a lot of this I would use a macro but the "simplest" way is to
link with a formula in sheet 2 such as
=sheet1!a1
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DanO" wrote in message
...
I am making forms and want to know how to import information from sheet 1
to
sheet 2 or 3 or so on.
Like sheet one in A1 FIRST NAME:
B1 MIDDLE NAME:
C1 LAST NAME:

NOW ON SHEET 2 TO GET IT TO SHOW SAY IN D4 FIRST NAME:
E4
MIDDLE NAME:
F4
LAST NAME:
WHAT FORMULA WOULD I USE TO GET THE INFORMATION FROM SHEET 1 TO SHEET 2 OR
SO ON.

Same as with a number or what ever.

Does that make since?

DO
Hendersonville TN.