changing

Hello- New to VB scripting. Here's what I'm trying do. 1) Prevent the user from saving the spreadsheet, unless the value within a column range is either "YES" or "NO". I'm providing the user with a default value on each of the cells that they must change. If the user tries to save the...

Hi I've got an IF statement that i) checks if the value of a cell in another sheet is blank - if it is, then it returns nothing ii) returns the value of that cell if it is not blank. =IF('Tab1'!$S5="","",'Tab1'!$S5) However, the formula keeps changing every time a macro, which...

I have a Time Clock Excel spreadsheet that I wrote so employees can click an icon button to record their times as they clock in and out by via an Excel macro. At the end of the pay period the store manage needs to print the payroll sheet and he is not computer savvy at all, therefore I wrote a...

I've got a macro that saves a file to a local folder. Worked flawlessly in XP. Now they've moved us to Win10 and it doesn't work. The file was going to the C:\Windows\Temp\filename Folder, which we no longer have permission to access. So, I tried changing the path to...

I'm trying to have a table where if you enter a letter in one cell it will give a number in a different cell. So if A1=A then B2=1, if A1=B then B2=2. I've written a formula in colum B something like this: =If(A1="A",1,(if(A1="b",2,if(A1="c" etc...... I have about 20-40 different codes to go...

i have a file written by another program, but changing the file's extension to zip, i could view the contents of the file. Is it now possible to extract a specific content from that file without changing the extension using vba? Actually the content i want to extract is a picture file and i want...

Hi guys, Im looking for a sub goalseek that involves a loop making U8:U207 = 0 by changing the values in b2:q12 thank you

Hi, Is there a way to modify the way Excel sorts cells? This "A to Z" or "Z to A" algorithm is faulty as hell and apparently hasn't been updated since the dawn of time. It constantly sorts words in many languages in a horribly wrong order. Is it possible to create custom sorting routines...

Hello I have what I think will be a very simple question. How do i drag a cell to copy into other cells without the number changing? example: I type 20 into a1, i want to drag it to copy 20 into the next few boxes but instead it is changing the cells by 1 each time. i have one spread sheet that...

Hi, I have an issue with CTRL+SHIFT+ARROW, excel selects the column/row content, by it doesn't change the view to the top/end of the selection (eg: if I want to select all column A and I have 312 down rows, CTRL+SHIFT+BOTTOM ARROW selects all 321 rows, but my view remains where I started my...

I have spent several hours searching the internet for a solution to no avail. I have an external reference (Daily Exchange Rate) that updates daily. I have a column with a daily date in each row for the entire year. I wish to make the cell next to "today's" date in that column reflect today's...

When I create an Inputbox in the top left hand corner of the box is displayed Microsoft Excel. Is there any way to change that, remove it, hide it? Can't seem to locate anything about this. Thanks

Good Morning All I have a datasheet that looks at health interventions in an organisation. A data feed I receive populates the datasheet with the dates on which these interventions happen and I calculate the next due date of the intervention for an individual - nothing complicated, quite...

Hi, In my tool I had to implement an idirect function with linked objects in order to get the image to be called depending on the cell value. It s dynamically changing depending on the product configuration. In order to do that I’ve created a library/master table with tye images exactly fitting...

Hello - I calculate the difference between the last cell in a column and the first cell in a column. The first cell in the column is an absolute value ($A$1), but the last cell in the column changes daily and the last cell changes daily. For example, today the calculation is A25-$A$1, but...

Is there a way of changing the GMC range automatically for the formula below? =DMIN('CEA - ALL'!$A$1:$O$1172,15,GMC!A1:A2) When this is copied to the row below it updates to A2:A3 but I want it to change to A3:A4, A5:A6 etc Is this possible?

Hello all, I'm new to the site and this is my first post, hopefully someone can assist. I have a workbook that has about 50 pivot tables that have their source in a table in the same workbook. I would like to change the data source to an external workbook that is located on my teams SharePoint...

Hi Experts! I am trying to formulate the best way to create conditional formatting rules to be able to highlight the whole row based on the words found in column G. Basically, column G contains all the status of the processing of the macro. It is consist of a sentence or two. I want the rule to...

I am attempting to change military time to standard time but am having issues when the time starts with a 0, for example 0327 is changing to 8:07 AM rather than 3:27 AM. Here is the current formula I have used, =TIMEVALUE(LEFT(G2,2)&":"&MID(G2,3,2)&":"&RIGHT(G2,2)). Any thoughts on how to...

So, simple I can't figure it out. 1. I have a Cell A1 and if I type a value in it say 4 enter, 6 enter, 98 enter 2. The value is copied to another sheet C1 increment down a row on value changed and timestamped. 3. Essentially so I can see when the value changes and what time. Now the problem...