sheet reference

  1. pi

    Pivot table with dynamic sheet (!) reference

    There is a well know solution to use dynamic ranges as source of a pivot table (name using offset). In my case I want to take it one step further. I want to put the name of a sheet into a cell and derive the source of the pivot table from that. Here is what I tried: 1: I have defined a name...
  2. S

    Add sheet reference in CELL() content

    Hello, I've been trying to insert a Sheet reference inside CELL() formula because I want to reffer to another Sheet, not in current Sheet, where I write given formula. Cell reference that is bold AH$1 and AH$19000 should refer to Sheet named "AAA". Right now I am getting #REF in every case I've...
  3. R

    VBA: Use Cell Value as Sheet reference to Hide/Unhide Sheets based on Cell Value

    Hi there, Hopefully the title is correctly describing what I need, but here I will elaborate. I will for example have the following worksheets: - Overview - Adam - John - Nick - Tess On the Overview sheet you will find the total of expenses per employee. The name in column A and the value in...
  4. C

    Excel drop list issues with tab reference updating by itself

    Hi, I have a data base that I setup to be able to create multiple other sheets and pull the same information from sheet to sheet. The issue I am having is that the formula for the data validation drop list keeps updating back to the current sheet that the drop list is in instead of keeping the...
  5. L

    Cell References Across Different Sheets

    I hope this isn't a duplicate question; to describe what I'm trying to do keeps getting so detailed that searches aren't very effective. Please feel free to point me in the right direction if this has already been asked and answered. I'm working with a book that has one sheet at the front...
  6. U

    change sheet reference but not cell reference

    Hello ~ Can someone assist in helping me with correct formula. 1. I have 12 sheets (Jan, Feb, Mar, etc...) 2. I have a master sheet to "recap" the 12 sheets. 3. I have the first formula to read " =JAN!E49 (which means I am pulling information from Jan sheet from cell E49) Now, I want to copy...
  7. David Kemp

    Named Range Formula without Sheet Reference

    Hi everyone, I have a named range that refers to a formula. By default the formula always creates a worksheet reference and even if I remove it, when saving the formula, it always creates a worksheet reference. Is it possible to get the formula in the named range to reference the active sheet...
  8. E

    Error 1004 After I added a new sheet?

    I added another sheet to my workbook and now my macro buttons are messed up, even though I am referring to the worksheet by sheet number. This is the problem function, it is supposed to pull a random percentage of the rows on the FromSheet, then copy them to a temporary hidden sheet, Sheet7...
  9. S

    Referencing Data in another sheet and sorting it

    I have a data set for organizing a group of papers. These papers are the same between two locations, but are not filed the same at each location. I have them set up so each location has its own spreadsheet and the rack/page location is noted for that particular location and sorted from there...
  10. A

    Display Sheet Reference in Cell

    I have a cell that is hyperlinked to a worksheet in the same workbook. I want to also display the the tab name in a cell. The tab name changes every week and I don't want to have to change it on both the tab and the cell that references it. I want to change the tab and then it will automatically...
  11. B

    relative worksheet reference using range copy

    Windows 7 Excel 2007 <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am trying to make to relative worksheet reference within a range of cells while doing a copy of a template worksheet. The copy below is working ok when running my “Results worksheet”...
  12. G

    Auto fill sheet reference in hyperlink formula

    Hello everyone. I am trying to auto-fill the sheet references(indicated in red) in the following equations <table border="0" cellpadding="0" cellspacing="0" width="540"><col style="width: 405pt;" width="540"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height...
  13. H

    capture cell info from different worksheets into a column of Summary Sheet

    I have created a few identical sheets, namely Invoice, Invoice (2), Invoice (3) and so on. Cell F5 of each invoice will be the invoice number (running number). After sheet Invoice (3), i have created another sheet namely Invoice Summary (on the right to Invoice (3)), which will have one of 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
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 "".
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