create table based on arguments

[beastom]

Hello all,
this forum already helped me a lot putting together all kind of functions. however, unfortunately i cannot find an appropriate solution for the following :

I've got a master sheet containing (sales)records.
I've got 10 sheets (1 per sales rep) that should populate all sales records for the specific sales rep.

i try to get this working with a index/match formula using the sales rep name as argument but i can't manage to get back more than one record.

Target is, that i can load an raw data extract in the master sheet and the 10 files (1 per sales rep) get populated automatically.

thanks in advance for your help.

 

[MrKowz]

Welcome to the forums!

This would be better handled through a macro. Would this be a report that you will clear all data from prior to putting new raw data into it?

 

[Andrew Poulsom]

Welcome to MrExcel.

Here is some VBA code that you may be able to adapt:

http://www.mrexcel.com/forum/showthread.php?t=397250

 

[beastom]

Hi there - thanks for the feeback

i would rather to this via formulas but if there's no way...
yes, masterdata will get cleared and complete set of new raw data will be pasted everytime.

thanks

Welcome to the forums!

This would be better handled through a macro. Would this be a report that you will clear all data from prior to putting new raw data into it?

 

[beastom]

Hi there -
thanks for the feedback. VBA coding, unfortunately, is not an option.
thanks

Welcome to MrExcel.

Here is some VBA code that you may be able to adapt:

http://www.mrexcel.com/forum/showthread.php?t=397250