LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35
Default Detailed worksheet value entered automatically in Summary workshee

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use detailed data in one worksheet to create summary data as chart source rdemyan Charts and Charting in Excel 0 January 23rd 07 02:18 PM
Creating a Detailed List from a Summary List [email protected] Excel Worksheet Functions 0 September 7th 06 12:36 AM
automatically updating summary worksheet srpettew Excel Worksheet Functions 9 April 22nd 06 07:04 AM
automatically updating a summary worksheet srpettew Excel Discussion (Misc queries) 5 April 19th 06 06:14 AM
Copying info entered on one worksheet automatically to another Mpls501sMan Excel Discussion (Misc queries) 0 December 8th 05 04:36 PM


All times are GMT +1. The time now is 10:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"