Macros

[damanirahul]

I have 6 columns each for Date, Script, Quantity, Rate, Amount, Client.
Everyday i fill the data in this main sheet1.
I want in sheet2 the full details of date wise transaction done by client A should come. Please can you help me how to do it.

Thanks in advance.

 

[nightcrawler23]

The best option will be pivot table. What excel version are you using.