TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
Subject:RE: Need help from an Excel guru From:"Veronica Kutt" <veronica -at- front-runner -dot- com> To:"'John Posada'" <jposada99 -at- gmail -dot- com>, "'Peter Neilson'" <neilson -at- windstream -dot- net> Date:Thu, 16 Dec 2010 13:16:17 -0500
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.
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"
Front Runner Training, a div. of Front Runner Publishing Solutions Inc.
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.'
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
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-