Don't know how to really describe it. I have a list of names, some of which are multiple listings. I want to create a table with 2 columns, one with the names of people listed more then once, and the second with the amount of times that they are listed. Can anyone help?
Can you provide a mock workbook with mock data (no personal information) with a before and an after (result) of what it is you want done with the data. If you do that it will remove a lot of guess work from the valuable members of this forum.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
Here is an attachment of what I wanted. The second table is where I need the code to dynamically get the names, and the times listed.
Is this what you are after?
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
Thanks for the effort, but it doesn't seem to be dynamic. If I add a name to the list, the count doesn't update. Is it possible to do that?Originally Posted by JapanDave
No it is not dynamic, you didn't specify that you wanted it dynamic. So I guess you want an example that is dynamic? If so, will the Columns or rows where the data starts change in any way? Is there any new information I should know about?
The starting data shouldn't change. Just where it ends (end of the table). I don't know if you noticed, but the first example I gave actually already has a list of names with it if you scroll to the left a bit. The second table was just a prototype for where the dynamically generated data would go based on how many times a name is listed.
I did not notice that , sorry.
Ok I have some code that will do what you are after. It creates a new sheet with any updated data. Just click the "Add Data" button and the new data will be added. BTW, if the data is difficult to look at, let me know what style table you want and I will change it.
Code:
Please Login or Register to view this content.
Last edited by JapanDave; 12-05-2011 at 10:02 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks