Detailed worksheet value entered automatically in Summary workshee

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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,
 
Back
Top