LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How to reference another cell based on what row a certian header i

I would like to have a cell display the same thing as another cell on another
sheet. But the cell I was to reference might change columns often, but it
will always have the same header at the top of the column. So how can I tell
the cell to look at cell 5 for ex. but in the column that says Activity at
the top? remember that the column will change frequently.
 
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
Cell reference in header Terry Bennett Excel Worksheet Functions 2 September 7th 07 09:55 PM
reference cell in header Steve_n_KC Excel Worksheet Functions 0 May 17th 07 12:37 AM
cell reference in header Dana Excel Discussion (Misc queries) 3 January 30th 07 09:39 PM
cell reference in header row ML Excel Discussion (Misc queries) 4 August 26th 05 06:30 PM
Cell Reference in Header Dave Excel Discussion (Misc queries) 1 May 20th 05 08:56 PM


All times are GMT +1. The time now is 11:31 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"