NY2DR
10-19-2007, 10:42 AM
Hello all,
I have a sheet that is filtered.
Several rows that do not fit my criteria are hidden.
Here is what I would like to have done:
1- I would like to copy information from one cell,
2- select a range on my filtered list,
3- then paste it
4- AND NOT have any part of the hidden rows affected.
Example:
Lets say I have a sheet with up to 100 rows with information.
After I filter it, every odd numbered row is hidden.
If ALL the even rows have the word "off" and I would like to change a certain range to "nuetral",(lets say rows A6:A62) I don't want my hidden rows to be changed to "nuetral"
I just want the even rows, which I selected, that are not hidden, to be changed to "nuetral"
Is this possible? I tried pastespecial and specialcells method with no luck.
Please advise.
Thank you,
I have a sheet that is filtered.
Several rows that do not fit my criteria are hidden.
Here is what I would like to have done:
1- I would like to copy information from one cell,
2- select a range on my filtered list,
3- then paste it
4- AND NOT have any part of the hidden rows affected.
Example:
Lets say I have a sheet with up to 100 rows with information.
After I filter it, every odd numbered row is hidden.
If ALL the even rows have the word "off" and I would like to change a certain range to "nuetral",(lets say rows A6:A62) I don't want my hidden rows to be changed to "nuetral"
I just want the even rows, which I selected, that are not hidden, to be changed to "nuetral"
Is this possible? I tried pastespecial and specialcells method with no luck.
Please advise.
Thank you,