skipping rows

  1. Z

    Skipping rows

    Hey, I have 2 columns of 95 cells in sheet 1. What i want is: Sheet 1 A2 in Sheet 2 A1 Sheet 1 B2 in Sheet 2 A2 Sheet 1 A10 in Sheet 2 A3 Sheet 1 B10 in Sheet 2 A4 Sheet 1 A18 in Sheet 2 A5 Sheet 1 B18 in sheet 2 A6 and so on As you can see it's skipping 8. Your help is greatly appreciated!
  2. A

    Skipping Rows in Excel Function

    I am trying to paste data from Sheet 1 onto Sheet 2 and have 5 cells skipped on Sheet 2. I need to drag the formula down so that: Sheet 1, Cell B2 = Sheet 2, Cell A2 Sheet 1, Cell B3 = Sheet 2, Cell A7 Sheet 1, Cell B4 = Sheet 2, Cell A12 And so forth... Then in Column B on Sheet 2, I need to...
    • ACrelia
    • Thread
    • excel formula skip a row skip rows skipping rows
    • Replies: 7
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top