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!

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!

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!!