Thread: organize files
View Single Post
 
Old 04-30-2012, 11:24 AM
userman userman is offline Windows XP Office 2003
Advanced Beginner
 
Join Date: Sep 2010
Posts: 52
userman is on a distinguished road
Default organize files

hello!

I need to organize documents that relate to specific products, in EXCEL.
Each product, has some specific documents for it, eg specifications, usage directions, cautions, etc.

I have created a top row that is constand, and below I enter the products.
Then, I save in each cell, the specific document, for the specific product.

The problems are these:
1) I want each cell, where a document will be saved, to be red if empty and green if filled with a file
2) Under a specific document type, ie a specific column (let's say "specifications"), I need to store a various number of files, so that the cell, for each product, must be splitted in various subcells.
Now the tricky part is this: I want to load a simple text file with some text lines in that cell, then EXCEL will automatically read it and split the cell in a number of subcells of the number of the lines of the text file and also the names of the cells will be the text lines. Is it possible??

any solution?

thanks!
Reply With Quote