Hi,
I have an input area on a worksheet that is two columns wide, columns O and P. Data are entered or deleted in pairs. I want to clean up gaps when pairs are deleted without upsetting the formatting.
Deleting whole rows is not useable because it effects other parts of the worksheet and the formatting of the input area. I've tried more than a dozen macros that I found online and so far, every one messes up the worksheet.
It seems like the macro should copy, then paste the values one row up into the now blank row. I don't know how it would do this for multiple blank rows in the columns.
Does anyone in the Forum have an idea for a macro that could do this?
Thanks,
Art
I have an input area on a worksheet that is two columns wide, columns O and P. Data are entered or deleted in pairs. I want to clean up gaps when pairs are deleted without upsetting the formatting.
Deleting whole rows is not useable because it effects other parts of the worksheet and the formatting of the input area. I've tried more than a dozen macros that I found online and so far, every one messes up the worksheet.
It seems like the macro should copy, then paste the values one row up into the now blank row. I don't know how it would do this for multiple blank rows in the columns.
Does anyone in the Forum have an idea for a macro that could do this?
Thanks,
Art