Work Project - Need Ideas

%3CLINGO-SUB%20id%3D%22lingo-sub-1653975%22%20slang%3D%22en-US%22%3EWork%20Project%20-%20Need%20Ideas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1653975%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20There%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20tasked%20with%20a%20project%20that%20I%20want%20to%20automate%20as%20much%20as%20possible%3B%20however%2C%20this%20seems%20like%20a%20project%20where%20I%20don't%20know%20what%20I%20don't%20know%20and%20would%20like%20some%20experienced%20Excel%20vets%20to%20help%20out%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20research%20stocks%20and%20do%20a%20write-up%20after%20reviewing%20them.%20The%20write%20up%20is%20saved%20in%20a%20word%20document.%3C%2FP%3E%3CP%3EWe%20want%20to%20review%20our%20write-ups%20on%20an%20ongoing%20basis%2C%20so%20I%20want%20to%20write%20a%20program%20that%20will%20cycle%20through%20the%20latest%20write-ups%20for%20all%20the%20stocks%20we%20watch.%26nbsp%3B%20The%20idea%20would%20be%20to%20have%20the%20write-ups%20for%20that%20week%20automatically%20put%20into%20one%20file%20that%20I%20can%20send%20out%20for%20people%20to%20read%20on%20the%20weekend.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20idea%20would%20be%20to%20put%20each%20write-up%20into%20a%20cell%20on%20Tab%20A%20(this%20is%20the%20initial%20manual%20part)%2C%20where%20I%20will%20adjust%20the%20rows%20to%20be%20very%20tall.%26nbsp%3B%20Then%2C%20I'd%20pull%20the%20writings%20for%2010%20randomly%20selected%20stocks%20to%20a%20tab%20A%20using%20a%20formula.%26nbsp%3B%20I'll%20make%20each%20row%20the%20height%20appropriate%20for%20one%20page%2C%20then%20make%20the%20print%20area%20the%20size%20of%20the%2010%20enlarged%20rows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20better%20ideas%3F%26nbsp%3B%20Is%20there%20a%20faster%20and%20better%20way%20to%20automate%20a%20task%20like%20this%20using%20excel%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1653975%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
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