excel - copying data to another worksheet

Scoflo

I have posted this on another site but no-one seems to be able to help. Any clever folk on here?

Bit late in the day but I have decided my current method of keeping accounts is a bit laborious. I have 3 pages - log, income received & employed earners. It has worked perfectly fine for the last couple of years but I would like to soup it up a bit.

I copy and paste, for example,

company name, fee, expenses due, date paid from page 1 to page 2.

Reading up I see I could enter

= on page 2 in say, company name,
click to page 1,
click the correct box,
hit enter

and then when I fill in one box it should automatically show in the other. Should. It doesn't.

I see i could totally rewrite my spreadsheets and group them, in which case and identical page would be set up of the info I want to transfer. I don't want to do this yet.

Needless to say i have got so sidetracked I haven't finished my accounts and the tax return date is fast approaching.

Can anyone help

Chippy_Minton

scottishflower2000 wrote:

= on page 2 in say, company name,
click to page 1,
click the correct box,
hit enter

and then when I fill in one box it should automatically show in the other. Should. It doesn't.

So for example Sheet2 A1 contains =Sheet1!A1. Change A1 on Sheet1 and A1 on Sheet2 changes to the same value. Maybe you have automatic calculation turned off. Tools - Options - Calculation.

stevemcol

do you mean when you want to validate an entry by whatever means (say click a check box or type Y in a cell), and it should copy across to another sheet?

Need_More_Money_2

scottishflower2000 wrote:

I have posted this on another site but no-one seems to be able to help. Any clever folk on here?

Bit late in the day but I have decided my current method of keeping accounts is a bit laborious. I have 3 pages - log, income received & employed earners. It has worked perfectly fine for the last couple of years but I would like to soup it up a bit.

I copy and paste, for example,

company name, fee, expenses due, date paid from page 1 to page 2.

Reading up I see I could enter

= on page 2 in say, company name,
click to page 1,
click the correct box,
hit enter

and then when I fill in one box it should automatically show in the other. Should. It doesn't.

I see i could totally rewrite my spreadsheets and group them, in which case and identical page would be set up of the info I want to transfer. I don't want to do this yet.

Needless to say i have got so sidetracked I haven't finished my accounts and the tax return date is fast approaching.

Can anyone help

That should work. What do you see in the box on sheet 2? When you click in the cell you should see (at the top of the page) an equation referring to your other sheet

Scoflo

Chippy_Minton wrote:

So for example Sheet2 A1 contains =Sheet1!A1. Change A1 on Sheet1 and A1 on Sheet2 changes to the same value. Maybe you have automatic calculation turned off. Tools - Options - Calculation.

Thanks, just checked, the automatic calculation is on. However..

Sheet2 A1 contains =
(only this and nothing more)
Sheet 1 A1 is simply an enter.

It shoud be the same value, but doesnt.

Scoflo

stevemcol wrote:

do you mean when you want to validate an entry by whatever means (say click a check box or type Y in a cell), and it should copy across to another sheet?

Thats it! I just want a duplicate of what is calculated or written in a certain box copied over.

Scoflo

Gosh. Tried on a different part of my practice sheet and it worked! Thanks ever so much:T . I will eat my tea and prcatice on different parts before i do it on the real thing.

Thanks so much again!!!