In D4 of Sheet2 enter =IF(Sheet1!A1="","",Sheet1!A1)

Drag/copy across to F4


Gord Dibben MS Excel MVP

On Tue, 27 Nov 2007 17:12:00 -0800, DanO wrote:

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.