Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel programming - Conditional sorting
Dear All,
I am facing a problem which has taken much of my time. I have to set of data parallel to each other, related, but not in sync I have inserted divider whenever the data changes, horizontally. But I can see that there are empty cells in between the divider even if one particular section contains accurately the same set of data. I canm not delete the empty cells as it would affect the dividing rows. Could you all please let me know some way out. I am giving excerpt he __________________________________________________ ____ BEST BUY CO. INC. - 86516101 BEST BUY CO. INC. - 86516101 BEST BUY CO. INC. - 86516101 BEST BUY CO. INC. - 86516101 ---------------------------------------------------------------------------- Do revert in case any further information is required in this regard. Regards, Praveen Mishra |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel programming - Conditional sorting
The only real solution is to write a macro to remove and add the formating.
Remove the formating, fix the problems, then re-format "Praveen Mishra" wrote: Dear All, I am facing a problem which has taken much of my time. I have to set of data parallel to each other, related, but not in sync I have inserted divider whenever the data changes, horizontally. But I can see that there are empty cells in between the divider even if one particular section contains accurately the same set of data. I canm not delete the empty cells as it would affect the dividing rows. Could you all please let me know some way out. I am giving excerpt he __________________________________________________ ____ BEST BUY CO. INC. - 86516101 BEST BUY CO. INC. - 86516101 BEST BUY CO. INC. - 86516101 BEST BUY CO. INC. - 86516101 ---------------------------------------------------------------------------- Do revert in case any further information is required in this regard. Regards, Praveen Mishra |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional programming | Excel Worksheet Functions | |||
conditional programming | Excel Programming | |||
Visual Basic programming in Excel for conditional formatting | Excel Programming | |||
Conditional Sorting in Excel | Excel Discussion (Misc queries) | |||
Conditional Formatting and programming??? | Excel Programming |