Hi All,
I'm after a bit of help!
I have an excel speradsheet with columns A to AB populated with a mix of data and lookups. what I would like to do is have a macro that would look at cell AB1 and if an "X" is populated it would copy the row and paste it as values then look for the next "X" in column AB and repeat the paste special.
By doing this I'm hoping to reduce the overall file size.
Thanks for looking
Daron
I'm after a bit of help!
I have an excel speradsheet with columns A to AB populated with a mix of data and lookups. what I would like to do is have a macro that would look at cell AB1 and if an "X" is populated it would copy the row and paste it as values then look for the next "X" in column AB and repeat the paste special.
By doing this I'm hoping to reduce the overall file size.
Thanks for looking
Daron