Summary list from multiple tables, without gaps

[Excelnewbie11]

Hi


I’m hoping you guys can help me, I’ll try to explain what I’m trying to achieve and hopefully it will make sense.

The data is for sales figures, the worksheet it set up asfollows

Team 1:

Headers - Consultant Name(D3), Client(E3), Percentage(F3), Margin (G3), Weeks (H3), Value (I3)


The table then allows space for you to fill in 10 deals – (D4:I13)before moving on the next team

Team 2:
Headers - Consultant Name(D17), Client(E17), Percentage (F17),Margin (G17), Weeks (H17), Value (I17)

Each section follows this same structure and has 10 rows for data input

There are 5 teams in total but this may expand in the future (although not really relevant for any potentialsolutions)

What I want to achieve:

I want to have a summary sheet that can be used to provide some very basic reporting. I have already got calculations to show number of deals, average percentage etc but what I want tocreate is a list deals from all of the teams in one separate sheet. The key points are that I don’t want any gaps between the data – i.e if team 1 does 1deal I don’t want there to be 9 gaps before the first deal of team 2 and I also want all of the columns to be copied across to this new worksheet, so, effectively a list of all the “deals” done by all the Teams in one place without any gaps.


I can do some basic VBA but this is not something I can do.

It would be great if someone could give me some advice on how this could be done, I think it may be possible to loop but I don’t know where to start.

Thanks in advance.
Matt

 

[Excelnewbie11]

bump