Hi,

This is my first post so I hope this is the right spot to place the question.

Here is my situation. I have 3 workbooks.

WB 1 - Input.xls - Is where I put my cell references to run some macros
WB 2 - Sales.xls - A list of sales by region
WB 3 - Output.xls - basically where I am formatting the results of the macros, but for this example, we can consider it completely blank.

I am trying to add a macro that will look at the Input workbook and take the value in cell C5 which is a user input that selects a region (i.e. MW). Use that value and go to my SALES.xls workbook and search the entries where the region (in column T in sales.xls) matches the region from the input. When the region matches, copy and paste the row into the workbook "Output.xls."

I have also posted this question at mrexcel.com and will post replies in both elocations for future users to reference. Thanks for the help