existing

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

I need to add a new blank column to the right of an existing column based on the value in row 3 of the existing column. As in if C3=Outside Vendor add a column (will become column D) but if its anything else don't do anything. Ideally if I could copy format from the existing column it would be...

I have a spreadsheet with 3 columns; A:product, B:price, C:date where from time to time I update the prices and I type in the date the price changed in the last column. I want to automate the date stamping. However, I only want the date to be updated when the value in column B (price) is...

I have the below existing formula that I need to now add a second section to tell it to match to values in a different workbook and am not sure how to structure the formula. Existing formula =SUMIFS($U6:$BU6,$U$2:$B$2,">="&$D6,$U$2:$BU2,"<="&$E6) New formula =SUMIFS(MATCH $C2, NEW WORKSHEET...

Whenever I open an existing workbook two additional blank workbooks open that are titled "PERSONEL.xlsb" OR when I open a new workbook two blank workbooks open with the same titles as above. What is going on? Help

I am creating a workbook for six managers. Every time a manager passes a training course, they receive 2 points. Supposed John Smith has 4 points in cell B3 and he passes another training course, I need to add a 2 to his existing total, giving him 6. Also, if he missed a course, we subtract 1...

I have a workbook with multiple worksheets and there are formulas throughout. I am now trying to create another formula which is a simple divide of cell C3 by cell E3 (both are formula driven) and I get a 0 (zero) return. I have tried inserting a new worksheet, no help. I have tried inserting...

How can i change the name of an existing ComboBox? I tried .. and it worked .. but not anymore... and the debugger does not work here neither... ActiveSheet.Shapes.Range(Array("ComboBox1")).Select With Selection .LinkedCell = "E" & r + 2 .ListFillRange = Range("H" & r +...

Hi all :) I can't get my VLookup function to work how I need it to. I have two worksheets (BSCQC and TMQC) and they each have a table (Table1 and Table 2, respectively). When someone entered a Call ID into the Call ID textbox (named CallID1) on the form, I need it to check that call ID isn't...

Hello all I have an issue that I hope someone can help with In Column "U" I have existing Data which is "Won" and "Outstanding" In column "V" I have a drop down list but at the moment the data is blank How can I have it that if I select data in column "V" that column "U" would then change to...

Hi, I am working on an existing vba script - the shapes are currently uniform & the existing script is as follows: Select Case sRAG Case "R", "Red" Selection.ShapeRange.ShapeStyle = msoShapeStylePreset38 Selection.ShapeRange.Fill.ForeColor.RGB = RGB(255, 0, 0)...

I have a page that is subtotaled by day (with a Grand Total). I want to be able to add more days, subtotal and refresh existing grand total. How do I add more data to existing subtotals without removing, adding and resubtotaling? I am sure this is going to be a "Doh" moment but I cannot...

Hello, all! This is likely a remedial question, but I just can't seem to figure it out. I would simply like to have a custom column / formula on my pivot which is a percentage of one column divided by the sum of the others. This would be in addition to the existing columns. The other columns...

Hi there, I am relatively new to Power BI and am finding my way round the fundementals. I have imported my data directly from excel and set-up some visuals and all working fine. I have realised that I need to add a column of data from the same original source but I didn't think i need it so I...

Hello all, Please help me with this. I have tried many vba and tutorials on youtube but with no any luck. I wanna add dynamic excel filter search box to existing exel tables. Can you please help with any tips?

Hi, Is there a way to add in an existing VBA code a new macro but from record macro function?+ And if so, how? Thanks in advance:)

I am using the below average if formula to determine average employee performance rating. I am trying to get rid of the #DIV/0! from cells where data has yet to be populated, as I want to set this up to be used in the following years and indicate an overall average. =AVERAGEIF(B4:E4,"<>0")...

I have this formula in column K: =IF(AND(H6>=1000,J6<=10%),"Yes","No") Now I want to add a further condition. If the word "None" appears in column E, Column K should return "No". In any other condition in column E, column K should return "Yes". Please would some kind expert edit the formula...

Hi, I am looking at the following page: https://simeneide.github.io/recommendations/2017/05/27/CFexcel.html and I want to understand how to add more movies and more users to this existing spreadsheet. The goal is to make my own version of this spreadsheet with Microsoft Excel. All suggestions...

Hi, Is it possible to call userform from another workbook? I don't want to use the existing file as I don't want people from seeing the other workbook which includes confidential info. But I just want the userform from that existing be available for them when maybe run a macro from another...