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

Assuming the probe label is in cell A1 of sheet1 and the 'translation
is A1:B100 on sheet2, you could use a VLOOKUP to find this info, e.g.

=VLOOKUP(SHEET1!$A$1,SHEET2!$A$1:$B$100,2,0) where sheet2 is set u
with the probe identifier in column A and the Probe Name in column B.
The '0' at the end of the formula forces an error if an exact match t
A1 is not found.

HT

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=46605

You're assuming they're in the same file just on seperate sheets. That'
not the case here, if it were I know that would be possible. These ar
two completely seperate files. One is called "data.dbf" and the othe
is "tagname.dbf"

--
bklin
-----------------------------------------------------------------------
bkline's Profile: http://www.excelforum.com/member.php...fo&userid=2709
View this thread: http://www.excelforum.com/showthread.php?threadid=46605

My assumption was that you had already imported the data in Excel from
your two .dbf files. You would then use this formula to decode your
probe data.
I don't know of a way to have Excel do this process <prior to
importation.

Sorry for the misunderstanding.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=466058

That's kind of the answer I was expecting. I guess it wouldn't be too
hard though to import the data from the "name" file into another sheet
of the "data" file.

Thanks for your help!


--
bkline
------------------------------------------------------------------------
bkline's Profile: http://www.excelforum.com/member.php...o&userid=27090
View this thread: http://www.excelforum.com/showthread...hreadid=466058