Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue with blanks and spaces
On Thursday, March 20, 2014 11:18:42 AM UTC-7, Claus Busch wrote:
Hi Howard, Am Thu, 20 Mar 2014 11:00:00 -0700 (PDT) schrieb L. Howard: The sheets of concern at this time are Publish Data, Title Builder and Description Builder. Title code needs to fill column A of Title sheet and column B of Publish. Description code needs to fill column A of Description sheet and column E of publish. Mostly it is doing that but the list seem to be correctly done but not identical. That is: the list on Titles column A and the list on Publish column B are different from one another after each running of the code. The same for Description. Also need to be able to run Titles and Description code from Publish sheet. There is a button for each. This seems to somewhat of a problem. I'll be dealing with the other sheets to do similar work, but hopefully I can use the correctly done code for Titles and Descriptions to guide me. at the moment I am a little bit confused. Should the list in column A or Title and column B of Publish be the same? Also for Description and Publish? Or should be randomized between running the code? Regards Claus B. 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. Howard |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue with blanks and spaces
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue with blanks and spaces
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue with blanks and spaces
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue with blanks and spaces
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue with blanks and spaces
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue with blanks and spaces
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charting blanks as spaces | Charts and Charting in Excel | |||
Issue removing leading and lagging spaces | Excel Programming | |||
How to count blanks and spaces that look like blanks | Excel Programming | |||
how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) |