Creating New Books According To The Unique Values
That Consists Of Filtering Result
UserForm opens automatically when the workbook is opened.When pressed the button on the userform, unique values are
listed with the filtering method in a new sheet. Named folder according to date
According to the unique values in the column A , new
workbooks are created in folder , the data are copied into this workbooks.The hyperlinks are created for this new workbooks.
Excel Vba Get Data From Closed Workbook Import Data From Closed Book Based On The Value In The Cell (Without Using ADO)
The wanted values are being fetched from other closed books
according to Product No. in the in main file's column B . The fetched values
are listed in sequential rows.
There are 3 books in the same folder -according to need may be more than files - : main_file.xls , 13,xls , 14.xls . In our example, product numbers are starting 13 or 14 . For this reason ,the files are opens according to product no. (13.xls or 14.xls) and values are entered into main_file.xls.