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 here:
______________________________________________________
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
Joel - 14 Apr 2008 07:49 GMT
The only real solution is to write a macro to remove and add the formating.
Remove the formating, fix the problems, then re-format
> Dear All,
>
[quoted text clipped - 14 lines]
> Regards,
> Praveen Mishra