I am trying to sum values from a table where both row and column references are dynamically generated from concatenated strings in separate cells. Specifically, I need to:

I have the following data in table July24_Details_1

Extracting date From Reference

I have a file which has multiple rows. In each row, I need to do a calculation. For example, in cell D1, I write:

I have a Table in Excel 365 called MyLongData that contains multiple rows. I would like to come up with a formula that tracks claims, where a claim is defined as a unique combination of fields [Accident Date], [Claimant Name], [Location].

Lets say Bundle 1 has Product A, B and C
I have 3 tables:

I have a multi-column spill with data where some of the information is reflected incorrectly. We created a table to search if it’s one of the incorrect records, I would like to search if it exists in the list, and if it does pull the value. This works as expected.

Friends, I have links in one column in my Excel file that are created by the hyperlink function. And I click on each of these cells every day to open the desired page that is related to a site.
I wanted to ask if it is possible to make a macro so that all these cells are automatically clicked and all those sites are opened in the browser by pressing a button?
I don’t want the links to be inside the macro itself, I want the macro to run those cells, like a cell click simulator.I use Excel 365
I’m sorry, I don’t know English, if maybe I couldn’t ask my question well, it’s because of translation google!