give

I've created a spreadsheet which has a lot of protected cells, spread all of the sheets. Now that it's finished, I want the cells hidden also (yes I know it would have been easy to do it as I went). Can one of you brainy people please give me a piece of VBA code, that will find, lock and hide...

Just recently upgraded to Excel 2016. I've noticed that when I open up a new instance of Excel, the default Book# file name will be sequential compared to it using the lowest book# based on what is already open For example when if I have no open Excel files and I open up a new instance, it...

I would like a formula (or VBA Code) in Cell "A1" of sheet 1 that would give me the cursor value (column A) of sheet 2 . In other words: If the cursor were in Cell "C10" of sheet 2, then Cell "A1" of sheet 1 give me value of cell A10 of sheet 2 Any ideas. Many Thanks

Hi I tried to find the sum() of the last column (please see the link below) but got 0. I tried subtotal() but it give me 0 too. I tried to change the format of the cells in the column from custom to general but again the same result 0. Why is that? Any help would be very much appreciated. Thank...

<colgroup><col width="70" span="2" style="width:53pt"> </colgroup><tbody> 1 9 2 9.2 3 8.3 4 8.3 5 8.8 6 10 7 10.7 8 8 9 9.1 10 10.3 11 9.9 12 8.5 1 10 2 8.6 3 9.1 4 8.3...

I have the following code in one of my macros strFilename = Range("E2").Value OutPut = MsgBox("Choose the path where to save your file", vbOKOnly, "Select Folder") With Application.FileDialog(msoFileDialogFolderPicker) .Title = "Select a Folder"...

Hello guys, it's 4am where i am and i have been working on this project for 8 hours. I cannot find the simple solution on google. I basically have an array of cells that are not in a column or row (cannot organize them either as the file is quite large) that contain numbers and i need to know...

Hi I have this bit of code Sub find() rngY = ActiveCell.Value Sheets("StkFile").Select Columns("A:F").Select Selection.find(What:=rngY, After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False...

Working on IF logic . Does if take in range like (200-500) then x I tried writing this formula =IF(J2=(50-200), "SMB", IF(J2=(200-500),"MID MARKET", IF(J2=(5000-10000),"SME", "Large Enterprise"))) But it did not give me the required answer which was supposed to be "SMB" Any pointers?

Hi All, Im hoping you could help me with a formula that gives me the right % based on these scenarios I have columns that have data like this Planned Attended Unplanned Attended 11-Jun 12-Jun 13-Jun 14-Jun 15-Jun 16-Jun 17-Jun 18-Jun 19-Jun 20-Jun 21-Jun 22-Jun 23-Jun 1 1 1 1...

I am wondering how I can go about using VBA to compare new entries in one file to an existing file? I have a ticketing system that I manipulate the raw data to give me a usable file. Rather than take everything from the new file, I just want to copy over the differences (newly added tickets).

I'm trying to combine two IF formula's and seem to be on the struggle bus this morning because I can't get it to work right. Each formula works independently, but I can't figure out how to put them into one formula. Can anyone assist? [=IF(OR(AND(CSV!AA3>0,CSV!AA3<71),CSV!AA3>121),"WJ"," ")]...

The following expressions of per cent change are mathematically equivalent: x/y - 1 and (x-y)/y However, they give slightly different results in excel, which complicates figure checking. Does anyone know which is preferable? i_excel

Hi everyone, I´m new here and I hope someone can help me. English is not my native language but I have seen a question similar to mine that was posted in 2010. So, I'll give it a try, and if I make mistakes please forgive me :pray: I am trying to generate a travel calculating formula for...

I wanted to see if there is a way to create a button in excel. When clicked on it will give an outcome based on an average. For instance, if in a cell I had the average of a batter in baseball. Would I be able to create a formula to calculate if an at bat results in a hit or an out when a button...

Hi! Value of range: A1=1 A2=2 A3=4 A4=5 A5=7 A6=6 A7=3 I want to know if value of range A1:A7 is simultaneous? I mean if the value is 1,2,3,4,5,6,7. In case above, cell A3 should be 3, and the macro must give a msg box "The cells are not in simultaneous". Tanks for help.

Dear, Using excel, I want to create data base that can train my employees to give alternative products to clients....in other words, if my employee wants to sell a blue pen and he didn't find it in store, the database will help him to give alternative options to sell instead with picture to...

Hello, I am using HTML code within VBA to create the text within the Macro-generated emails. Using Font Size 2 in HTML will give me a font size of 10 in my email. Using Font Size 3 in HTML will give me a font size of 12 in my email. Is there any way of over-riding this method, as I need to...

Hi guys, I am having a problem! Does anyone know how to make a VBA code that can copy one file (.pdf) multiple times (250+) and give it a name from a list that I have previously made? Thank you.

Is there a way to remove the first character of the cell contents? i.e. If the cell contains L1, it would give you only the 1, or if it contains E4.0 it would give you the 4.0? Would MID accomplish this?