Basically what I would like the program to do is take the name in A1 and put the rest of that row in a separate sheet called that name. Will also need to check if sheet exits since new people are being added. Data will continue to come in that format and need to be placed into the sheets, the program also needs to put the data in order.
thanks for help in advance
You want to add a sheet named as the value in A1, containing that row?
What about the other names?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I need it to look like this. The other names need their own sheet. After I will be placing other data and it needs to add to the same name or create a new sheet with that name. (i.e with verett the macro would check to see if it exits and then make a new sheet.)
Do you want a sheet for each name
Please Login or Register to view this content.
yes i do, and thank you for your help.
Please mark the thread solved & rate the answer.
that is alot closer then I got with hours of thinking. How could i get the macro to do that with more data and place it in the corresponding sheets and new data going to the next row?
Please ask the full question at first instead of in stages. We could have resolved this immediately instead of over 3 or 4 attempts.
Does your data have header rows?
Here's an earlier post with a similar request
http://www.excelforum.com/excel-prog...n-keyword.html
Sorry about that. I get that data each week and it needs to take the data and put it into the worksheets. so if you ran the macro again it would take the data and copy it to their own sheets.
Thanks again for your help.
You haven't adjusted the code correctly to ork with the right sheet or columns
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks