Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to clean up data
I have a file that comes in weekly that I take numerous steps to clean up the
data for my reports. I am hoping to automate some of these. Could one of you experts help me to create a macro to do the following: Every third column (beginning with C thru X) contains SUMIF formulas to calculate totals - ie: =IF(SUMIF(Breakdown!D:D,T6,Breakdown!C:C)<1," ",SUMIF(Breakdown!D:D,T6,Breakdown!C:C)). If the formula results in a blank, then I need to delete that cell and the two cells to the right of it, and move the rest of the cells up. For example, if C3 and C6 are blank then I need Cells A3, B3, C3, A6, B6, and C6 to be deleted and all existing cells in those columns to move up. This needs to be done for all the blank cells in the totals columns stated above. I have some experience with macros and VBA, but I need some help getting started on this one.... Thanks, Diane |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Clean Up | Excel Discussion (Misc queries) | |||
clean up data | Excel Discussion (Misc queries) | |||
Clean Up Data | Excel Discussion (Misc queries) | |||
HOW DO I CLEAN UNCLEAN DATA? | Excel Worksheet Functions | |||
Get out clean XML data | Excel Discussion (Misc queries) |