Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello!
I have a detailed sheet called "Receipts" that I enter employee name and amount they spent. Another worksheet called "Summary" that has employee name, Credit limit, how much they used, and balance. I would like to be able to enter information in the "Receipts" worksheet and have it automatically find the employees name on "Summary" worksheet and automatically enter the total amount they used under the "Used" column in "Summary" worksheet. Example: "Receipts" worksheet in column A=NAME and column I=TOTAL SPENT. "Summary" worksheet in column A=NAME and column F=USED Thanks for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use detailed data in one worksheet to create summary data as chart source | Charts and Charting in Excel | |||
Creating a Detailed List from a Summary List | Excel Worksheet Functions | |||
automatically updating summary worksheet | Excel Worksheet Functions | |||
automatically updating a summary worksheet | Excel Discussion (Misc queries) | |||
Copying info entered on one worksheet automatically to another | Excel Discussion (Misc queries) |