closed workbook lookup

Hello! I'm trying to make a dynamic reference to a closed workbook in my report. Currently, a straight-up hardcoded link looks like this: ='G:\Reports\Management Reporter\[India Trial Balance 2023 in US dollars v2.xlsx]ManagementReporterISbymonth'!J16 My goal is to have the bolded part be...

So this might be a silly question .... I have done some research and haven't quite found an answer that either makes sense to me, or is clear enough. I am having an issue with some of my formulas. I have workbook 1 (wb1) and workbook 2 (wb2). In wb1, I have some formulas, let's use Vlookup as...

I have a number of different workbooks, let's just call them workbook 1, workbook 2, etc.... Each workbook has multiple worksheets referencing different data from the other workbooks/worksheets. I originally had different named ranges (static) in each worksheet, to make things easier to...

Hi teamies. I have an interesting problem that I cant seem to find a solution to. I have two workbooks, lets call them BookA and BookB. BookA is left closed most of the time and is accessed through Sharepoint. BookB is updated several times a day (also accessed through sharepoint). BookB has...

Dear all I need a macro which will lookup a value from four different workbooks. The workbooks are placed in a share drive. So many people will be using the macro to lookup from the workbooks. So I will lookup for the above value in four wrok books. That is I will look up age from a workbook...