| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto filling data according to seperate worksheet | Excel Discussion (Misc queries) | |||
| Auto fill for data from another worksheet | Excel Discussion (Misc queries) | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
| eliminate data entered to a worksheet that copies to another work. | Excel Worksheet Functions | |||
| Auto Filter will not work in a new worksheet | Excel Worksheet Functions | |||
Linear Mode
