How do I create automatic cell movement when using excel

B

babykates

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.
 
B

BrianB

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
 

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

Merging from an Excel file with graphics 1
Excel does not accept text format! 0
How do I clear a form? 0
How to make different cells fill in automatically from one entry? 3
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
How do I tally numbers, of a specific expense category? 3
creating linked lists in Excel 2
Cells not updated automatically 3

Top