copying/sorting data with blank spaces in between?

Discussion in 'Microsoft Excel New Users' started by brucefl, Mar 6, 2010.

  1. brucefl

    brucefl Guest

    I have a membership list I need to update for a club. I have used Excel very
    little.
    I have been trying some different things to see if this will work before I
    get the data file (which I will back up before hand)
    In 3 columns to the right it has year dates in them. I need to change them.
    depending on the person, the first column would all be the same changed from
    2007 to 2008. The problem is, there are spaces between some of those
    particular columns. (see below) when I try to highlight them individually and
    past, say 2008, it will not allow me. Is their a way to do this? It says I
    can't do this in multiple selections.
    2007

    2007
    2007

    2007
     
    brucefl, Mar 6, 2010
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. sdrendon

    Blank rows between data

    sdrendon, Jun 29, 2004, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    177
    Dave Peterson
    Jul 1, 2004
  2. Guest

    Sorting and copying automatically between worksheets

    Guest, Feb 10, 2006, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    198
    Guest
    Feb 12, 2006
  3. Ian1

    Automating data copying between work sheets

    Ian1, Feb 15, 2006, in forum: Microsoft Excel New Users
    Replies:
    6
    Views:
    173
  4. Guest

    Removing a blank cell between data

    Guest, Feb 27, 2006, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    199
    Guest
    Feb 27, 2006
  5. JohnM

    Copying Selective Data Between Worksheets

    JohnM, Jun 14, 2009, in forum: Microsoft Excel New Users
    Replies:
    5
    Views:
    263
Loading...

Share This Page