Excel issue - revenue tracker

Hi,

I have returned as i know that the help provided on here has always helped me in the past.

Basically the issue i have is as follows:

I have a main revenue tracker report that has columns No. | BSM | Team | MTD Target | Gross Sales | Losses | NET | Varience | % Acheived | Target |

What i have been asked to do is using this main report produce a similar report for each team that will only display their relevant figures without visibility over any other teams data. Easy you say, however as each BSM gets a sale we re-arrange the sheet to display in highest 'NET Acheived' order, so as this is changed each time the seperate worksheets are changing team content because the formula used is referencing against the cell that BSM was present in before the re-order. I need to pull the information within each column, per Team, per BSM without it changing if the order of the main report is changed.

I appreciated any help in advance.

Thanks.

Hi Hemesh,

Sorry it has taken so long to reply, thank you for the formula, it has certainly worked in the test file i sent over to you so i am going to try it in a live environment today. Thank you for your help on this query.

Dan.