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.
I spent a lot of time banging my head against the wall making it so that the
master table could be linked to the document, so no actual insertion was
needed. The idea was that I'd have the actual master table on the first
sheet in Excel, and additional sheets for each derived table. Alas, both
Excel and Frame are far too weak to support such a simple concept. Excel
doesn't auto-sort, as far as I can tell, in the derivative tables, and Frame
is very weak at importing data without wreaking havoc on the formatting.
Autofilter is a great tool, but I like having derived tables on separate
sheets. It's a form of self-documentation about what each table is supposed
to look like. Also, if (god forbid) you have to override values from the
master, that's the place to do it.
I suppose I could write awk scripts (I've never gotten around to learning
perl) and have a Makefile (in fact, this has some real advantages), but only
when I'm the sole person who ever touches the document, which is generally
not what my clients want.
-- Robert
P.S. 5500 rows! I think I've passed 500 a couple of times, but not often.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Purchase RoboHelp X3 in April and receive a $100 mail-in
rebate, plus FREE RoboScreenCapture and WebHelp Merge Module.
Order here: http://www.ehelp.com/products/robohelp/
Help celebrate TECHWR-L's 10th Anniversary starting this month!
Check out the contests at http://www.raycomm.com/techwhirl/special/contests/
Happy birthday to you, happy birthday to you, happy birthday TECHWR-L....
---
You are currently subscribed to techwr-l as:
archive -at- raycomm -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot- Visit http://www.raycomm.com/techwhirl/ for more resources and info.
