| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get items from sheet 3 to show up on sheet 1 and 2?
I am making a travel expense log for two people. I would like to be able to
be able to enter in the employees name and what they spent, and then have that also show on another sheet which is individualized. For example, if I enter in $50 for Sue and $30 for Bob on sheet three, I want $50 to show on Sue's sheet and $30 to show on Bob's. I know how to do your basic IF= function. What I need to do is make sure that no blank cells happen in between data entries. So if Sue only has two entries, they will show up as rows 1 and 2 on her personal sheet no matter their position on sheet 3. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
| Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
| OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
| Show values from other sheet | Excel Worksheet Functions | |||
| Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) | |||
Threaded Mode
