I am trying to set a public function that searches for an identifier in some worksheet column A and returns its row number so i put this function like this:

I am trying to set a public function that searches for an identifier in some worksheet column A and returns its row number so i put this function like this:

I am trying to set a public function that searches for an identifier in some worksheet column A and returns its row number so i put this function like this:

I am trying to set a public function that searches for an identifier in some worksheet column A and returns its row number so i put this function like this:

I am looking to create a function that can be manually activated and will loop through selected Group input values from sheet 2 and then output those values into sheet 3 perspective cells

Delay = ws.Range(“J22”).Value
^^ Input from Excel Spread Sheet
Excel Cell Input

Good Day

i have a excel sheet that regularly updated. Thus, for certain values i wanted to use/refer, the cell ID or index is not fixed, but certain nearby other/intermidate (like section title, name, school, gender) inputs (can be number or text) are fixed. Therefore, i have to find the nearby intermediate cell ID by using cell values/input, then down or right few cells (let us say one cell) to get my target cell value/index. Then i can use the target cell id/index/address for other purpose. i followed this to create my own function. The whole worksheet (sheet1) is used for search and find.

I have a table (table 1) with objects on the Y-axis and customers on the X-axis.
Table 1 takes data from another table(table 2) were a object can be selected with a customer and a type of event is selected with a start date and eventually a end date, there is a comment section in table 2 as well.