VBA project to search, organize and return

[brooksc29]

Hello all,

I am working on a project that is a bit over my head.

I have a workbook with daily information created on separate tabs (worksheets). Each worksheet is titled by date.

The format on each daily worksheet has rows under a headline "Facts", rows under a headline "Rumors" and rows under a headline "Highlights"

In each row, starting in column F, will be Date (column F)/ Team (G)/ Name (H) /Notes (L)/ Source (T) (there are some merged cells for formatting purposes).

The VBA will be needed to run a search program on a separate tab called PLAYER LOOKUP. I want the user to choose a name from a data validated drop down box (cell E3), and the VBA will take the name in that box, find and return all entered data by the chosen name and return the data under the appropriate headline of "Facts", "Rumors", or "Highlights" (it should be able to tell where the data is being pulled from).

Can anyone help me get started with this? (at least!!??)

Please let me know what I can provide to make this easier!

Thank you so much!
C

 

[brooksc29]

Mumps, is there a way for you to share this without me having to pay $5 to download it?

 

[brooksc29]

Nevermind on that... Can open without having to sign up.

But, even though the file preview looks different, when I download and open the file you sent it reverts back to the original format on PLAYER LOOKUP.

 

[mumps]

Are the FACTS, RUMORS and HIGHLIGHTS not beside each other starting in column L?

 

[brooksc29]

That's my error. Had to zoom out to see it all.

I will need to reformat some of the sheet still so it reads better. Would I be able to apply the VBA in the workbook you sent to the reformatted Template2 that I shared with you?

 

[mumps]

No, that won't work. There are still merged cells in the reformatted Template2, particularly in the "Date" sheets. If you click in cell F4 of any "Date" sheet, you will notice that nothing appears in the formula bar at the top. If you click on B4 of any "Date" sheet, you will notice that the Header does appears in the formula bar at the top. So although it looks like the cells from Columns B to G are merged with the header appearing in the centre, the cells are not merged but the header is still in the centre. This is the effect of "Merge Across Selection". The header is actually in column B not column F. This had to be done to make the macro work. If you really need the sheet to look like the reformatted Template2, I will have to do the same to that workbook and also modify the macro. Please let me know.

 

[brooksc29]

Sorry about that. I do think I like the display better for reading purposes on Template2. I do think it would be better to modify the macro if that's not too inconvenient.

Also, while working through the VBA on the file you sent, when switching through players it is leaving the previous player information in the same section. So if I look up player1 and it returns something for player1, then change to player2 it will keep player1's data and also have player2's data in the same column.

Also, if I try to choose a player that has no data to be returned, it does not clear out the previous player's data that was searched for.

 

[mumps]

OK. I have to go out now so I should have something for you tomorrow. Please keep in mind that if you add any more "Date" sheets, you will have to unmerge the cells and centre them across the selection. Do the following: unmerge the colored cells, then select them and right click on any of the selected cells, click the "Alignment" tab and then in the "Horizontal" alignment box, select "Center Across Selection". That's it!

 

[brooksc29]

Yes, I will take care of that so there will be a blank template for entering new days with no merged cells. Thank you for catching that!

And thank you for all your help! Have a great day!

 

[brooksc29]

Mumps,

Here is the most recent version of Template2.

https://www.dropbox.com/s/vtc2dmrert7q4mb/2019 NPB & KBO Daily Updates Blank Template2.xlsx?dl=0

I changed the Data Validation to a Combo Box, added another day of info and also reformatted the daily sheet so there are no merged cells.

Thanks!

 

[mumps]

Click here for your file. Please use this version as I had to make some other minor changes.