| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Detailed worksheet value entered automatically in Summary workshee
I am not sure how your recipts worksheet has values. However, one of the
below should help On summary worksheeet in column F, enter this formula... =VLOOKUP(A2,Receipts!A2:I25,9,FALSE) or =SUMIF(Receipts!A2:A25,Summary!A3,Receipts!I2:I25) HTH, -- Pranav Vaidya VBA Developer PN, MH-India If you think my answer is useful, please rate this post as an ANSWER!! "Victoria" wrote: 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Detailed worksheet value entered automatically in Summary work
Hi Pranav,
Thank you so much for your help!! I ended up using =SUMIF. "Pranav Vaidya" wrote: I am not sure how your recipts worksheet has values. However, one of the below should help On summary worksheeet in column F, enter this formula... =VLOOKUP(A2,Receipts!A2:I25,9,FALSE) or =SUMIF(Receipts!A2:A25,Summary!A3,Receipts!I2:I25) HTH, -- Pranav Vaidya VBA Developer PN, MH-India If you think my answer is useful, please rate this post as an ANSWER!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
