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

On 07-06-2013 17:17, Tanstaafl wrote:
> 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

This seems to be a bug.

The reference to you first sheet (Main.A2) should be to the same cell, 
even after sorting your data in this first sheet.




--
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