How do I create automatic cell movement when using excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 matc
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 B
will be put into C2, otherwise zero
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make different cells fill in automatically from one entry? 3
creating linked lists in Excel 2
Cell to Cell Movement Speed 4
Excel display two dates in one cell - excel 2010 2
How do I ensure formulas automatically calculate after pasting 1
how do i set up an income and expenditure account in excel? 0
Inserting Lines Makes Formula Inactive 7
Excel form for expense reporting 8

Back
Top