Extract data from one worksheet to another

[dkim.ags]

Hello,

I'm trying to extract data based on a value I enter into a cell.

In workbook Book1, worksheet Sheet1, I enter in the Month in cell C5. There is data in the Data tab.

In workbook Book2, I want the data in Book 1 entered into the yellow space depending on the month entered in Book1.

For example, if I choose Mar in Book1, I wanted the yellow space in Book2 to populate with the Mar data.

Mar 7 6
Mar 94 9
Mar 9 8

Is this possible with a normal macro, not a private sub (worksheet change)?

Thank you!

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

Make Sheets("Data") active first.