same worksheet

  1. M

    Repeat VBA Function for Separate Events in Same Worksheet

    Hi all, I am rather new to Visual Basic, but I am trying to duplicate a function that I have wherein if an amount in cell N165 is greater than 5000, then the two rows below the cell (in this case, rows 166 and 167) will become visible. I am trying to do this in multiple separate instances on...
  2. G

    Switching Between Graphs Occupying the Same Cells

    Hello, I'm creating some reports at work, and all the graphs I'm creating are taking up too much room on each sheet. I'm wondering if it's possible to make each graph the same size and lay them on top of each other, and use tabs to flick between them (similar to the tabs at the bottom of the...
  3. C

    query whether values in another tab\named range are contained in a cell

    Not sure it's even possible but would like to be able to accomplish this without the use of VBA or macros (end-user will not be able to maintain if I do). Within the same worksheet basically "query" a list of values in another tab to see if there are any matches. Reason: Specific text could...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    • Started by PabloFer
    • Replies: 32
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    • Started by Sleeplol
    • Replies: 24
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    • Started by johnsonk
    • Replies: 22
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    • Started by Dellboy
    • Replies: 25
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    • Started by ipbr21054
    • Replies: 22
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    • Started by Ramballah
    • Replies: 22
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top