Compiling excel data into a word doc

[notdabod]

I'm wondering how i could compile excel data into a word doc efficiently.

We will have hundreds of excel docs that we'll need to quickly filter through and recompile into word docs.

Could someone please point me in the right direction?

Thanks

[Tinbendr]

Your question is too vague to offer any specific solution.

What does "filter through and recompile into word docs." mean?

[notdabod]

Hi Tinbendr,

Thanks for taking the time!

Sorry I was to vague, please let me try and clarify.

My idea is to have a folder full of excel docs or one excel doc with many excel docs imported into it. So we can filter through categories in excel.

Now a category would need to be a specific cell i figure like B50 etc.

So then we'd filter through all of the B50 cells in all the sheets into one new excel sheet, then export this new excel sheet to at word doc.

Does that help or make sense?

Thanks!

[Tinbendr]

So you would have separate 'elements' in each Excel workbook. You want to be able to have a Excel 'Index' file, describing these 'elements'. A filter of some sort would allow you to select the elements required for the output. Then these elements would be output to Word?

[notdabod]

Yes that's sounds right.

[Tinbendr]

Upload a sample workbook with the layout you'd like, Add at least three additional worksheets (I will separate them later) that will represent the data.

[notdabod]

The idea is to have a report form in a workbook that people will fill out, then send back. Then either import all these workbooks into one workbook or keep these workbook files in a folder so we can filter through these reports.

My sample workbook is very simple but I figure it's enough to get the point across.

cell a1 - 'marketing' is like a header.
cell a2 - 'marketing info' is where the info would be filled in by the person. I'm thinking we'd need to have 'marketing info' in the same cell on each sheet so we can query it but maybe I'm mistaken.

I have a bit of experience in writing simple plugins in python, but not much excel experience.

Thanks!

[newdoverman]

Is there any chance of using an online form instead of Excel workbooks for each person? The results from online forms can be in the form of CSV or TXT files that can be imported into Excel, a database or directly into Word. Word's text handling abilities far exceed those of Excel and formatting raw data into a finished product shouldn't be much of a problem.

[notdabod]

Hi Newdoverman,

I wish it could be online so we could use out sharepoint site but we can't that's why I'm trying to find an offline solution. That's why I'm trying to create a form system. I thought by sending people an excel form we can collect data for a data base.

Thanks

[newdoverman]

I did a little research and maybe you might want to consider creating the form in Word and use a Word add-in to collect the data from Word files, email attachments or a batch of documents.

Here is the URL with the information on this. http://www.gmayor.com/ExtractDataFro...ntent_controls