Macro Assistance (Splitting into new workbook by value)

[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!

 

[Ron de Bruin]

Hi Dedrie

Send me your test workbook private
and I will adapt the example on this page for you
http://www.rondebruin.nl/copy5.htm

 

[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

 

[Ron de Bruin]

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

--

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

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

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

 

[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.

 

[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

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

 

[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

 

[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

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

 

[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