Repetitive formula but different workbook and different column

Greetings -

I need help writing a macro for the below formulas that I type/update on a daily basis.

Please Login or Register  to view this content.

Hello,

I am not sure that I would recommend VBA and formulas the way you suggest.

The value 05-10 could be changed to a cell reference and then you change the value in that cell.
The change or report could possibly be solved by having a master report document where you import data daily and then keep the same reference. Is that an option?
If not I suppose that you can also use a cell for reference..., this is what GPT says about that:


Assuming you want to perform a VLOOKUP in a different sheet in a different file, and you want to refer to the filename in a cell, you can use the following formula:

Formula:

Please Login or Register  to view this content.

Here's an explanation of each part of the formula:

- `lookup_value`: This is the value you want to look up in the other sheet.
- `file_path`: This is the path to the file that contains the other sheet. You can enter the path directly into the formula, or you can reference a cell that contains the path.
- `file_name`: This is the name of the file that contains the other sheet. You can enter the name directly into the formula, or you can reference a cell that contains the name.
- `sheet_name`: This is the name of the sheet that contains the data you want to look up. You can enter the name directly into the formula, or you can reference a cell that contains the name.
- `range_lookup`: This is a logical value that specifies whether you want an exact match or an approximate match. Enter `TRUE` for an approximate match or `FALSE` for an exact match.
- `col_index_num`: This is the column number in the other sheet that contains the data you want to retrieve. For example, if the data is in the second column, enter `2`.
- `range_lookup`: This is the range of cells in the other sheet that you want to search for the lookup value. For example, if you want to search the entire sheet, enter `A1:B100`.

Note that the file path and file name should be enclosed in square brackets, and the sheet name should be followed by an exclamation mark.