| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) | |||
| Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
Linear Mode
