PC Review


Reply
Thread Tools Rate Thread

copying/sorting data with blank spaces in between?

 
 
brucefl
Guest
Posts: n/a
 
      6th Mar 2010
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting and copying data to another worksheet in a workbook. =?Utf-8?B?R2Vv?= Microsoft Excel Misc 3 5th Jun 2006 09:58 PM
Copying data to another sheet and sorting it automatically RJQMAN@AOL.COM Microsoft Excel Programming 2 10th Oct 2005 01:18 PM
skip blank row while copying data tonyDeBrasco Microsoft Excel Misc 1 25th Jul 2005 03:37 PM
Sorting blank and non blank column of data Hari Microsoft Excel Misc 1 23rd Jul 2004 12:13 AM
Sorting and copying data in Excel Jim R Microsoft Excel Discussion 2 17th Oct 2003 09:22 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:35 AM.