Auto Collect Data from another WorkBook

[skhari]

Please Help !!!

I have two workbook. I need to auto collect the data from WorkBook1 to WorkBook2 IF the conditions are True.
Attached the two reference WorkBooks in detail.

Thanks for your time and effort

[dangelor]

Try this code in a copy of WorkBook2...

Please Login or Register  to view this content.

[skhari]

Thank you so much Dangelor, that was perfect solution.
Is it possible to make Sorting by dates (if the dates are before and after entry).

[dangelor]

Added sort to final list.

Please Login or Register  to view this content.

[skhari]

Hi Dangelor, Your Sorting code made easy. Thanks a lot.
Sorry last query to finish it up. It seems that i have to open always both the workbook for to refer .?! or is there any way that WorkBook1.xlsx can be closed. Because workbook entries are handled by two person which is kept same server (same folder) user is different for each workbook.
Thanks for time

[dangelor]

Sorry, I don't have much experience using files on a server. I'll put in a request for help from someone who may...

[JBeaucaire]

I don't think it being on a server is the issue, you have to know the full correct path that your computer sees that folder, but other than that it should be a straightforward addressing issue.

So, the macro should check if the workbook is open, and use it normally if it is. If it is not, it will open the wb in the backlground, run, then close the workbook again. I'd suggest also noting whether WB1 is open or not already, so the macro does not close it on you.

Please Login or Register  to view this content.

[skhari]

That was perfect. Thank you very much dangelor and JBeaucaire, (Open Close File ) Works
Having problem in Sorting. I want to sort by date as-well. but still it is not happening (now the date is in "F" Row).

[JBeaucaire]

Here's the line of code that controls the sorting:

Please Login or Register  to view this content.

That 1 means column A, so change that to 6 for column F.

[skhari]

Thats it solved... Thank you so much