changing

I could really use some help with this. Is there a way to change KM to MPH on this 2010 Excel spreadsheet adding 2 additional columns and some formula...Really stuck https://drive.google.com/open?id=1cGZLjwaY_N3abteQCJ7nHMUFzFdbyeiy HELP

My excel invoice number SW-BAN/DN/18-19/1557 and running is only last 4 digits (1557), can anybody help to given macro code changing that 4digits

When you open a spreadsheet the top is always shows the columns as A, B, C, D... and the rows are always number 1,2,3,4.. When I click in a column the "Letters" and changing to numbers. I have never seen Excel do this. What's is happening to my spreadsheet??? It happened right after I ran...

When I type 5,2 or 5.2 it keeps changing me it into a date. What's the problem?

Hi all, hope you can help... I have a cell that has a list of locations to select from. Once selected, in the cell next to it i need for it to again have a drop down list of equipment that is in the location selected. I have created tables with these lists in already in a different sheet. i've...

Greetings everyone, I'm trying to populate ListBox1 on my user form with the information in columns A and B from different sheets. For this I have a ComboBox1 containing the names of all sheets in the workbook. For instance, my ComboBox loads "Sheet1", "Sheet2", etc. I want to, upon changing...

How would one go about designing an excel sheet that calculates interest like a bank's savings account, meaning balances that change from day to day and interest rates that change during the year? Preferably, the interest rates would come from a table.

I tried to do it hear but only one table is changing while the other table is not !! can anyone look at this and help me

A given table: <tbody> A B C D E F 1 H 1 2 H 3 H 4 H </tbody> Depending on a value I do want to change the values in col-1, 2, 3 or 4. Lets say: A1, A2, A3 & A4 contains the formula: IF($F$1=1;"H";"") B1, B2, B3 & B4 contains the formula: IF($F$1=2;"R";"") By...

Hello, I have goal seek-ish problem. Think the regular goal seek function: Set cell A1 To value x By changing cell B1 What I want to do is based on the same principle how with one additional arguement, see below: Set cell A1 To value x and minimize cell C1 By changing cell B1 Is this...

Hi Guys, Can anyone help with the formula I would need to use to have cell C1 show the words "Level 5" in the attached example? Column B shows a number of 'points' and Cell B1 is a changing value, if B1 was showing a figure above 10,000 but below 25,000 then cell C1 should show 'Level 2'...

Hello folks, Is there a way to Break links (changing links to values) while keeping the rest of the formula? Example: Before: =[File1.xlsm]Sheet1!A1 * B1 = 5 * 1,01 = 5.05 After: =5 * B1 = 5 * 1,01 = 5.05 My objective is that I might want to change cell B1 afterwards. Thanks you for your...

I'm having trouble in changing my macro to autofill. It is a table and could be 1-5000 lines. This is what I originally recorded on my macro - Selection.AutoFill Destination:=Range("F2:F1511") Range("F2:F1511").Select I tried changing it to : Selection.AutoFill...

Hi I have been researching this for a while but still can't seem to get my head around this. I have an excel sheet that does the following: <tbody> A B C D E F G H I 1 P1 + P2 P1 P2 2 70 20 50 3 139 70 69 4 139 50 89 5 </tbody> P1 and P2 have a...

Hi, I am analyzing someone else's code. One thing I notice is that they alternate between run("some_macro") and call some_macro Why is there a difference in the way the macro is called & does this make any difference? I personally don't like changing the way it is called, I would prefer...

Hey all, I'm trying to take text in one column and have it spit out a barcode in a second column. Doing some searching, I've realized this might just be a font issue. Am I right, and where can I get the font (preferably free) to install on a Mac? Is there a formula for changing fonts in a...

The standard washed out grey color of an Access Form - or any Windows form - leaves a lot to be desired. Is there a way of programmatically changing the colour within VBA. I can't see anywhere in Access Options to change it? TIA

I'm having an issue getting the worksheet ref to change to the next sheet automatically as I copy them to the next row. Table 10 is my sheet name. Followed by 11,12,....229. Using formula: =if(B$4="",if((or('table 10'!$B9="comment",'table 10'!$B9=""),"",B$2&" / "&'table 10'!$B9),"")

<tbody> row column A column B column C column D 1 1 Emad1 700 600 2 2 Emad2 600 700 3 3 Emad3 250 0 </tbody> column c has a formula and also column D and they Constantly changing I want msgbox if d1 <= C1 msgbox show title = alert - msgbox= Emad1 (the text in B1) for one time and if D1...

Hi Everyone, Could you please help me changing of selected font color inside a cell. Selection of words/ characters is depends on the user wants to color. Ex, "John Peter" i wanted to color only "er" which is at the end "Dave Smith is a corporate trainer" color only "a corporate" Kind Regards, RN