| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to delete unwanted sheets
Hi there,
I am creating a questionnaire type form which has a separate sheet for different subjects, each sheet has a rating total at the bottom. I am looking for a macro which will scan the entire workbook and delete those sheets that have a total of 0 at the bottom. Also these figures are consolidated into a final worksheet and I would like to be able to delete any columns that relate to the deleted workbooks above. Many thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting unwanted data by macro or... | Excel Discussion (Misc queries) | |||
| How do I delete unwanted extra pages on Excel worksheets | Excel Discussion (Misc queries) | |||
| Delete unwanted page breaks. | Excel Worksheet Functions | |||
| How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
| Delete Unwanted Data | Excel Discussion (Misc queries) | |||
Threaded Mode
