Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 142
Default Too many word documents, can Excel HELP!!!

I have 14 word documents, many of which have duplicating line items. Some
documents have all line items, some different line items. It is extreamly
hard to keep track of changes made to each document. It is also extreamly
hard to solve input errors. Or at least to keep tract of them. I noticed
some Access databases which can be used as a call center tracting approach.
Was wondering if perhaps Excel could somehow be designed to incorporate these
14 documents and then able to apply filters or do quieries against the data.

Any and all help is apprciated.
Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 213
Default Too many word documents, can Excel HELP!!!

I have 14 word documents, many of which have duplicating line items.
Some documents have all line items, some different line items. It is
extreamly hard to keep track of changes made to each document. It is
also extreamly hard to solve input errors. Or at least to keep tract
of them. I noticed some Access databases which can be used as a call
center tracting approach. Was wondering if perhaps Excel could
somehow be designed to incorporate these 14 documents and then able to
apply filters or do quieries against the data.


One way is to put each line item in column A as a separate cell, with cell
alignment set to "wrap text." Bear in mind that text in a cell is limited
to 32K characters and only 1024 of them display on the screen. Set up the
"print area" for column A only.

The remaining columns can hold formulas that filter the line items in
different ways. Then,
Data Filter AutoFilter
can be applied to the "filter" columns.

If the documents don't use a lot of MS-Word features, this might be enough.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
My Documents include Excel & Word Sadie New Users to Excel 3 October 21st 06 05:25 PM
Have Excel treat documents as Word does Frustrated Excel User Excel Discussion (Misc queries) 7 October 17th 06 09:40 AM
How to merge excel and word documents jacqueline Excel Discussion (Misc queries) 1 March 28th 06 01:52 AM
can I merge documents in excel like I can in Word kaykayIT Excel Discussion (Misc queries) 3 November 10th 05 01:57 AM
Ever use Excel for documents instead of Word? [email protected] Excel Discussion (Misc queries) 2 March 18th 05 10:55 AM


All times are GMT +1. The time now is 08:42 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"