Macro/Pivot Table Help

[forexcellence13]

Hello there,

Excel 2007/Excel 2003 is fine. I have a 2007 file though.

I need help with regard to a macro or pivot table whichever one you think solves my problem

The scenario is such that I need to calcualte the Net Cash Amount received and the Dollar amount bought by each girl.

The first table is for the Net Cash Amount and the second one shows the Dollar Amount bought.

I was hoping if you guys could help me design a macro or pivot table to calculate this using the data in Range A1:F11 .

Please help me.

Thank you so much in advance

[micope21]

Hi

Please click on attachment

Use Sumproduct. Have a look at workbook.

Thsi what you looking for?

[oeldere]

Or with an pivot table.

See the attachment.

[forexcellence13]

Could you please do me a favour by saving the file in a different format? For some reason I am unable to open it. Thank you in advance and thanks a lot for your response.

[forexcellence13]

I am unable to open both spreadsheets. Please help me by saving it in a diffrent format. I am confused as to why this is happening .

[forexcellence13]

Could you please do me a favour by saving the file in a different format? For some reason I am unable to open it. Thank you in advance and thanks a lot for your response.

[oeldere]

Sorry i didn't look at your excel version (which is 2003 for you).

[forexcellence13]

Thank oeldere for changing the format, that helped me a lot.

Micope 21: thank you for helping me with the first table. I was hoping if you guys could help me with regard to designing a macro to generate the data for the first table which calculates the net amount of cash received as in which automatically prints the product bought and the person buying and selling and the net cash received in a tabular manner as you have shown just now.

Thank you so much in advance and thank you guys for your help.

[micope21]

Try this one

[forexcellence13]

Thank you for that micope21