• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract data of a particular customer - productwise total - Excel VBA

S

saamrat

Member
Hi,

Need to extract productwise sum of a customer from the Data sheet and paste in a new Report Sheet using VBA. Regardless the purchase date, total quantity and sales need to be shown in the Report. Please find the attached Sample.

Kindly help
 
saamrat
There are people in the organization who do not understand pivot table. For them, I need to make it simple.
hmm ...
then ... You could do something like this ...

Select Customer from 'Data'-sheet ... okay?
 

Attachments

  • Sample Data - Copy.xlsm
    22.9 KB · Views: 10
vletm said:
saamrat
There are people in the organization who do not understand pivot table. For them, I need to make it simple.
hmm ...
then ... You could do something like this ...

Select Customer from 'Data'-sheet ... okay?
Click to expand...
That was awesome.
I am wondering, is that possible to load the customer in a dropdownlist where we can type few letters of customer and it narrows the search result and select the desired customer ?
If the customer has no record of item, is it possible not to show that item in the result ? Here we are showing all items even it is zero. I am looking for something like the Pivot Table that you have showed, but in VBA.

I really appreciate your help and support. Thank you so much
 
saamrat
You wanted something for people who are ...
This solution would be more clear to use ...
if dropdown list then
a) they have to find it
b) they have to click it
c) they have to be patient and select
now, there are many possibilities to select wanted 'Customer'...
if ... typing ... 'customer' ... then they have to know 'Customer' that they could see the result.
'Zero's ...
Good 'Customer' should have value with every 'item'!
... then 'Salesman's haven't work 100% ... hmm?
and soon 'Salesmen's would work more and there won't be any more 'zero's!
'Pivot'
I made 'Pivot-table' - You wrote ... no!
Is there windy?
 
vletm said:
saamrat
You wanted something for people who are ...
This solution would be more clear to use ...
if dropdown list then
a) they have to find it
b) they have to click it
c) they have to be patient and select
now, there are many possibilities to select wanted 'Customer'...
if ... typing ... 'customer' ... then they have to know 'Customer' that they could see the result.
'Zero's ...
Good 'Customer' should have value with every 'item'!
... then 'Salesman's haven't work 100% ... hmm?
and soon 'Salesmen's would work more and there won't be any more 'zero's!
'Pivot'
I made 'Pivot-table' - You wrote ... no!
Is there windy?
Click to expand...
Sorry for any inconvenience caused. Your help was so admirable
 
You must log in or register to reply here.
Back
Top