[libreoffice-users] Referencing data in a row based on content of cell value in column A?

Hi all,

I have a problem I'm hoping someone can help me with.

I have a workbook with multiple sheets, some of which reference data 
from other sheets in the workbook.

I have one 'Main' sheet, that lists our Sales Reps, and has each ones 
monthly numbers, by column, ie:

1  Name  Jan  Feb  ...  Dec  YTD
2  Rep1  ###  ###  ###  ###  ###
3  Rep2  ###  ###  ###  ###  ###

I have other sheets that have these Reps broken down by Team, and 
pulling each Reps numbers from the Main sheet.

The problem is, I need to be able to sort the Main Sheet by the Sum 
column (to show the top Sales Rep), but when I do that, since the 
references on the Team sheets still reference the same Col/Row, the 
numbers are now wrong.

Googling reveals this is apparently by design, as the Rows themselves 
aren't changing.

So, I was think if I could reference it instead of by Row#, by the 
content of A# - ie, instead of:

'Main.A2' for the Jan numbers for Rep1, something like:

'Main.A"Rep1"'

Is this possible? I really want to keep this as simple as possible, and 
would very much prefer to avoid having to script anything...

Thanks for any suggestions or pointers...

Charles

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted