G
Guest
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,T6,Breakdown!C:C)<1,"
",SUMIF(Breakdown!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
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,T6,Breakdown!C:C)<1,"
",SUMIF(Breakdown!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