View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default columns wrong data

As you didn't give examples, hard to say, but try going to Data - Filter -
Auto Filter. Select the crtieria that you are looking for to find all your
rows. Now just cut/paste the date over to appropriate columns.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Pammy" wrote:

I have a spreadsheet when 2500 rows of information, in one of the columns
there is some data that should be in the next column. Is there a way I can
find the information and then cut this infor and paste in the next column. I
tried the find feature but it only does one at a time and with this many rows
it gets tiresome.