Vbe to search for selected cell value in another table

[Xalova]

The situation is as follows:

I have a "main table" which is *full* of data. Im talkin abut 1500 entries. Then i have another table, which is for filtering. I have already figured out how to filter the table for what im looking at.

But what i now need is a way to search for a selected value from the filtered table in the main table and select it. Idk, if thats enough information, but i try to provide more:

The main table has about 10 columns. Not every column in every row is filled. Thats rarely the case. But i want to be able to enter information retropspectivly. So the best way i could think of is:
I search the table for my desired information, see that a item isnt fully descripted in the main table, select the the name of said item, click the macro button, and then VBA magic happens and it selects the Cell in the main table with the same value as the selected cell.

Im open for new ideas tho, which may be easier!

 

[Xalova]

You are welcome.
Glad to hear that it all worked out!

it worked perfectly. up until now. though i must say that i copied and pasted the functions to a different workbook, but it should do the same. Now what i want to search for is the current date and let the macro select the cell with the current date in the table for me. But... it doesnt work. it simply just doesnt like any kind of date. i tried it in many different ways. but all are unseccessfull. Do you have any idea?

the perfect solution would be

Sub MyFind()

    Dim rng As String
 '   Look up value from active cell and get cell address it is located in
    rng = FindValueInTable("12345", Date 1)
    
'   Select cell on "G-Nummern" sheet
    Range(rng).Select
    
End Sub

but that doesnt work whysoever...

 

[Joe4]

You will need to format the date to match the format that your workbook currently uses, i.e.
rng = FindValueInTable("Sheet1", Format(Date, "d-mmm"), 1)

 

[Xalova]

You will need to format the date to match the format that your workbook currently uses, i.e.
rng = FindValueInTable("Sheet1", Format(Date, "d-mmm"), 1)

worked perfectly. Thank you, again

 

[Joe4]

You are welcome.

 

[Xalova]

worked perfectly. Thank you, again

third times the charm :D

soooo now i have a whole new workbook where the value i search for is located. Do you think that theres a way to reference a table in a different workbook?

 

[Joe4]

soooo now i have a whole new workbook where the value i search for is located. Do you think that theres a way to reference a table in a different workbook?

I think that is a whole new question for a new thread.