Hello I am not very familiar with VBA coding. I have a master workbook which I am populating data from a number of other slave workbooks. In my master workbook I have a column(C) for "x coordinates" and a column (D) for "y coordinates". In column (E) I have an "R", "L", "T", or "B". What I need to do is be able to select a slave workbook to pull data from, and then find which row in the slave has the exact numerical values and column "C" and "D" in the master and then copy data from that row into the master workbook. There are three cells that need to be copied from the corresponding row, but which cells get copied and where they get copied to depend on the master's column "E", wither it is R, L, T, or B. I should be able to handle the specifics but could use help coming up with a way structure the code and select a slave workbook.Master.PNGSlave.PNG
Bookmarks