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

Watch MrExcel Video

This Week's Hot Topics

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
Top