Work Project - Need Ideas

Occasional Contributor

Hi There,

 

I've been tasked with a project that I want to automate as much as possible; however, this seems like a project where I don't know what I don't know and would like some experienced Excel vets to help out:

 

I research stocks and do a write-up after reviewing them. The write up is saved in a word document.

We want to review our write-ups on an ongoing basis, so I want to write a program that will cycle through the latest write-ups for all the stocks we watch.  The idea would be to have the write-ups for that week automatically put into one file that I can send out for people to read on the weekend.

 

My idea would be to put each write-up into a cell on Tab A (this is the initial manual part), where I will adjust the rows to be very tall.  Then, I'd pull the writings for 10 randomly selected stocks to a tab A using a formula.  I'll make each row the height appropriate for one page, then make the print area the size of the 10 enlarged rows.

 

Any better ideas?  Is there a faster and better way to automate a task like this using excel?

0 Replies