refer to worksheets

  1. C

    Reference File Name from Cell Value

    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
  2. T

    Inserting templates with ref. to destination workbook = #REF!

    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...
  3. 1

    Using in a Formula, Referring to Another Sheet, a Cell Reference Containing the Sheet Name, Instead of the Sheet Name Itself

    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...
  4. S

    Need Help Referencing 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...
  5. J

    Max Function Refer To 1st Cell in Row

    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...
  6. J

    Max Function Refer To 1st Cell in Row

    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...
  7. P

    formula for formatting

    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...
  8. A

    Macro to reference sheets

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top