Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I just need to know if this is possible before I go learning all abou macros. I'm using an HMI program called RsView at the plant I work at, and it' recording data about processes to .dbf files. It creates two seperat .dbf files for each run. In one file it records the actual data, whic could be a temperature for a certain probe. If you scroll down you'l see the temperature change over time... Now, the silly part of this i at the very top of the column, instead of having the name of the dat like "Temp probe 1", it'll label the column with a number. Then yo have to go into that second file, look for that "Temp probe 1" label and to the right of that will be the number that corresponds to th data in the other file. I have NO idea why they made it work this way It would have been so much easier if they made the name of the data a the top of the column. What I need to know is if it's possible to write a macro that looks a the two files and automatically puts the name at the top of the colum for me. If this is beyond the scope of Excel just let me know -- bklin ----------------------------------------------------------------------- bkline's Profile: http://www.excelforum.com/member.php...fo&userid=2709 View this thread: http://www.excelforum.com/showthread.php?threadid=46605 |