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

amadeusklein

New Member
Joined
Nov 22, 2011
Messages
2
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!!
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

amadeusklein

New Member
Joined
Nov 22, 2011
Messages
2
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...
 

Watch MrExcel Video

Forum statistics

Threads
1,122,521
Messages
5,596,648
Members
414,083
Latest member
Mrsash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top