make cell active based on value - copy row it belonf to and paste to another row
Posted by Bryan on August 05, 2000 3:04 PM
Your site is incredibly helpful, please entertain the following question:
I have a spread sheet used to keep track of runtime statistics for batch jobs. One column contains
dates for every day of the year and another column lists the corresponding day of the week with "TODAY"
inserted in the cell in this column corrresponding to todays date. I need to be able to select a range of columns in the row in which this "TODAY" value exists in the day of the week column with a macro in excel '97. Once I
have the data copied, I need to paste it to another row. Please help. I don't know how to select a row to copy the data basd on the value of one cell within that row. How do you activate that cell? Your help is immensely appreciated.