Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
clear all except formulas, conditional formatting and validations
I have a master workbook that tracks all projects for my firm (tabs are
Active, Closed, New). I email each project manager (approx. 16) their section of the master list to update on a bi-weekly basis. Once updated, they are emailed back to enter into the master list. Through out the cells (A thru BL) are various formulas, conditional formats and validations. If I need to delete a row in the Active sheet after its been copied over to the Closed tab sheet, how can I delete the data but not delete the formulas, conditional formats and validations within that row? I have used the Edit/Go To/Special/Constants but it always seems to delete a formula, validation or format someplace within the row. Is there a macro that I can run where I can specify exactly which cells I want the data to be deleted from? I've tried to "record macro" and select cells, but it ends up only working on row 8 and nothing else.... Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|