Search results for query: *

I have now tryed to use the ms query but I don´t quite understand how I can use it in my code. It seems very handy tool but I have never even seen that so it is quite hard to understand how to use it.. Could someone please post an example code I would be very grateful for that. thanks

thanks Skip I give it a try tomorrow and post the results

no it was just an example. This macro is used in many different kind of workbooks so it have to in the form where user picks the link column so it can be just about anythin of course it have to be in both of the workbooks.

ok lets try again. first of all the books are in the same computer but I need to collect the changes because I get a new workbook and I have to compare if there is some changes comparing the old one. There is about 7000 rows in that workbook so I do not want to compare these by manual. I try...

umh... thanks for posting, but I´m not sure if that does the trick for me. I need to see both of workbooks because the result of comparing the data will be in both of these tables. Like this: if the data in cell (x) have been changed --> backroundcolor of cell (x) turns yellow in new workbook...

Thank you very much Richard. Yes it does interest me. please post the code. thanks again

I'm stuck in my project to copy data from table which is in another workbook. The copy-paste phase is done already but I need a way to select a column to "link" the copying rows. This is almost done but when I select a range where the paste is done I need to check if this selected column is in...