How to auto data from one work to another worksheet.

V

Vik

I am trying to auto fill information from one worksheet to another worksheet
(only select item to this worksheet). Please advice any good solution.
 
D

David Biddulph

Click in the destination cell on the destination worksheet. Type an = sign.
Go to the source worksheet, and click in the source cell. This will put the
reference of the source worksheet and cell in the formula bar of the
destination cell after the = sign. (Something like =Sheet1!A5, or ='Sheet
2'!J6 with quote marks if the worksheet name includes spaces.) Tick to
accept.
 
Top