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: 11
Default finding and replacing a cell

I need some help. I am working on a schedule.I have 14 different sheets and
each sheet is named in two digit format according to the date. I also have a
hidden sheet named INFO

On the Info sheet I have a column with different initials, and the third row
contains the date also in two digit format.
I can get the initials from the Marco being worked on at the time and I
think I can get the date from the sheet name being worked on
So here is the question. How do I change the cell that corresponds to the
row containing the initials and the column with the date on sheet info. the
date will change and from time to time so will the initials so the area does
not have named ranges but I could do this if that is required I just thought
that might be in the wrong direction.
Any help would be appreciated
Thanks Rod




 
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
finding and replacing text with a blank Tom Excel Discussion (Misc queries) 2 May 10th 09 12:01 AM
finding and replacing HELPNEEDED!! Excel Worksheet Functions 2 July 3rd 08 01:17 PM
Finding and Replacing Jan Excel Discussion (Misc queries) 3 January 11th 07 05:50 PM
Finding, Replacing and Cut & Paste cs_vision Excel Worksheet Functions 3 April 26th 06 09:23 PM
Finding and Replacing a "?" Mcobra41 Excel Discussion (Misc queries) 2 March 9th 05 06:57 PM


All times are GMT +1. The time now is 01:47 AM.

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"