tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
OK so need a bit of a saftety check on this so i dont mess up the data i bring in,
I want a macro that runs, and brings in the data from another open document.
I can do that part where we bring in the data but i want a macro that check everything is there first.
So In my Main Document I have Data in Columns A and B
For this part of the opertation i should have exactly the same data in columns A and B for the document i want to import.
for the time being i just to check if they both match and if so go ahead if they dont send me a message saying "data is not the same. please check and try again."
So basicly i need a macro to check if both sheets are the same and let me know,
the snag is i wont know the workbook name so need to base it on the only other open document. (i already have a macro checking this
Thanks
Tony
OK so need a bit of a saftety check on this so i dont mess up the data i bring in,
I want a macro that runs, and brings in the data from another open document.
I can do that part where we bring in the data but i want a macro that check everything is there first.
So In my Main Document I have Data in Columns A and B
For this part of the opertation i should have exactly the same data in columns A and B for the document i want to import.
for the time being i just to check if they both match and if so go ahead if they dont send me a message saying "data is not the same. please check and try again."
So basicly i need a macro to check if both sheets are the same and let me know,
the snag is i wont know the workbook name so need to base it on the only other open document. (i already have a macro checking this
Thanks
Tony