Posted by John Pollard on April 11, 2001 6:53 AM
I am just getting started with Excel and need help on two macro functions; The first is where I have a column with a text cell followed by various cells with the number 1, followed by a text cell followed by various cells with the number 1, etc. I would like to replace each of the number 1's with the text cell above it for the entire column. It would read copy, drop down one cell, if this cell = 1, paste, else copy, drop down one row, if cell = 1, paste, else etc.
For my second problem, I have sorted a large spreadsheet by a column and i would like to delete all rows where the cell in the sorted colum does not equal a specified value.
Thanks for yourn help.