compiling lists

[Guest]

I have a team of sales reps that list their sales opportunities (one per row) in lists of varying lengths, one per sales rep, each in their own file. Then they email them to me and I cut/paste into a single list that I manipulate with autofilters or pivot tables to assess our current pipeline. They are not sophisticated excel users, I'm an intermediate at best.

What is the best way to automate this process without macros? I want to minimize or eliminate the time required to assemble the reports that I am after. Is it possible? No one's list is ever longer than 40-50 rows.

 

[Gord Dibben]

Bill

"Automate without macros" is very hard to do.

Macros are what creates the automation.

Other than some formulas which do nothing more than return data from existing
cells, you are stuck with manually manipulating the data unless you use
macros.

Minimizing time can be done by macros.......eliminating time to assemble
reports would be impossible even with macros. You still have to pull the data
in to your report workbook.

What is the objection to macros? Security or the learning curve.

Gord Dibben Excel MVP

 

[Gord Dibben]

Bill

I will amend this.....

You could do it without macros if you were to set up "links" from your reps'
files to a Master workbook.

With the data coming in being inconsistent in length and quantity, it could be
difficult to use links, but probably do-able.

Gord