sheet reference

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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”...
  10. 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...
  11. 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...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top