Hello Friends how are you?
I am struck with a problem........
I have a workbook which Contains Two Sheets i.e. Sheet1 (Master Data) and Sheet2
I have some ID in Sheet2 ID (Column A).........i want to match Sheet2's ID from Sheet1's ID.........and display only unique IDs records of Sheet2 in listbox
for example:-
In Sheet2 ID No. 110 exist in Sheet1 also, this record should not be display in Listbox
In Sheet2 ID No. 120 not exist in Sheet1, so this ID's Data should display in Listbox
I want to make it dynamically so the data in future increase or decrease
When i Click on 1st Command Button (display only unique IDs records) It shows the only data of Sheet2's ID which not exist in Sheet1......
after that Listbox contains unique record of sheet2 which does not exist in Sheet1
When i click on Commandbutton2 (Export to Excel) it create a folder in Drive D namely Report Folder and save the listbox's result in excel file "report generate on Current Date (01.10.2017)
please help me to write a code for me................
Bookmarks