Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / April 2008

Tip: Looking for answers? Try searching our database.

Excel programming - Conditional sorting

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Praveen Mishra - 14 Apr 2008 07:44 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.