Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

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: 395 ✭✭

Join Date: April 2002

Posts: 366

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