-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Copying from periodic interval cells paste to another sheet cells
- Thread starter suresh01
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,544
- Office Version
- 365
- Platform
- Windows
Hi & welcome to MrExcel.
How about
How about
| +Fluff 1.xlsm | |||
|---|---|---|---|
| A | |||
| 1 | Row1 | ||
| 2 | Row2 | ||
| 3 | Row3 | ||
| 4 | Row4 | ||
| 5 | Row5 | ||
| 6 | Row6 | ||
| 7 | Row7 | ||
| 8 | Row8 | ||
| 9 | Row9 | ||
| 10 | Row10 | ||
| 11 | Row11 | ||
| 12 | Row12 | ||
| 13 | Row13 | ||
| 14 | Row14 | ||
| 15 | Row15 | ||
| 16 | Row16 | ||
| 17 | Row17 | ||
| 18 | Row18 | ||
| 19 | Row19 | ||
| 20 | Row20 | ||
| 21 | Row21 | ||
| 22 | Row22 | ||
| 23 | Row23 | ||
| 24 | Row24 | ||
| 25 | Row25 | ||
| 26 | Row26 | ||
| 27 | Row27 | ||
| 28 | Row28 | ||
| 29 | Row29 | ||
| 30 | Row30 | ||
| 31 | Row31 | ||
| 32 | Row32 | ||
| 33 | Row33 | ||
| 34 | Row34 | ||
| 35 | Row35 | ||
| 36 | Row36 | ||
| 37 | Row37 | ||
| 38 | Row38 | ||
| 39 | Row39 | ||
| 40 | Row40 | ||
Sheet1 | |||
| +Fluff 1.xlsm | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | Row10 | |||
| 2 | Row20 | |||
| 3 | Row30 | |||
| 4 | Row40 | |||
| 5 | ||||
Sheet2 | ||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B1:B4 | B1 | =FILTER(Sheet1!A1:A40,MOD(ROW(Sheet1!A1:A40),10)=0) |
| Dynamic array formulas. | ||
Upvote
0
Similar threads
