If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Is this available?

Boomtownrat81 · 2014-09-30 07:34:21

Hi all, As part of the monthly accounting reports I prepare I need to compile a management summary which comprises over 20 excel tables. These tables are then "copied" to a Word Document which is very time consuming as I have to resize the excel tables each month. This involves dragging cells etc which is a headwrecker.…

Options

30-09-2014 8:34am

#1

Boomtownrat81

Registered Users Posts: 56 ✭✭

Join Date: September 2012

Posts: 37

Hi all,

As part of the monthly accounting reports I prepare I need to compile a management summary which comprises over 20 excel tables. These tables are then "copied" to a Word Document which is very time consuming as I have to resize the excel tables each month. This involves dragging cells etc which is a headwrecker.

What I am wondering is this - is there a package available which would enable you to have a predefined areas on a Word Doc or similar doc for each table - you could then simply copy the tables into each area and it would resize them to fit? I would also need to be able to enter text in areas of the document - obviously outside the table areas.

This would be a huge time saver for my company.

All suggestions appreciated..

0

Comments

Options
#2 02-10-2014 7:46pm
BloodBath

Registered Users Posts: 10,299 ✭✭✭✭

Join Date: September 2003

Posts: 10184

Wrong forum for this question I'd say.

Not sure where you should ask though.

Try the Biz/accounting forum maybe.

http://www.boards.ie/vbulletin/forumdisplay.php?f=872

0
Options
#3 02-10-2014 8:19pm
Edser

Registered Users Posts: 363 ✭✭

Join Date: April 2002

Posts: 336

A couple of quick suggestions:

- you could format the Excel sheets to look like documents (set cell fill colour = white)

- check out (google) linking Word tables to Excel

Ed

0
Options
#4 09-10-2014 2:02pm
Overheal

Registered Users Posts: 83,174 ✭✭✭✭

Join Date: September 2006

Posts: 76668

you can run scripts in environments like MATLAB that can read excel sheets and then either translate that to a new spreadsheet or output it as text, just for example.

0