VBA-Copy multiple records from one workbook to another based on criteria

[ronalgreen]

Hello VBA experts! I am in need of some assistance. I am trying to extract rows of data from one workbook to another workbook using VBA. Here are the parameters:


Data Source: Workbook = Resource Planning.xlsx

Sata Source: Worksheet = Resource Allocation By Project.xlsx


Report: Workbook = Project Status.xlsx

Report: Worksheet = PVID.xlsx


The data source starts on row 2. The criteria(Job Number) can be found in column K. The number of rows of data changes so it needs to be dynamic.


The results should be displayed in the Report workbook starting in B49.There can be 1 or multiple records that meet the criteria.


Thank you for your assistance in advance!

 

[SirJB7]

Hi, ronalgreen!


This question has been asked lots of times and answered most times using VBA and a less times with formulas only.


If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, like the following one(s) -if any posted below-, maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.


Regards!


PS: BTW, even if worksheet names can end in ".xlsx" maybe you've added that suffix unwillingly in your first post. If so and you couldn't modify it (you have 30' from posting) please tell us so as to modify it for you.