frustrated

  1. R

    Password Enabling Printing VBA (Specific Sheet)

    I am looking to LOCK the printing activity in the excel UNLESS the user has a password and specific worksheet. I am frustrated and need help. Please. Thank you very much for kindly advise, Rungravee.
  2. N

    Something Simple that I'm missing

    Trying to find if CustNumber exists in FinalNumber column. CustNumber Column has 150k rows, FinalNumber column has 350k rows. I have tried Match, Countif, Index, etc. There is clearly a match on the value of A2 (which is 0). It shows up like 8 or 9 times in FinalNumber Column. Do i have...
  3. K

    Conditional Formatting - copy across multiple rows/columns

    Hi there, I am trying to apply conditional formatting across a worksheet, based on this formula; =BC3<bc14">< BC14</bc14"> HOWEVER I have read multiple forums/blogs/posts about this and I can't seem to get the conditioning to apply across further rows/columns. I am not using absolute...
  4. K

    Conditional Formatting - copy across multiple rows/columns

    Hi there, I am trying to apply conditional formatting across a worksheet, based on this formula; =BC3<BC14 (turns cell green if the value is lower) HOWEVER I have read multiple forums/blogs/posts about this and I can't seem to get the conditioning to apply across further rows/columns. I am...
  5. V

    MACRO keeps falling out

    Hi, I am new to Macros. Have written this simple macro but it keeps falling out at the line in RED? any suggestions? Sub GlassMacro1() ' ' GlassMacro1 Macro ' Add Sheets & put them in order ' ' Sheets("Sheet1").Name = "Raw Data DB Viewer" Sheets("Sheet2").Name = "Working Data DB...
  6. N

    IF(C:C,B1,.... display column A:A) - so frustrated

    I've been so frustrated trying to find an answer. I'm trying to get the text in the corresponding cell in column A to display when column C matches the number in B1. I feel like there's something simple I'm overlooking. Any help (even condescending :biggrin:) would be much appreciated.
  7. A

    Freeze Panes Glitch / Issue

    Using Excel Office 365, I'm trying to freeze the top 4 rows on one tab. I select cell A5, go to View Tab, Window Grouping, Freeze Panes Pull Down, Freeze Panes. The result is that the top 4 rows indeed freeze, however, they are duplicated on the scrolling window below, and if I click in a...
  8. U

    Vlookup & IF formula - HELP!

    Hi, trying to work a formula to look up a value in a colum that has multiple entries of the vale based on the value of another column. My value is in cell A2 (value = 1234567). The value is shown in Sheet1 in column A along with responding data in columns B & C. My value however is duplicated...
  9. Y

    Looping through Values

    Hi so basically i need to loop through the values xo=-7 and xf = 5 For a graph there need to be 21 grid pts ie 21 values between -7 and 5 and i calculate dx to be .6ish Basically I just need help putting this into a loop using variables for the numbers so i can change the xo's and xf's etc.xo =...
  10. C

    Excel Freezing during Filling Cells

    Does anyone have a solution? I didn't change any code recently but this started to happen yesterday. My Macro goes about copying a number of tabs out of a master Spreadsheet and then pastes them into a new Spreadsheet and pastes special a lot of data using defined names. I would appreciate...
  11. C

    Too many nested Ifs

    Can anyone figure out a way to shorten the amount of ifs in this formula? I'm using excel 2003 and running into the nested if issue. It basically looks to see if the value in C is Positive, negative, or zero. If it is zero it checks to see if column R & S Are also zero if they are it prints N/A...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    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 ???
    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
    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
    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
    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
    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