Hi Howard,

Am Thu, 20 Mar 2014 11:38:22 -0700 (PDT) schrieb L. Howard:

Each time the code is run for Titles both destinations should be identical lists.

Titles column A on Titles sheet and column B on Publish sheet.

Descriptions column A on Descriptions sheet and column E on Publish sheet.

I hope I understood you correctly.
Please have a look:
https://onedrive.live.com/?cid=9378A...121822A3%21326
for workbook "Title Builder Randomizer rev 2.3.xlsm"


Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Prodessional

On Thursday, March 20, 2014 12:03:50 PM UTC-7, Claus Busch wrote:
Hi Howard,



Am Thu, 20 Mar 2014 11:38:22 -0700 (PDT) schrieb L. Howard:



Each time the code is run for Titles both destinations should be identical lists.



Titles column A on Titles sheet and column B on Publish sheet.



Descriptions column A on Descriptions sheet and column E on Publish sheet.



I hope I understood you correctly.

Please have a look:

https://onedrive.live.com/?cid=9378A...121822A3%21326

for workbook "Title Builder Randomizer rev 2.3.xlsm"





Regards

Claus B.

--

That is looking pretty good. I still need the Title portion to produce a single phrase instead of six phrases.

This link demonstrates what the Title output should look like.
Note column A entries are just one phrase.


https://www.dropbox.com/s/rftplrkmdw...20Example.xlsm

Howard

Hi Howard,

Am Thu, 20 Mar 2014 13:42:20 -0700 (PDT) schrieb L. Howard:

That is looking pretty good. I still need the Title portion to produce a single phrase instead of six phrases.

This link demonstrates what the Title output should look like.
Note column A entries are just one phrase.

https://www.dropbox.com/s/rftplrkmdw...20Example.xlsm

I improved the code. Please have another look.


Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Prodessional

On Thursday, March 20, 2014 2:11:01 PM UTC-7, Claus Busch wrote:
Hi Howard,



Am Thu, 20 Mar 2014 13:42:20 -0700 (PDT) schrieb L. Howard:



That is looking pretty good. I still need the Title portion to produce a single phrase instead of six phrases.



This link demonstrates what the Title output should look like.

Note column A entries are just one phrase.



https://www.dropbox.com/s/rftplrkmdw...20Example.xlsm



I improved the code. Please have another look.





Regards

Claus B.

--

Yes, that looks great!

I hope those codes will serve me well in finishing the workbook with the remaining sheets.

At this point I don't know what all info on the remaining sheet is the stuff to bring to Publish.

Terrific work in my eyes.

Thanks much.

Howard

Hi Claus,

Some advice please.

The "Title Builder" and "Description Builder" worksheets are my focus here.
I have found that if I run either Description or Title macros, they take about 190 seconds plus another 90 seconds to complete.

12,000 Titles and 2000 Descriptions to column A on their respective sheets.
The GOOD news is that duplicates are very very rare. Have yet to find one on the Description sheet and Titles I usually get from 0 to 3. These are very acceptable results.

The BAD news is the length of time to run the codes.

I have tried Calculation set to manual on both codes and the time is very acceptable, about 1 second.
The major BAD news with this is that the duplicates occur at a huge and unacceptable level. So I guess there are some necessary calculations not happening and the duplications occur.

I'm open to suggestions, perhaps do those Titles and Descriptions calculations in a separate workbook/s and transfer the data to the proper columns on the main workbook..??

This is a Demo main workbook if you need to see anything on it.

https://www.dropbox.com/s/vz387bfi02...p%20B ox.xlsm

Thanks.
Howard

This should say...

I have found that if I run either Description or Title macros, they take about 190 seconds plus another 90 seconds to complete the transfer to column A.

Howard

Hi Howard,

Am Sun, 23 Mar 2014 19:06:47 -0700 (PDT) schrieb L. Howard:

I have found that if I run either Description or Title macros, they take about 190 seconds plus another 90 seconds to complete the transfer to column A.

if I would know what the workbook should do I could help better.
Do you need the columns AE:AO?
I thought in column A should only be 1 sentence?
Have a look:
https://onedrive.live.com/?cid=9378A...121822A3%21326
for workbook "Demo Work Book rev2.9"
I changed the formulas in AQ and the code for
"Six_By_Six_Title_Randomizer" and "CopyToA2_2_Titles"

If you can work with this suggestion you can similiar change the rest of
the code.


Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Prodessional