adding

In my spreadsheet in E1 is yesterday date in this style 31/07/2019 is there a way of adding to my macro a way to save as T/P5 August 2019/31.07.2019 Contact Finance

I created several formulas with slightly different cell references and realized I needed to add an additional conditional at the beginning of the formula. I wanted to do a find a nd replace, but adding the additional conditional at the beginning requires adding a close parentheses at the end...

I'm building a chart from 3 series of data. Mac Excel 16.16.12 The issues: Adding data series 1 is all ok and called "Series 1 "Point A"" on the chart. All category names on X-axis are correct. Adding series 2 is ok and called "Series 2 "Point B"" on the chart; however, "Series 1 "Point A""...

I am a newbie with Excel and could use help. I am trying to use a template for Ticket Tracking for our Non profit Theatre. Here is the template I am working on. https://1drv.ms/x/s!AvrJXpPq_XWokllNt6BaJTbrlgJI I would like to add 2 new prices under D3. Could anyone guide me on this? Thanks!

Hello, In the formula below how do i add IF 7% or lower make 0%? =IFERROR(VLOOKUP(B$1,OFFSET(INDEX($K$2:$K$900,MATCH($A2,$K$2:$K$900,0)),,,MATCH("*",INDEX($K$2:$K$900,1+MATCH($A2,$K$2:$K$900,0)):$K$900,0),2),2,0),"")

I have a spreadsheet with a drop down list. This drop down list may need to have new entries added. At the bottom of the list, I want another option added, "Add new organisation". When this option is selected, I want someway of adding a new organisation to the list of organisations. How would I...

I'm trying to add qty to Inventory (B5:G7) so that Supply meets Demand by first looking at the Storage with the lowest fruit count and adding the qty based on the lot size. Demand is manual input Supply is Sum(B5:B7), Sum(C5:C7)+B3 and on (cumulative) Total is Supply-Demand Storage table is...

Hello, I am working on a macro to create a chart. When I use the macro recorder and add in the chart data, it seems to use the fixed cell range but what I am actually doing is using ctrl + shift + down to select the entire range which will vary depending on the chart. How can I get excel to...

I am adding 4 columns, 3 of which have ABS totals. When I do =Sum( of the 4 columns I get correct sum but when I try to sort the 15 numbers from lowest to highest it does not put them in the correct order. The first column below is the total and this is after I sorted them. The first row of...

Hi all, As noted on earlier post this week, I'm just starting out with VBA. When I used the recorder to remove all border lines it spits this code below. Seems really long? I want to learn the smartest/most concise code I can from the get go so I don't start with bad habits...

Hello, any help would be greatly appreciated. I am trying to add together 5 days worth of time data to give a total. For example the data is (E10) 06:11, (E11) 09:29, (E12) 08:13, (E13) 08:52, (E14) 08:46 to total 41:31 and not 17:31

I have a column of minutes from goals scored 45' 5'67'89' 2'5'89' 15'67'79'78' is there a way of adding them all up please?

Hi all, I am trying to have column H total the points to date only if the name in Column A matches the row above it. I had created a macro to automatically sort Column A. But currently Column H is adding the row above even though the names do not match. Column H currently has this formula...

Just like the Title says.. I am trying to figure out how to add a WindowsMediaPlayer control to a form via code. I am not able to find the correct syntax for it. Apparently, it is not done the same way as adding MSForms controls such as labels, texboxes, commandbuttons, etc.. Has anyone seen...

Got a sheet with a list of inventory items on column "A". Every week I insert 5 new columns from C-G with information for that item such as how many were used, restocked, total items, price of item, and cost of restocking. I created a text box, that will help adding inventory to the sheet...

Hi, Formula needed as per below inputs Sheet 1 <colgroup><col><col></colgroup><tbody> A1 B1 From To 435190 435200 416401 416409 437932 437960 435328 435365 438001 438046 435254 435278 </tbody> Sheet 2 - in A1 should come output as per below <colgroup><col width="64"...

Hello, I have a formula but would like to add an if less than 0 show blank cell. How can I add this to this formula? ROUNDUP(((LEFT(C12,2)÷100×$A3)−C3)÷(1−(LEFT(C12,2)÷100)),0) Thanks.

Hi guys I have the following formula which fires when 2 values in a range are the same or less than 2: =IF(T5<>"","CL",IF($E$2="In",IF(AND(A5<>"",COUNTIF($F$5:$F$45,"<2")>=2,O5<=2),"B3",""))) I am trying to add additional criteria so it also fires when 3 values in a range are the same or less...

I have one of these on my worksheet but there is no code anywhere that would have AddItem'd it. I must have done it but I can't remember how. Tried adding another one as a test but I can't see where items would be added to it. What as I missing ?

Hi Good morning, please can you help me i have a macro to send an email and for the subject i want to add the text in the textbox2 into the subject heading i have done this in the code below but get an error please can you help? With NewMail .Subject = "Late Outage request - " &...