VB code to get data from closed file with criteria

[rizmomin]

Hello:

Please refer to 2 attached file.

I have data in Closed workbook "Transfer-ClosedFile" at location shown in cell B1 in attached file "TransferMacro.xlsb"

I need macro in file "TransferMacro.xlsb" which needs to do following.

Based on what is in cell B3 in "TransferMacro.xlsb" , I need to bring all data related to that cell and paste at C9.

I have manually pasted data in File "TransferMacro" file, If B3 is CW.

Let me know if any questions

Thanks

Riz

[rizmomin]

Hello:

Can anyone, help with this.
Thanks

R

[Leith Ross]

Hello Riz,

The attached workbook is the same one you posted with the macros below added to it. Now when the selection in "B3" changes the macro will run and add the data starting at "C9" on "Sheet1".

ThisWorkbook Module

Please Login or Register  to view this content.

Sheet1 Change Event Code

Please Login or Register  to view this content.