LinkBack URL
About LinkBacks
I need a macro that will take the data in columns A-C and query out each customer, what part # they bought, and how many of that part #. The results would be what is displayed in columns E-G. Thanks.
I need a macro that will take the data in columns A-C and query out each customer, what part # they bought, and how many of that part #. The results would be what is displayed in columns E-G. Thanks.
How about a word of thanks to those who helped in your previous thread first? All the help you get here is for free - please don't take it for granted.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
You can use a straight pivot table to get those results. See attached
Thank you!
One more thing. I thought I created the exact same pivot table (file attached) but how do I get rid of A Total, B Total, & C Total lines? Yours does not have them. Thanks.
See picture below. Click on it if it's too small or it's just text.Originally Posted by backyardfun
Attachment 726546
It states that I can't open the attachment.
It should just display a picture when you left-click on it and it works here, logged in or not.
Anyway, trying again:2021-04-01_155031.png
Awesome. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks