How do I create automatic cell movement when using excel
 

lIm using excel spreadsheet.On it i have a list of accounting data. I want to
create a short cut all entries relating to one expense are automatically
transferred to one column.The result will be that all expenses are
individually recorded in relevant columns.

Perhaps this will help.
Say Description in Column A and amount in column B.
Individual descriptions eg. Wages in column C across top row match
descriptions in column A.

Copy/paste this formula across and down from cell C2 :-
=IF($A2=C$1,$B2,0)


So if C1 contains 'Wages' and A2 contains 'Wages' the value from B2
will be put into C2, otherwise zero.


--
BrianB


------------------------------------------------------------------------
BrianB's Profile: http://www.excelforum.com/member.php...info&userid=55
View this thread: http://www.excelforum.com/showthread...hreadid=273900