Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 30
Default linking within a workbook and sorting

I have an issue whereby I have linked cell in Sheet 2 that's linked to Sheet
1. When the sheet1 area sorts, my cell in Sheet 2 looses the data I want to
capture.

sheet1 below has this list, cell C4 has range name 'detail3'

A B C
line details number
4 detail 4 103
3 detail 3 102
2 detail 2 100
1 detail 1 99

In Sheet 2.C3 there is a link to Sheet1.C4.
When I sort Sheet1 list my Sheet 2 doesn't capture the data I want.


--
bmac
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 897
Default linking within a workbook and sorting

Use range names. If you name Sheet1!C4, then use the range name in
Sheet2!C3 when referring to the cell on sheet 1, you can resort Sheet
1 and preserve the reference.

--JP

On Oct 8, 9:09*am, bmac wrote:
I have an issue whereby I have linked cell in Sheet 2 that's linked to Sheet
1. When the sheet1 area sorts, my cell in Sheet 2 looses the data I want to
capture.

sheet1 below has this list, cell C4 has range name 'detail3'

A * * * * * * * * B * * * * * * C
line * *details number
4 * * * detail 4 * * * *103
3 * * * detail 3 * * * *102
2 * * * detail 2 * * * *100
1 * * * detail 1 * * * *99

In Sheet 2.C3 there is a link to Sheet1.C4. *
When I sort Sheet1 list my Sheet 2 doesn't capture the data I want.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 30
Default linking within a workbook and sorting

Hi JP
thanks for responding, however something is not working.
In Sheet1. c4 I gave the range name. I went to Sheet2 and entered =nameLine2

I went back to Sheet1 and resorted the data.. Sheet2 kept the location, but
the cell I want to keep was sorted at the bottom..

I want to be able to link a Sheet1 cell (contents being 101), in a Sheet 2
cell, that has =namelink2 - wherever that Sheet1 cell moves - I want my
Sheet2 cell to still be that results, contents being 101.

--
bmac


"JP" wrote:

Use range names. If you name Sheet1!C4, then use the range name in
Sheet2!C3 when referring to the cell on sheet 1, you can resort Sheet
1 and preserve the reference.

--JP

On Oct 8, 9:09 am, bmac wrote:
I have an issue whereby I have linked cell in Sheet 2 that's linked to Sheet
1. When the sheet1 area sorts, my cell in Sheet 2 looses the data I want to
capture.

sheet1 below has this list, cell C4 has range name 'detail3'

A B C
line details number
4 detail 4 103
3 detail 3 102
2 detail 2 100
1 detail 1 99

In Sheet 2.C3 there is a link to Sheet1.C4.
When I sort Sheet1 list my Sheet 2 doesn't capture the data I want.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking cells together when sorting IT Drew Excel Discussion (Misc queries) 1 August 27th 09 12:59 PM
Linking then sorting mbwooten New Users to Excel 1 June 20th 07 04:31 PM
workbook linking cells not working within a workbook martyn Excel Discussion (Misc queries) 1 November 3rd 06 01:11 PM
Linking Master Workbook & subordinate workbook Lucky_guy2000 Excel Discussion (Misc queries) 1 July 14th 06 10:43 PM
Linking messed up when Sorting Jugglertwo Excel Discussion (Misc queries) 1 March 17th 06 09:23 PM


All times are GMT +1. The time now is 09:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"