Need help With Entering dATA

  • Thread starter Thread starter bookkeeper1
  • Start date Start date
B

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
 
bookkeeper1 said:
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.
 
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.
 
bookkeeper1 said:
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.
 
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
 
Gord Dibben said:
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 :(
 
Back
Top