How to auto data from one work to another worksheet.
 

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

How to auto data from one work to another worksheet.
 

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.
--
David Biddulph

"Vik" wrote in message
...
I am trying to auto fill information from one worksheet to another
worksheet
(only select item to this worksheet). Please advice any good solution.