Dummy Excel
Well-known Member
- Joined
- Sep 21, 2005
- Messages
- 1,004
- Office Version
- 2019
- 2010
- 2007
- Platform
- Windows
Hi All,
is it possible to have a formula that can copy the data down column C, G, K, and O and paste it in column Q?
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
is it possible to have a formula that can copy the data down column C, G, K, and O and paste it in column Q?
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Depot | Type | Rego | Depot | Type | Rego | Depot | Type | Rego | Depot | Type | Rego | Rego | Depot | Type | ||||
2 | city | Exc 1.8T | apples | beach | Exc 1.8T | blueberry | unit | Exc 1.8T | grapes | house | bread | ||||||||
3 | city | Exc 1.8T | banana | unit | Jetter S | figs | house | rolls | |||||||||||
4 | city | Exc 1.8T | strawberry | house | chair |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet3
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>
Last edited by a moderator: