RE: Need help from an Excel guru

["Veronica Kutt" <veronica -at- front-runner -dot- com>]

Hi John,

We have an Excel guru instructor who provides Excel with Macros and VBA
workshops at Front Runner Training, in Toronto.

Here is his reply with a sample. Please contact Dennis Plum directly if you
have any other questions. 

Veronica,
If I've understood the problem correctly then the attached workbook contains
sample data as shown below, with the VBA code contained.
To Run the Macro:
- Press [Alt]-[F8] 
- Click Run for the macro "Repeat_ColValue_UntilNext_ColValue"

Note: It will ask you to confirm that the first value is correctly selected
before running the macro.

Also, Note that the first sheet contains the sample data shown below in 2
columns, while the 2nd sheet needs to be converted to 2 columns

===============
To access the code stored in the workbook to code it and paste it elsewhere,
or to EXport it for IMpoprt to another file:
- Press [Alt]-[F8] 
- Click Edit for the macro "Repeat_ColValue_UntilNext_ColValue"

Dennis Plum
http://excelmacrosvba.com


If anyone is interested Dennis provides his three one day workshops through
Front Runner Training. 

Level 1 - Data Input
http://tinyurl.com/2agx6xp

Level 2 - Data Analysis
http://tinyurl.com/27nnhmt

Level 3 - Formulas and Functions
http://tinyurl.com/298t7bp


I hope that helps John.

Thanks,


Sincerely,

Veronica Kutt
President
Front Runner Training, a div. of Front Runner Publishing Solutions Inc.
416-515-0155
1-877-999-0155
veronica -at- front-runner -dot- com

Front Runner participating in our 6th Annual CP24 CHUM Christmas Wish 
Thank you for helping to, 'Give A Kid A Christmas.'
-----Original Message-----
From: techwr-l-bounces+veronica=front-runner -dot- com -at- lists -dot- techwr-l -dot- com
[mailto:techwr-l-bounces+veronica=front-runner -dot- com -at- lists -dot- techwr-l -dot- com] On
Behalf Of John Posada
Sent: December-16-10 8:30 AM
To: Peter Neilson
Cc: techwr-l -at- lists -dot- techwr-l -dot- com
Subject: Re: Need help from an Excel guru

> In the course of the project I would worry that some of the cells in the
> table might contain "other" data such as comments, or notes describing
> exceptional aspects of the data in other cells. This is a very common
> misuse of tabular data. Here's what I mean:


Thanks, Peter, but you are WAY overthinking this :-)

The table is a dump of the links on each page of my 1700+ web page
external knowledgebase. The first column is the URL of the page and
the second column is the URLs of the links on that page.
Unfortunately, the tool I had to use for the extraction would list the
source page as a heading and not for each line.

I want to have the page URL adjacent to each link so I can run some
filtering and run some an Excel Pivot Table for some analysis I'm
doing.

But thanks

-- 
John Posada
http://jposada.zenfolio.com/
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Create and publish documentation through multiple channels with Doc-To-Help.

Choose your authoring formats and get any output you may need. Try 
Doc-To-Help, now with MS SharePoint integration, free for 30-days. 
http://www.doctohelp.com

---
You are currently subscribed to TECHWR-L as veronica -at- front-runner -dot- com -dot- 

To unsubscribe send a blank email to 
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit
http://lists.techwr-l.com/mailman/options/techwr-l/veronica%40front-runner.c
om


To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot-  Visit
http://www.techwr-l.com/ for more resources and info. 

Please move off-topic discussions to the Chat list, at:
http://lists.techwr-l.com/mailman/listinfo/techwr-l-chat
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Create and publish documentation through multiple channels with Doc-To-Help. 
Choose your authoring formats and get any output you may need. Try 
Doc-To-Help, now with MS SharePoint integration, free for 30-days. 
http://www.doctohelp.com

---
You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot- 

To unsubscribe send a blank email to 
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit http://lists.techwr-l.com/mailman/options/techwr-l/archive%40web.techwr-l.com


To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot-  Visit
http://www.techwr-l.com/ for more resources and info. 

Please move off-topic discussions to the Chat list, at:
http://lists.techwr-l.com/mailman/listinfo/techwr-l-chat