| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I copy automatically from one worksheet to another
at the moment I am keeping all my records and accounts on one worksheet but I
think it would be easier to keep separate worksheets, but this would require being able to automatically copy from one worksheet to another. Can this be easily done? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I copy automatically from one worksheet to another
Do not try to copy everything - this is a total waste.
To get a value from cell A1 in a worksheet called July to another worksheet use the formula =July!A1 This is best done with pointing: type =, open July and click cell A1, press Enter of use the green arrow on the Formula Bar Note that if the worksheet name has a space it in, you need ='Car accounts'!A1 The pointing method does this automatically best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "macthead1" wrote in message ... at the moment I am keeping all my records and accounts on one worksheet but I think it would be easier to keep separate worksheets, but this would require being able to automatically copy from one worksheet to another. Can this be easily done? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I copy automatically from one worksheet to another
Probably best to keep on one worksheet and learn how to use
datafilterautofilter. -- Don Guillett Microsoft MVP Excel SalesAid Software "macthead1" wrote in message ... at the moment I am keeping all my records and accounts on one worksheet but I think it would be easier to keep separate worksheets, but this would require being able to automatically copy from one worksheet to another. Can this be easily done? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I copy automatically from one worksheet to another
This works a treat!! many thanks for your help
"Bernard Liengme" wrote: Do not try to copy everything - this is a total waste. To get a value from cell A1 in a worksheet called July to another worksheet use the formula =July!A1 This is best done with pointing: type =, open July and click cell A1, press Enter of use the green arrow on the Formula Bar Note that if the worksheet name has a space it in, you need ='Car accounts'!A1 The pointing method does this automatically best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "macthead1" wrote in message ... at the moment I am keeping all my records and accounts on one worksheet but I think it would be easier to keep separate worksheets, but this would require being able to automatically copy from one worksheet to another. Can this be easily done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically copy new data to different worksheet | Excel Discussion (Misc queries) | |||
| Automatically copy data from one worksheet into another | Excel Discussion (Misc queries) | |||
| Automatically copy the file name to the worksheet tab | Excel Discussion (Misc queries) | |||
| Automatically copy data from one worksheet to another | Excel Worksheet Functions | |||
| automatically copy data from one worksheet to another | Excel Worksheet Functions | |||
Linear Mode
