| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stripping Selective Data from .CSV file to Excel w/VBA
I am a relatively soft user of VBA. I have mounds of production data
in a .csv files with the DATE in col A and the RATE in col C. I only need every 30 points of data (i.e. every 30th row of A and C - 1, 30, 60, 90, etc until the data ends) and paste the data into excel consecutively. I haven't figured out a clever macro to open the .csv file, choose the correct data, and paste into new workbook--hopefully somebody can help! I really appreciate it. Thanks, Joe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel data stripping | Excel Discussion (Misc queries) | |||
| Selective Copy from other excel file, sort, then deleteon a condition | Excel Worksheet Functions | |||
| Selective Copy from other excel file, sort, then deleteon a condition | Excel Worksheet Functions | |||
| Stripping Path from File String | Excel Programming | |||
| Selective read data from ascii file | Excel Programming | |||
Threaded Mode
