Copy rows when column matches a user input from another workbook

Originally Posted by cjc155

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

Hi cjc155,
Check out this example first on how to filter data from one sheet to another.
http://www.excelforum.com/attachment...9&d=1202188669
Located at this thread
http://www.excelforum.com/showthread.php?t=632073
You will have to supply more detail after you have that figured out

Hi Dave,


Everything works fine save for one issue. In my first column (column A) of the range I have dates. When I paste the range into its new location, the date (in format mm/dd/yyyy) gets an extra day and 4 extra years added on to it. So for example, if my first row had a date of 5/1/2008, the value gets pasted a 5/2/2012. This is my code. Any help would be great. Thanks

Please Login or Register  to view this content.

Nothing in your code would do that...
May require "paste special values" if the dates are formulas, is this the case?