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

Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.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.…

30-09-2014 08:34AM

#1

Boomtownrat81

Registered Users, Registered Users 2 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

#2 02-10-2014 07:46PM

BloodBath

Registered Users, Registered Users 2 Posts: 10,283 ✭✭✭✭

Join Date: September 2003

Posts: 10168

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
#3 02-10-2014 08:19PM

Edser

Registered Users, Registered Users 2 Posts: 394 ✭✭

Join Date: April 2002

Posts: 365

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
#4 09-10-2014 02:02PM

Overheal

Registered Users, Registered Users 2 Posts: 86,683 ✭✭✭✭

Join Date: September 2006

Posts: 79793

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