Hi,
Can anyone help on how to create Log File in Vba. Say example I have number column in sheet1 and sheet2. If number column is not match in sheet1 and sheet2, then have to create Log File and have to say 'check the number col'.
Anyone help pls. Or any similar example of creating logs also appreciate.
Regards,
Raj
This is an example of making a log sheet based on trying to match data in column A of sheet 1 to data in column A of sheet 2 and recording the mismatches on sheet 3.
Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks