In the attached is a button near cell A2 of the Final sheet which runs the macro blah which does the same thing as before (refreshes the query table at L5 of the Final sheet) plus makes copies of the columns to your columns A and C.
Be aware that I don't delete any previous data in your table, only overwrite, so if the lengths of the tables are different or they're in a different order you'll get mis-aligned data, so it's best to delete the whole table (yours) first.
The query table is at L5 of the Final sheet, but it can be anywhere in the document (perhaps give it its own hidden sheet?).
For comparison, there's a copy of the output of Bob Phillip's macro CopyDealerAccountNumber. They seem to be exactly the same.
Your account numbers in column C are all numeric (no alpha characters at all); will they always be so? If not, my query might need a tweak.
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Reply With Quote