Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding empty cells
I have a workbook with 10 worksheets (tabs) each with a Header Row with the
month of July dates across the top and a Header Column with other information running down the side. What macro would search all 10 sheets for the last date (column) that might have an entry from any of the rows, search back from there through July 1st and identify all blank cells or cells with a red "fill" and consolidate all of them on a new worksheet? Thanks for any help, Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding data amongst empty cells | Excel Discussion (Misc queries) | |||
Finding number of empty cells | Excel Programming | |||
Finding Empty Cells | Excel Programming | |||
finding/highlighting empty cells | Excel Programming | |||
Macro trouble finding 'empty' cells | Excel Programming |