If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I copy and paste cells incrementally?
I am trying to copy and paste cells from one sheet to another. The problem
is that I want to copy every 5th cell in a column and place the data into a new column in one-cell incremnets. Any suggestions on how to do this? |
#2
|
|||
|
|||
hi,
not sure how much data you have but..... Hold down the ctrl key while selecting every 5th cell. use the mouse to select. then copy. when you paste, it will paste as a group ie not spaces between. -----Original Message----- I am trying to copy and paste cells from one sheet to another. The problem is that I want to copy every 5th cell in a column and place the data into a new column in one-cell incremnets. Any suggestions on how to do this? . |
#3
|
|||
|
|||
I tried that and it qorks quite well. However, I have over a thousand
records to do this way.....each with 24 fields......is there a formula or some type of way I can use the fill handle or something like that? " wrote: hi, not sure how much data you have but..... Hold down the ctrl key while selecting every 5th cell. use the mouse to select. then copy. when you paste, it will paste as a group ie not spaces between. -----Original Message----- I am trying to copy and paste cells from one sheet to another. The problem is that I want to copy every 5th cell in a column and place the data into a new column in one-cell incremnets. Any suggestions on how to do this? . |
#4
|
|||
|
|||
Using an empty column ADJACENT to your data:
1) in the same row as your first row of data type a 1 2) add 2 thru 5 in the 4 cells below the 1 3) copy those five cells and paste them down the rest of the column, all the way to the bottom of your data. You should now have repeating sets of 1 thru 5 4) select a cell anywhere in the column of numbers 5) choose Data | Filter | Autofilter from the menu bar 6) you should see little drop down arrows next to the heading for each column of your data and for the column of 1s thru 5s 7) in the 1-5 column, clikc the dropdown arrow and choose 5. This will filter all your data so that every 5th row is shown 8) highlight all the displayed rows and copy 9) go to your other sheet and paste "Slimmyy" wrote: I tried that and it qorks quite well. However, I have over a thousand records to do this way.....each with 24 fields......is there a formula or some type of way I can use the fill handle or something like that? " wrote: hi, not sure how much data you have but..... Hold down the ctrl key while selecting every 5th cell. use the mouse to select. then copy. when you paste, it will paste as a group ie not spaces between. -----Original Message----- I am trying to copy and paste cells from one sheet to another. The problem is that I want to copy every 5th cell in a column and place the data into a new column in one-cell incremnets. Any suggestions on how to do this? . |
#5
|
|||
|
|||
Thanks Duke! That worked perfectly!
"Duke Carey" wrote: Using an empty column ADJACENT to your data: 1) in the same row as your first row of data type a 1 2) add 2 thru 5 in the 4 cells below the 1 3) copy those five cells and paste them down the rest of the column, all the way to the bottom of your data. You should now have repeating sets of 1 thru 5 4) select a cell anywhere in the column of numbers 5) choose Data | Filter | Autofilter from the menu bar 6) you should see little drop down arrows next to the heading for each column of your data and for the column of 1s thru 5s 7) in the 1-5 column, clikc the dropdown arrow and choose 5. This will filter all your data so that every 5th row is shown 8) highlight all the displayed rows and copy 9) go to your other sheet and paste "Slimmyy" wrote: I tried that and it qorks quite well. However, I have over a thousand records to do this way.....each with 24 fields......is there a formula or some type of way I can use the fill handle or something like that? " wrote: hi, not sure how much data you have but..... Hold down the ctrl key while selecting every 5th cell. use the mouse to select. then copy. when you paste, it will paste as a group ie not spaces between. -----Original Message----- I am trying to copy and paste cells from one sheet to another. The problem is that I want to copy every 5th cell in a column and place the data into a new column in one-cell incremnets. Any suggestions on how to do this? . |
#6
|
|||
|
|||
Slim
In second sheet A1 enter this =OFFSET(Sheet1!$A$1,5*ROW() -1,0) Drag/copy down Column A until you return zeros. When happy, Copy/paste special(in place)valuesOKEsc Gord Dibben Excel MVP On Thu, 17 Mar 2005 10:15:03 -0800, "Slimmyy" wrote: I am trying to copy and paste cells from one sheet to another. The problem is that I want to copy every 5th cell in a column and place the data into a new column in one-cell incremnets. Any suggestions on how to do this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy & Paste Visible Cells with Formulas | Ricky | Worksheet Functions | 5 | January 27th, 2005 05:37 PM |
Copy cells and paste them as images in another sheet | Michael Cantinotti | General Discussion | 6 | November 7th, 2004 06:46 PM |
Copy and paste only visible cells under auto-filter | Phil | Worksheet Functions | 2 | August 25th, 2004 07:20 PM |
copy and paste cells | angie | Database Design | 3 | July 24th, 2004 02:25 AM |
Copy / Paste Merged Cells | LPS | General Discussion | 1 | June 26th, 2004 01:54 AM |