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: [email protected]
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
