How to combine word processor and speadsheet in Office

August 23, 2012 at 17:42:08
Specs: Windows 7, Core i3 2,53 GHz 4,0 GB
Continuing my problem about Multiple sheets in word.
I hope Office Team can build a special sheet in Excel as word processor, similar with Word. So, we can make memo, report, description, analysis result, etc. with linked data used from data sheet, and can saved in one file.

See More: How to combine word processor and speadsheet in Office

Report •

#1
August 24, 2012 at 03:46:00
What you are asking for might be possible, but whoever would design this for you woud need very specific requirements related to formatting, layout, data input, etc.

In my opinion that is not something that can be done via a free, volunteer based forum. To me, this sounds like something you would to hire out to someone who can sit down with you, gather your requirements, build prototypes, etc.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
August 27, 2012 at 01:04:45
DerbyDad03, thanks for your comments.
I work on agriculture company (palm oil plantation & mill), I often work with report that make from data analysis, so I has to use Word and Excel for the same job, e.g. :
1. Annual budget & action plan : this report consist of executive summary, analysis description, this year condition, next year action plan, SWOT analysis description, that build with Word ; otherwise, I use Excel to make this year and next year data (accounting, financial, production, salary, etc). The Report in Word has to synchronizing with large data in Excel.
2. Employee Satisfaction Survey and Customer Satisfaction Survey : Word for questionnaire, summary, suggestion and analysis description, Excel for large survey data analysis with statistical function.
3. Annual Report, 3-Monthly Report, Monthly Report : same above

I have to use Excel to process data and I have to use Word to make a report, with embeded Excel data in Word or use paste-link. It is not simple for me. Especially if I have to copy these files to another computer, the formulas was still in older folder, so I has to change link folder source.

Was imagined in my mind if one of sheets in Excel can format as word processor, so report and data was saved in one file, over tab in one file, the data link formulas not change, copy one file.
Do others have this dream? Or enough with embeded data?


Report •

#3
August 27, 2012 at 04:09:58
As I tried to get across in my first response, I do not think that your goal can be accomplished via help from a online, volunteer forum.

I think that your project is too complicated and that you should considered getting bids from a software design firm or perhaps a local college where you sit down with the programmers and discuss your requirements in detail.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question