Need to run a macro triggered by refresh all button

[Glenguskahn]

Hi all,

I have a workbook with 2 tables on 2 separate work sheets.
One table is a production schedule, containing production order numbers, part of a lookup table with an ODBC link. (Table 1)
The other table is a list of production orders, also taken from a query from our WMS system via ODBC, filtered to specific status stages on the production line. (Table 2)

I need to delete rows from table 1, when they appear on table 2, usually after clicking refresh all to update with our WMS.

I found a code that seems to work ok..

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

When I refresh the spreadsheet and a production order number appears on the table on the 'Data 1' sheet, I need it to be removed from the table in the 'schedule' tab.
Manually running the VBA code seems to do this. But what I really need is for this to run after the Refresh All button is pressed.

IS this possible? and if so could someone please point me in the right direction?

This would be so greatly appreciated!

[PrizeGotti]

You could just incorporate the Refresh function into your macro.

Please Login or Register  to view this content.