+ Reply to Thread
Results 1 to 2 of 2

Creating borders to changing data sets and merging groups of identical cells

  1. #1
    Registered User
    Join Date
    07-22-2010
    Location
    Greenock
    MS-Off Ver
    Excel 2003
    Posts
    1

    Creating borders to changing data sets and merging groups of identical cells

    Hi all

    I'm new to Macros/VB but I'm enjoying learning and I'm quite chuffed with what i have achieved so far (mostly just formatting macros).

    However, I have a few things i can't get my head round.

    1. I want to put a border round my data, to give it a table feel and make it easier on the eye. However, the number of rows I have changes everytime I import a new set of data. How do I put a border round only the cells that have entries in them?




    2. I want to merge cells that have the same entry in column A. See below:

    BIL_12_38_100
    BIL_12_38_100
    BIL_12_38_100
    BIL_12_38_100
    BIL_12_38_101
    BIL_12_38_101
    BIL_12_38_101
    BIL_12_38_102
    BIL_12_38_102
    BIL_12_38_102

    Idealy there should be only 1 entry for each, but I want to keep the number of rows, so merging them is what I need to do.


    Any ideas?
    Last edited by Mandela; 07-22-2010 at 08:42 AM.

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099

    Re: A couple of queries

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1