![]() |
*HELP NOW PLEASE*
need step by step instructions to extract data from column A starting with A1
and grab A4, A7, A10, A13, etc. -- ALFR |
For i = 1 To 100 Step 3 var = Range("A" & i).value Next i bit difficult to be more precise as 'grab' has no real meaning here, so I have no idea what you will do with the cells. -- HTH Bob Phillips "Arlene" wrote in message ... need step by step instructions to extract data from column A starting with A1 and grab A4, A7, A10, A13, etc. -- ALFR |
One way:
B1: =INDEX(A:A,(ROW()-1)*3+1) Copy down. In article , Arlene wrote: need step by step instructions to extract data from column A starting with A1 and grab A4, A7, A10, A13, etc. |
All times are GMT +1. The time now is 03:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com