Copy worksheet ---> worksheet

  • Thread starter Thread starter EHansen
  • Start date Start date
E

EHansen

Hi All,

I have 3 Worksheets in 1 Workbook....

the worksheets are known as...:
(1). Manifest
(2). Deliveries
(3). Stuffing

each worksheet has at least 2 columns that will have the sam
information as the others..for example:
Manifest has 1 column (A) named Receipt Number, Deliveries and Stuffin
also have 1 column that has this column as well.

My question is, what formula do I need to apply so that when
introduce the Receipt Number in Manifest's Receipt Number column i
will automatically be introduced in Deliveries and Stuffing's Receip
Number Column? That way I dont have to be introducing manually the sam
info 3 times...

Any help would be greatly appreciated...

Thanks and brgds
 
Assume Manifest A2 is first receipt number.

On Deliveries sheet in A2 enter =Manifest!A2

On Stuffing sheet in A2 enter =Manifest!A2

Drag/copy these down column A as far as you need.

Note: if nothing in Manifest cells, you will see zeros in the other two
sheets.

Either go to Tools>Options>View and uncheck "show zero values" or re-write the
formulas to

=If Manifest!A2="","",Manifest!A2

Gord Dibben Excel MVP
 
Back
Top