| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
fairly easy (i thought) copy and paste cells, increment by 17 accross
On sheet two in column A, place this formula: =INDEX(Sheet1!$J1:$J170,COLUMN()) returns J1 from sheet1 In column B place this: =INDEX(Sheet1!$J1:$J170,COLUMN()*17) returns the value from J17 sheet1 copy this to the right as far as needed for J34, 51, 68, 85.... then copy down as far as needed to work on J2, J3.... HTH -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=373981 |
|
#2
|
|||
|
|||
|
didnt think to use index, will try that tomorrow thanks muchly -- bleugh ------------------------------------------------------------------------ bleugh's Profile: http://www.excelforum.com/member.php...o&userid=23720 View this thread: http://www.excelforum.com/showthread...hreadid=373981 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| How do I copy and paste cells incrementally? | Excel Worksheet Functions | |||
| Not able to Paste cells | Excel Discussion (Misc queries) | |||
| Copy & Paste Visible Cells with Formulas | Excel Worksheet Functions | |||
| How do I edit, copy and paste text in excel cells? | New Users to Excel | |||
Linear Mode
