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?

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?

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?

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?