Need help With Entering dATA

[bookkeeper1]

I'm trying to enter a specific type of data in (i.e) A3 and would like
it to automatically go to ae3 at the same time, not quite sure what
formula to use. I'm entering payroll into a worksheet and the entries
are random depending on the the check stubs, any help would be greatly
appreciated Thanks

 

[Fabian]

I'm trying to enter a specific type of data in (i.e) A3 and would like
it to automatically go to ae3 at the same time, not quite sure what
formula to use. I'm entering payroll into a worksheet and the entries
are random depending on the the check stubs, any help would be greatly
appreciated Thanks

In cell AE3, you type =A3

That should solve this problem.

 

[bookkeeper1]

How would I key in categories in an expense summary? (i.e.)
Cell d3 is category description such as rent, when I enter the amount
in d4 such as 750. I want it to go to a specific cell as ae4
I do i reference the cell so when I enter a category in d3 it knows
what cells to automatically fill in such as d3=rent.d4=amount and
ae4=amount again for double entry bookkeeping
Thanks for any help in advance.

 

[Fabian]

How would I key in categories in an expense summary? (i.e.)
Cell d3 is category description such as rent, when I enter the amount
in d4 such as 750. I want it to go to a specific cell as ae4
I do i reference the cell so when I enter a category in d3 it knows
what cells to automatically fill in such as d3=rent.d4=amount and
ae4=amount again for double entry bookkeeping
Thanks for any help in advance.

English isn't your first language is it? Could you rephrase the
question, because I must confuse that I can't understand it.

 

[bookkeeper1]

fabian
Thanks for your answer works great
Ken

 

[Gord Dibben]

English isn't your first language is it? Could you rephrase the
question, because I must confuse that I can't understand it.

confuse? confess? which is it?

Not too clear in itself Fabian. English as a second language?

Gord

--

Gord Dibben Excel MVP XL2002

 

[Fabian]

confuse? confess? which is it?

Not too clear in itself Fabian. English as a second language?

Ah, Skitts Law in action. Any post crtiticising someone for
spelling/grammar will itself contain such a mistake

 

[Gord Dibben]

Yep.

Skitt's Law? Is that similar to Murphy's Law of dimishing returns?

Gord