Macro for making summary

[Neeraj]

Hi, I am a beginner in excel and facing a problem to write a suitable macro for a simple task.

To bring clarity about what i am trying to say, i have attached excel file also which contains the data.
File has two sheets (I) Eliminations (ii) summary
"Elimination" sheet has 9 columns. I want to make summary of this data in "summary" sheet. Summary sheet has 3 columns (I) Entry no. (ii) P&L Impact (iii) Remark .
P&L impact column will have sumtotal of Net Amount Column of "elimination sheet" for all those rows which have "PL" for each entry number.
Remark column will have remark corresponding to the entry number.
I have filled the summary sheet with how the data will look alike

Can anybody pls help?

[stanleydgromjr]

Neeraj,

Welcome to the ExcelForum board.

No file(s) attached.

Scroll down and see "Manage Attachments".


Have a great day,
Stan

[Neeraj]

Hi stan,

I have now attached the file. (not sure how it failed to get uploaded in last attempt)

Thanks in advance

Have a nice day.

Regards,
Neeraj

[Neeraj]

Can any body pls help...?

[Shijesh Kumar]

Why dont u create a pivot table ..

See the attachment..

[Neeraj]

No, Actually i want to do it with a macro because i have to use it as one component in a program.

Thats why i am asking for help writing a macro to do the relevant task.

Pls suggest me if it is possible or not.

[stanleydgromjr]

Neeraj,

What is the logic to get the data to the "summary" worksheet?


Have a great day,
Stan