Hi everyone,
Yall are so much help its amazing !
Here is what i am trying to do.
I want to create new sheets according to the content in column A and also have my header copy to each newly created sheet.
To make it easier to explain I have inserted two excel spreasheet which show exactly what i am trying to do.
This would save me hours of work to sort through my finances.
Thanks Yall
Last edited by Tmc2159; 06-10-2013 at 10:22 AM.
'SHEET1 TO MANY SHEETS
Here's a macro for parsing rows of data from one sheet to many sheets named for the same values in a specific column.
It not only can parse the rows, it can create the sheets if they are missing. There is a sample sheet there where you can test this out.
Last edited by JBeaucaire; 12-27-2019 at 05:08 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi TMC,
Why do you want separate sheets? If you create an Autofilter of your data you can simply filter it to only show the bird you want to see.
See: http://www.contextures.com/xlautofilter01.html
One test is worth a thousand opinions.
It does all except inserting a row.
Thank you so much for yallz help.
Unfortunately JBeaucaire that code seems to copy everything into every sheet where as I only need the specific bird. So all chickens go to the chicken sheet but no ducks go to it.
MarvinP, thanks for looking at this. I need it to go into seperate sheets because I am myself writing macros that will do different things to each sheet
Thanks for all of your help
[SOLVED] Thank you so much AB33
Is there a way for me to edit the title so that everyone knows how amazing you guys were and that the problem is solved !
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks.
I'm going to guess when you tried my macro you didn't edit it so the vCol was set to the column you wanted to parse by unique strings.
Actually you are correct, I am still having an issue with your macro.
Thank you so much for your help though
Using my initial excel file and your macro, i do create the sheets properly but all my data appears in every single sheet.
I am sure how to solve this problem.
What value should I change
The problem was with how I was defining my title, it was stopping because the row was blanked
Got it working, then?
Thank you so much I did
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks