Each month I copy a consumer report in the form of a table into a worksheet that corresponds with the month of the year. For purposes of reporting, I'd like to make a master table that has 2 columns:
Column A - Month (worksheet Name)
Column B - a concatenated list of all values from column complaint_type accross all 12 worksheets.
Is this possible?
thanks!
Bruce
Hi Bruce
In a word - Yes
The solution will depend on exactly what you have in the consumer reports and how you want it displayed in the Master. If you upload a sample of both, I a, sure that someone will be able to advise
Regards
Alastair
Hi Alastair,
Thanks for responding, This is my spreadsheet. For clarification, I want the Cumulative tab to List the month and complaint type only, from the other 12 tabs.
Thanks again!
BruceCustomer Complaints (Sample Data).xlsx
Try this macro on a copy of your data.
Please Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
wow, that's brilliant. Thank you!
2 quick questions:
1. Would it be possible to include in the code instructions to format the new list as a table?
2. Would it be possible to filter out blank records? By default the empty tables all have a single blank record on them so that when I copy the data from the consumer report it will be inserted into the table. If I could filter these out it would make this code perfect for what I need it to do
Thanks again!
@brharrii
1) why make a table of it, you gonna make a pivot table of it?
2) and do you need the months with no value's in it also (e.g. november / december) or these can be deleted also?
@brharrii
1) why make a table of it, you gonna make a pivot table of it?
Not a pivot table no, I thought it might be handy to be able to sort by complaint type or month to get an idea for trends. This is not vital though, and may actually be not necessary the more I think about it.
The months with no value should be deleted as well. So the final list should only have records that have values under "complaint type". No nulls / blanks.2) and do you need the months with no value's in it also (e.g. november / december) or these can be deleted also?
Thanks again
Last edited by brharrii; 07-17-2013 at 05:46 PM.
Without the table, but with deleted rows.
Try the code on a sample of your data.
Please Login or Register to view this content.
Brilliant, Thank you Very much
Thanks for the reply.
Glad I could help.
One more detail if you don't mind.
I just implemented this code into my live workbook. It is working great, with the exception of one thing. I have a few additional worksheets in the Live workbook besides the monthly ones. Information from these tabs are importing into my list. Is it possible to only reference the tabs January - December?
Thanks again for all your help
@brharrii
Make (and post) an excel example so I can take a look at how those sheets look like.
They have a specific name?
How many are there?
Hi, sorry for the delay in getting back to you. Thanks again for all your help
This is the notebook. The tab names are consistant. They won't ever change. If you have any questions let me know,
Thank you!
In that case this code should work for you.
Please reply.
Please Login or Register to view this content.
That seems to have done the trick, Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks