How to put field A into field whatever I want

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I'm converting a paper ledger to excel and in some cases I have to retype
the amount field into another column to categorize some of the expenses. IS
there a formula or somethin I can type in that field so that if I do happen
to change the value in field A it would automatically copy over?

Thanks
 
Oh, an incase more information is required. this is basically my field
structure

Amount, Memo, Check #, Category A, Category B, etc.
 
Hi Rob

You could type =A2 in cell D2 for example to have the same amount show
under Category A.
If you wanted to split the amount between Category A and Category B,
then
=A2*.75 and =A2*.25 would put 75% of the Amount to Cat A and 25% to
Cat B

Repeat using A3, A4 etc as you move down the sheet.
 
Back
Top