| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy data from every 100th row?!
I have a spreadsheet (2003) that every month imports data from a weather
station €“ a sheet for each month. There are about 50,000 rows of data for each month with 17 columns of data €“ temperature, wind speed etc. What would like to do is have a macro start at say F2 €“ copy that data then paste to say R1 €“ go back to F2 and move down say 100 rows and copy then paste to R2 etc. Any suggestions?! Appreciate your help. With thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel-Input numeric value in cell, it shows up as 1/100th of entry | Excel Discussion (Misc queries) | |||
| Numbers displayed in the 100th decimal instead on 1,000 | Excel Discussion (Misc queries) | |||
| How I keep the cells from becoming 1/100th of the value I enter? | Excel Discussion (Misc queries) | |||
| How can I enter 1/100th of a second into an Excel cell? | Excel Discussion (Misc queries) | |||
| How do I stop Excel from changing simple numbers to their 1/100th. | Excel Discussion (Misc queries) | |||
Threaded Mode
