refer to worksheets

Hello All, I really need your help- i am willing to find out a way in which reference file name for vlookup is from cell O6 from each worksheet. =IF($C6="","",IFERROR(VLOOKUP($C6,'C:\Users\XYZ\Desktop\[Indirect(!$O$6).xls]DataSheet'!$B$14:$AB$488,9,FALSE),0)) please help me really appreciate it

I have made several report templates, each with different cells linking to a 'Project Data' source sheet. Within the templates themselves I haven't included the source sheet. So obviously: I end up with a lot of #REF! errors in this first step, though that isn't a problem by itself. I'm...

Hi there, Is anybody aware of an option to use e. g. in a vlookup a reference to a cell in the “source sheet” instead of the sheet name? I have quite some sheets w/ similar data sets – which I due to various reasons cannot combine in one sheet. E. g. in column A of the consolidation sheet...

I am trying to apply a code to my List sheet. In the workbook, I have a form that feeds data to a database (Past Inspections sheet). The List sheet pulls the latest record for each Inspection category from the Past Inspections sheet and is used as a dashboard to see when the next inspection is...

I am trying to create a formula that will display the 'name' from column A that corresponds with the row of the value resulting from Max function for range in column B. To illustrate the desired results: On 'sheet 1' I have the max function determine that cell B5 has the highest number for...

I am trying to create a formula that will display the 'name' from column A that corresponds with the row of the value resulting from Max function for range in column B. To illustrate the desired results: On 'sheet 1' I have the max function determine that cell B5 has the highest number for...

I have a spreadsheet (named Source) that has values, and would like it to display like this in the final spreadsheet: (XXX, XXX). I can't figure out how to get the final spreadsheet to preserve the decimal settings that have been set in the Source spreadsheet. Using this formula in the final...

Hi guys Ok I have a macro which names files based on the names of certain sheets: .SaveAs Filename:=ThisWorkbook.Path & "\" & ActiveWorkbook.Sheets.Item(10).name & "_to_" & ActiveWorkbook.Sheets.Item(1).name & ".xls" This works as expected, but how can I change the first part to reference the...