LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default Identify Cell by Column Header and ID in Col A (Track Changes)

Hello:
I need to archive change history. When using "Track Changes", the change is
tracked per cell / target. However, the xls file is updated daily and the
range is no longer applicable as new rows are added each day. I therefore
need to add a module that will look at the range (on another sheet), offset
by the row# up to the column header, grab the header name, then offset to the
left to Col A to grab the ID (value in RxC1). I'm SURE someone already has
this worked out. Would you be willing to share?

Thanks much, Bettergains
 
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
identify sheet number in header? Steve Excel Discussion (Misc queries) 5 December 9th 08 12:29 AM
Return header cell of last column with data Karen Excel Discussion (Misc queries) 12 September 4th 08 04:05 AM
highlight row/column to track current cell ... and more! prupp New Users to Excel 3 February 11th 08 07:25 PM
How to set highlight for the column&row header of the active cell Jasmine Excel Worksheet Functions 1 January 14th 06 03:33 PM
Modify many row cell (header) to one column darby Excel Discussion (Misc queries) 2 August 24th 05 05:16 PM


All times are GMT +1. The time now is 06:27 PM.

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

About Us

"It's about Microsoft Excel"