how do I copy automatically from one worksheet to another

[macthead1]

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?

 

[Bernard Liengme]

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

 

[Don Guillett]

Probably best to keep on one worksheet and learn how to use
data>filter>autofilter.

 

[macthead1]

This works a treat!! many thanks for your help

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