Using VBA to run an if/then and copy paste based on result across workbooks

[amadeusklein]

But not so simply done....

I apologize in advance if this is out there somewhere, but I couldn't seem to find it anywhere. I have been searching for where to begin for about a week with no real progress. I'm very good in Excel and Access, but do not use VBA all that often (My organization is paranoid about macros) and have very modest VBA skills...

Ok, I have 2 worksheets, holding current trailer status'. (I can't use 1 because The sheets have to be accessible on 2 different network drives (That can read from each other but not edit each other). They are identical and laid out like so:

Col B Trailer Number
Col C Status
Col E Location
Col G ID Number
Col H Time Stamp

All Using Rows 2-20

Columns A,D,F are blank for spacing needs

Here's what I'm trying to accomplish-

Using a button to run the code:
If on sheet 2, for each trailer number (row of data), "If Sheet 1 Col H > Sheet 2 Col H copy row from sheet 1 into same row on sheet 2", and vice versa on sheet 1...

this way the user can have the most updated trailer status regardless of which sheet they use...

This is the only way I can see accomplishing this using excel...

I can't use Access to do it (Way simpler) because The restrictions placed on the users computers prevent them from installing Access on them (Even the Runtime for a Standalone DB)

Using Excel 2007, Windows XP...

This all seems to make sense to me, but my brain is fried...

Thanks in advance for any help!!

 

[amadeusklein]

Anybody?

I've been scouring the site and web and see it is possible to pull data from a closed workbook using VBA and updating links... But I can't seem to figure out how to combine the auto update macro with the if/then macro to accomplish this...