Update master spreadsheet from various single spreasheets
 

Hi to all,

I have to develop a sales pipeline in a master spreadsheet which gets its
input values from various single spreadsheets (owned each by a sales rep).

Here some details:
The columns are identical in all spreadsheets, like Geo, Revenue, etc.
Important is that the master spreadsheet has the functionality to update from
all input spreadsheets by checking if the sales opportunity is already
available in the master sheet or not. If the sales oppty is already available
in the master sheet, it is necessary to update the available values. If the
sales oppty is not yet in the master sheet, it needs to be added to the list.

FYI:
I've checked many posts in the community but couldn't find a consistent
solution.
I've profound knowledge of Excel but unfortunately no macro programming
experience.

Question to you:
Is there already a solution (e.g. macro) available for this which just needs
to be modified minorly?
If there is no solution available could you please help me.

Update master spreadsheet from various single spreasheets
 

Have a look @ this I think it will do what you want.

http://www.rondebruin.nl/summary2.htm

"Hannes" wrote:

Hi to all,

I have to develop a sales pipeline in a master spreadsheet which gets its
input values from various single spreadsheets (owned each by a sales rep).

Here some details:
The columns are identical in all spreadsheets, like Geo, Revenue, etc.
Important is that the master spreadsheet has the functionality to update from
all input spreadsheets by checking if the sales opportunity is already
available in the master sheet or not. If the sales oppty is already available
in the master sheet, it is necessary to update the available values. If the
sales oppty is not yet in the master sheet, it needs to be added to the list.

FYI:
I've checked many posts in the community but couldn't find a consistent
solution.
I've profound knowledge of Excel but unfortunately no macro programming
experience.

Question to you:
Is there already a solution (e.g. macro) available for this which just needs
to be modified minorly?
If there is no solution available could you please help me.