Macro Assistance (Splitting into new workbook by value)

D

Dedrie

Good friday afternoon!

I am using a Macro that I received a few years back from a member of this
site (Ron De Bruin, I believe)...

It splits data from a workbook into separate workbooks by a specific field.
Ie if I have employee census information in a file and I want to split it by
manager into a new workbook so I can send just that manager their employees
information it works like a charm (thanks ron!)

I'm not good with using/modifying macros...and now have a worksheet that
contains data in rows 1-8 that needs to be copied to each new workbook along
with the split.

Does anyone have any suggestions?

Thanks in advance!
 
B

Bryan Ward

Dedrie,
I could actually really use a code to split out data from a performanc
report I work on. Basically for the same principles it sounds like yo
are using Ron's for. Is there any way you wouldn't mind posting it u
here for me to tinker with? :)1

Regards,
Bryan Ward
 
R

Ron de Bruin

See
http://www.rondebruin.nl/copy5.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


Bryan Ward said:
Dedrie,
I could actually really use a code to split out data from a performance
report I work on. Basically for the same principles it sounds like you
are using Ron's for. Is there any way you wouldn't mind posting it up
here for me to tinker with? :)1

Regards,
Bryan Ward

Dedrie;461033 said:
Good friday afternoon!

I am using a Macro that I received a few years back from a member of
this
site (Ron De Bruin, I believe)...

It splits data from a workbook into separate workbooks by a specific
field.
Ie if I have employee census information in a file and I want to split
it by
manager into a new workbook so I can send just that manager their
employees
information it works like a charm (thanks ron!)

I'm not good with using/modifying macros...and now have a worksheet
that
contains data in rows 1-8 that needs to be copied to each new workbook
along
with the split.

Does anyone have any suggestions?

Thanks in advance!


--
Bryan Ward
------------------------------------------------------------------------
Bryan Ward's Profile: http://www.thecodecage.com/forumz/member.php?userid=1264
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=127555

Microsoft Office Help
 
B

Bryan Ward

Thanks Ron, that really helps out. Is there a way to augment the code
to handle more than 8192 rows of data as I have tens of thousands? And
I am unfamiliar with the code surrounding this block in the script.
 
R

Ron de Bruin

Hi Bryan

Are there more then 8192 different names in this workbook or do you have
more then 8192 areas for one name ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


Bryan Ward said:
Thanks Ron, that really helps out. Is there a way to augment the code
to handle more than 8192 rows of data as I have tens of thousands? And
I am unfamiliar with the code surrounding this block in the script.

See
'Copy records with the same value in a column to a new sheet or
workbook' (http://www.rondebruin.nl/copy5.htm)

--

Regards Ron de Bruin
'Ron's Excel Tips' (http://www.rondebruin.nl/tips.htm)



Ward' (http://www.thecodecage.com/forumz/member.php?userid=1264)
value) - The Code Cage Forums'
(http://www.thecodecage.com/forumz/showthread.php?t=127555)


--
Bryan Ward
------------------------------------------------------------------------
Bryan Ward's Profile: http://www.thecodecage.com/forumz/member.php?userid=1264
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=127555

Microsoft Office Help
 
B

Bryan Ward

Hi, Ron
Thanks for the prompt reply. Sorry, I should have been more clear wit
my question. Bear with me. :) There are 7 unique values in column A
However, each of these values has approximately 10,000 rows of data
need to move into new files, in fact there are specific files alread
made with specific worksheets, but I think I can figure that out. Th
uniques values are essentially regions (i.e. South, West, Central
etc...). Every week they get bigger and every week I need to publis
new reports. The macro you have written is quite amazing, it acheive
pretty much the desired affect for what I am trying to do. However, i
order for it to be a true solution to my ongoing problem it would nee
to handle around 18,000-20,000 rows for each region by the end of ou
fiscal year, and if it can be completed this macro would save me about
hrs of manual copy/paste and validation a week. YAY! Any help or an
place you can point me to, would be of help. I appreciate your time.
Let me know what you think.

Regards,
Bryan Ward
 
R

Ron de Bruin

Hi Bryan

Do you see the MSG box when you run the code

Note that it is 8192 separate areas and not cells

If you sort the sheet for example before you run the code it is possible that
you not hit the limit anymore



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


Bryan Ward said:
Hi, Ron
Thanks for the prompt reply. Sorry, I should have been more clear with
my question. Bear with me. :) There are 7 unique values in column A.
However, each of these values has approximately 10,000 rows of data I
need to move into new files, in fact there are specific files already
made with specific worksheets, but I think I can figure that out. The
uniques values are essentially regions (i.e. South, West, Central,
etc...). Every week they get bigger and every week I need to publish
new reports. The macro you have written is quite amazing, it acheives
pretty much the desired affect for what I am trying to do. However, in
order for it to be a true solution to my ongoing problem it would need
to handle around 18,000-20,000 rows for each region by the end of our
fiscal year, and if it can be completed this macro would save me about 3
hrs of manual copy/paste and validation a week. YAY! Any help or any
place you can point me to, would be of help. I appreciate your time.
Let me know what you think.

Regards,
Bryan Ward
Hi Bryan

Are there more then 8192 different names in this workbook or do you
have
more then 8192 areas for one name ?

--

Regards Ron de Bruin
'Ron's Excel Tips' (http://www.rondebruin.nl/tips.htm)



sheet or workbook' (http://www.rondebruin.nl/copy5.htm))
Cage Forums'
(http://www.thecodecage.com/forumz/showthread.php?t=127555))
Ward' (http://www.thecodecage.com/forumz/member.php?userid=1264)
value) - The Code Cage Forums'
(http://www.thecodecage.com/forumz/showthread.php?t=127555)


--
Bryan Ward
------------------------------------------------------------------------
Bryan Ward's Profile: http://www.thecodecage.com/forumz/member.php?userid=1264
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=127555

Microsoft Office Help
 
B

Bryan Ward

Ron,
Awesome, figured it out. They were all getting there. Sorry, to waste
your time. Just punch drunk from data overload must have missed it.
Thanks for being so prompt. I really appreciate you hanging in there
with me.

Warm regards,
Bryan Ward
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top