Is there a way to create a macro the will take what is in a cel and make a worksheet for it. And put the date base on what name is in the cell. Example
Column A
A 5 rows
B 5 Rows
C 5 rows
D 5 Rows
E 5 Rows
Worksheet names would be
worksheet A would have all A 5 rows in the worksheet
worksheet B would have all B 5 rows in the worksheet
and so on.
Thanks,
James Bosco
Sounds doable, but your example is actually still open to a lot of interpretation. Instead of explaining, show us. Mockup a sample workbook showing the data you're dealing with and your desired results, point out where the results came from if not obvious in your sample data.
Click GO ADVANCED and use the paperclip icon to post up your workbook.
_________________
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!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks