expected

Hi all, how can I achieve that, where in col. “B” exists the number “1” and in col. “B” is blank should place zero “0” in col. “C”, using VBA code. Please see below original data and expected result. Thank you all in advance Original data <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings>...

Hello, I am looking for some help with writing a formula that places a fixed value into a cell every N columns. The formula I am using is below. When I try each part of the formula individually it returns the expected results, but I must be missing something because when I put everything...

Sub sbVBS_To_Delete_Specific_Multiple_Columns()...

I ran into a little oddity that turned out to be a disagreement between the Round and FormatNumber functions These results are from the Immediate window in a UDF that is interrupted at a breakpoint. The variable Value is defined as double. Its current value is the result of 5-6 calculations...

Hi, I am trying to attach the following into an existing macro: I keep getting an error highlighting the 001 section of this. "Compile Error. Expected: end of Statement" Where have I gone wrong? Thanks

Hi there, I need to create a spreadsheet for recording defects so that depending on the defect classification - Sev 1, Sev 2, Sev 3, Sev 4 - then an 'Expected Response Date/Time' and 'Expected Fix Date/Time' can be automatically calculated based on 'Assigned Date/Time'. The Response and Fix...

Hi all, I would like to use a VBA code so that to “SUM” the rows from col. “B” to “N” if the left 7 characters in col. “A” are same. I present below the original data and expected result. Thank you all in advance Original data <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings>...

I am currently utilizing the below table format. What I am trying to do is total the dollar value in column D for a specific Customer, column G, for each month. The problem I am having is that I want to go by column N, the ship date, but, there isn't always a date in N as it may not of shipped...

All hi, i would like to create a VBA code so that to run through col. "H" and where find a cell which contains the below break text, should make it to one line. Therefore that the break text is in same cell. In my below extract the "H" is the col. and "12" is the row. I present below the...

I'm looking for someone to help me with the below VBA. With one Pivot table on the code the macro runs perfect, but when I add a second table to the code I get a "Expected End With" error: Sub TestPivot2() 'TestPivot Macro Dim dt As String dt = Sheets("Calendar...

Hi all I have a spreadsheet where I have a sales forecast by both annual and quarterly breakdowns. Where I have a start date quoted, unless it is at the start of the quarter, I don't get an accurate figure in the Q1/2/3/4 columns. Example - Correct result (manually obtained) Part A - Agreed...

Assume I have the value of 1 in cell A1, 2 in B1, 3 in C1, 4 in A2, 5 in B2 and 6 in C2. This is my code: Dim Rng As Range Set Rng = Range("A1:C1") If I type: Debug.Print Rng(1) I get a value of 3, as expected. However, why is it when I type: Debug.Print Rng(4) I get...

Hi all, kindly advice me for a VBA code so that to run through col. “A” and where find the below duplicate descriptions should replace the first 2 as unique placing specific words on right side “operation” & “administration” and the 3th should be deleted. Below I present the original data and...

Hi all, kindly advise me so that to create a VBA code which should run through col. “E” and clear the specific word “Account:” but no other number or description. Therefore, that the code should run from “E2”. Below I present the original data and the expected result. Thanking you in advance...

Can someone help I have the below problem. The first column is the PO, each PO contains a SKU or multiple SKU's There is also columns for expected and received qty's . At the end is a % against the SKU . What I want to do is just to have what the % is based on the PO and if there is a line with...

For some reason, all code (i.e., onchange, worksheet_activate, worksheet_deactivate) behind my tabs are not executing automatically. I know that they run, bc, I can step in them to execute them. Also all of my other code runs as expected. Could there actually be a setting that is preventing...

I am trying to use a cell that is already defined as a percentage and converting it to a decimal instead of adding another column of cells for a vlookup calculation: k2:k21 are defined as xx.x% in column 11. I am trying the following with any result: =IFERROR(VLOOKUP($A$3,'Company...

I have this formula: =IF(AND(B1="HERE",LEFT(D3,7)="STC|A2:"),C3="HERE","") It didn't return the expected result of C3 = "HERE" so I evaluated it. For some reason these two parts of the formula evaluate to TRUE: AND(B1="HERE",LEFT(D3,7)="STC|A2:") but overall the formula evaluates to false...

Gentlemen, I am running this code via task scheduler, and the workbook is closed when it runs. At the end of the process, it gives me the following error; however, all the expected processes are perfect. I have also run the macro manually, and it works as expected. I suspect the VBS code has...

Simply said I need to create a project budget. I want mybudget to be linked to an input sheet where I update the total expected andwhat percentage is expected to be paid in what year and it’s automaticallyallocated to the budget output sheet. So this is what the input sheet should look like...