C
Christina
I would like to select alternate rows within a range on a worksheet to copy
to another sheet. Any ideas on how to do this?
to another sheet. Any ideas on how to do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Nick Hodge
Christina
Use a spare column (I used B but any will do), enter this formula and copy
down to the full extent of your data. You will get alternating TRUE, FALSE
=MOD(ROW(A2),2)=0
Now invoke an autofilter (Data>Filter>Autofilter) and filter on which one
you want. Copy that data and pate to another sheet.
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
Use a spare column (I used B but any will do), enter this formula and copy
down to the full extent of your data. You will get alternating TRUE, FALSE
=MOD(ROW(A2),2)=0
Now invoke an autofilter (Data>Filter>Autofilter) and filter on which one
you want. Copy that data and pate to another sheet.
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
P
Peo Sjoblom
One fairly easy way, assume the date is in A2:A200 and you want to copy A2,
A4, A6 and so on, insert a new column adjacent to the one you want to copy
(if it is empty already no need to insert a new column), in this case in B2
you would put
=MOD(ROW(1:1),2)=1
now copy down using the fillhandle to B200, select both column and apply
data>filter>autofilter, form the dropdown in B select TRUE, select the
visible range and press F5, select special and visible cells only, press ctrl
+ c to copy and then paste into the other sheet, finally remove the help
range from both ranges
Or from the other sheet use a formula like
=OFFSET(Sheet1!$A$2,ROW(1:1)*2-2,)
copy down
Regards,
Peo Sjoblom
A4, A6 and so on, insert a new column adjacent to the one you want to copy
(if it is empty already no need to insert a new column), in this case in B2
you would put
=MOD(ROW(1:1),2)=1
now copy down using the fillhandle to B200, select both column and apply
data>filter>autofilter, form the dropdown in B select TRUE, select the
visible range and press F5, select special and visible cells only, press ctrl
+ c to copy and then paste into the other sheet, finally remove the help
range from both ranges
Or from the other sheet use a formula like
=OFFSET(Sheet1!$A$2,ROW(1:1)*2-2,)
copy down
Regards,
Peo Sjoblom
C
Christina
Thanks Nick. That is exactly what I needed.
Nick Hodge said:Christina
Use a spare column (I used B but any will do), enter this formula and copy
down to the full extent of your data. You will get alternating TRUE, FALSE
=MOD(ROW(A2),2)=0
Now invoke an autofilter (Data>Filter>Autofilter) and filter on which one
you want. Copy that data and pate to another sheet.
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
C
Christina
Thanks Peo. That is exactly what I needed.
Peo Sjoblom said:One fairly easy way, assume the date is in A2:A200 and you want to copy A2,
A4, A6 and so on, insert a new column adjacent to the one you want to copy
(if it is empty already no need to insert a new column), in this case in B2
you would put
=MOD(ROW(1:1),2)=1
now copy down using the fillhandle to B200, select both column and apply
data>filter>autofilter, form the dropdown in B select TRUE, select the
visible range and press F5, select special and visible cells only, press ctrl
+ c to copy and then paste into the other sheet, finally remove the help
range from both ranges
Or from the other sheet use a formula like
=OFFSET(Sheet1!$A$2,ROW(1:1)*2-2,)
copy down
Regards,
Peo Sjoblom