Create a summing up Report based on Three columns

Dear Friends,

I need to create a report based on three columns. I have explained in detail about my requirement in the attached sample workbook.

I hope someone will help me to solve the problem through VBA because the items & expenses may vary at times. Hence, I feel a Macro will be the best solution.

Thanks in advance,

yours, acsishere.

I'm not quite sure I really understand the requirements, but would't a pivot table be your ticket? Categorize and sum with a few clicks and refresh when the underlying source has changed.

/$0.02

Dear Sir,

Since my friend, who is going to use my project, is not that much familiar with PTs, I feel that a VBA code will be best suitable option for completion of the project.

Besides it requires, to consolidate & calculate the amount for different periods with the conditions mentioned in the sample workbook.

Hence, I hope someone will help me to find a solution.

Sincerely yours,
acsishere.

Dear Friends,

I hope some one will help me to find the solution.

Thanks in advance,

Yours, acsishere.

Dear Friends,

Any help?

Please....

Thanks in advance,

Dear Friends,

Any help? Please....

yours sincerely,
acsishere.

Dear Friends,

Please help me...

Hope someone will come forward.

Thanks in advance, acsishere.

Dear Friends,

Any help?

Thanks in advance.

Can you read my post again? Maybe your user can be taught how to operate a pivot table. It seems that the requirements are not clear enough to provide an alternative approach. So, unless you provide more information, you may find yourself bumping to infinity, because people don't have a clue what you need to do.

regards

Dear Sir,

Thanks for your time. I will come back with the proper example.

Thanks...

Please don't assume that everbody who posts here is male.

@Coder: Perfect. Maybe you can combine your efforts with MRICE, because the OP double posted this thread and has several people working on it in parallel.

c/f: http://www.excelforum.com/excel-prog...mn-values.html

@acsishere
I'm not well please to find you constantly bumping this thread while double posting the same question. I've asked you in your other thread what the reason for the double post was. You have not reacted. So, I don't feel particularly interested in reacting to your bumps.

regards

Dear Teylyn & other Friends,

First of all, I would like to explain the differences between these two posts, as it creates a lot of confusion to few as they think that these two are double posts:

1. http://www.excelforum.com/excel-prog...e-columns.html
2. http://www.excelforum.com/excel-prog...mn-values.html

The only common thing is that both are based on expenditure. The differences are:

1. The First link is based on:
Report based on Three columns, Different dates & periods, expenses reports are analysed in depth (For each Item & Col F), Expenses / Items may increase in Row-wise.

2. The second link is based on:
Report based on two columns, Expenses are in Column-wise, Expenses/Items may increase in both ways.

I hope this explanation will help them to understand my these two as different posts.

Dear Teylyn, I do agree with you that I should not assume that those whoever posting are not male. Though it is a common problem, I will rectify in future.

Thanks,
acsishere.

Dear Friends,

As I stated earlier, I have come up with a detailed new workbook attached in which I have explained to some more extent what I need exactly.

Hope this time it will be easy to understand what I need.

Thanks in advance.

acsishere.