frustrated

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.

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

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

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

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

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.

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

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

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

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

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