VBA code to only print rows with matching names in column J

[Zimmerman]

Could someone help me with getting this figured out. In sheet 1 I have data in rows 4:329. What I would like to do is be able to create a macro that will look in column J and find all the matching Names (which should be around 15 rows) and then print only those rows. But I need it to print columns B:N when it finds the matching names.

Thanks in advance

[JOHN H. DAVIS]

Is the data in Column J sorted?

[bulina2k]

You think that you could upload a file with a few (not-sensible) rows ?
Where are the data located? What kind of data is in column J?
My first idea was to filter the whole table on a criteria from a inputbox on column J and then to printout the resulting sheet.

[Zimmerman]

No it is not. The data in column D is sorted. And I need it that way because it's dates sorted ascending.

[Rick Rothstein]

Could someone help me with getting this figured out. In sheet 1 I have data in rows 4:329. What I would like to do is be able to create a macro that will look in column J and find all the matching Names (which should be around 15 rows) and then print only those rows. But I need it to print columns B:N when it finds the matching names.

What do you mean by "find all the matching Names"... matching what?

[Zimmerman]

The same name. So if column J had 15 cells in that had the name Bob. I want to print only those rows that have Bob in column J

[Rick Rothstein]

The same name. So if column J had 15 cells in that had the name Bob. I want to print only those rows that have Bob in column J

I guess my actual question (using the name you just posted)... how do we know the name is Bob? Is the name going to appear in a certain cell (if so, which cell)?... or will the name always be the same (Bob)?... or will the name be assumed from the value in the active cell?... or should the program ask you what the name is?... something else?

Oh, by the way, you said this in your original post, "But I need it to print columns B:N when it finds the matching names"... printed where?

[jolivanes]

Something like this? See attached.
Select a name from the listbox when you open the workbook.
Download and save the workbook macro enabled.

[Zimmerman]

jolivanes that is perfect!!! Thank you so much!!

[jolivanes]

Thanks for the heads up
Maybe this is better as you can change things before you need to make a decision.
Good luck