Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulating a data file with some sort of Macro
If anyone could help it would be great. I am currently working on a dat
collection project dealing with strain data from a bridge. I downloa the data via a datalogger in a comma delimiated format. Each item i the data set has its own value. Lets say I have 65 strain gages tha are collecting data and I record every 10 minutes and download once week. Thats 655200 data points a week. Needless to say, the excel shee gets very large very quickly. In the past others have opened eac downloaded data set and manually copied the data from a particular gag and created a file that only contains information for that gage. So eac week they had to copy and paste into 65 different files. My question is, is there anyway to create a macro to help. Lets say.. Converting the comma format to columns, then picking out a certai column and copying the data from that column and inserting it into file that has already been created to store data from that gage ever week. This would require that the data be inserted at the bottom of th data that has already been included in that created file. If this coul be done it would cut out a lot of data processing work for us students Thanks for any help you could give -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manipulating ranges in a different file | Links and Linking in Excel | |||
Manipulating ranges in a different excel file | Excel Worksheet Functions | |||
Macro to Sort automatically when file/save is selected | Excel Discussion (Misc queries) | |||
Manipulating 150+ checkboxes with a macro in Excel 2000 | Excel Programming | |||
Manipulating 150+ checkboxes with a macro in Excel 2000 | Excel Programming |