excel

Hello everyone, Apologies English is not my first language and I am very new to writing VBA codes. So far, I have only copied and adapted parts of the codes to fit my needs. Recently, I have created a workbook, each tab has the name of a treatment site. Daily, I receive data about these...

I am working on a quote tracking program in excel and would like to streamline the quoting process. I have an office form my sales staff can fill in which populates an excel table for me to see the information. Within the table I have formulas to do many things and one is to compile a lot of the...

Hello, I am trying to copy values from Columns R, W, X and Z from the Template (red pic) into columns A, B, C, D. I need a VBA to go through these columns until there is a blank row and then paste it into A,B,C as so it creates a nice list going down. I will need this code to continue multiple...

I have to believe this has been solved before, but I could not find a previous post for my particular problem, so apologies if I missed a previous one. I'm trying to use SUMIF/SUMIFS or some variation of formula to look at two different columns of price amounts, determine for each row which of...

I have 2 workbooks. One is a Bill of materials (Bom) and the other is a master list (Ml). My bom takes the Ml as a connection, manipulates the data through power query and spits in on a new worksheet in the Bom workbook. I then open a new sheet (within the bom workbook) perform a vlookup and...

I have a worksheet table with 4 columns containing employee name and 4 columns for ID number for this employee simply and I need a formula to add the employee ID number which is next to the name if the cell match any cell of the employees names in the 4 columns ("B , D , F or H") for example as...

I have recorded a Macro to re-arrange my table with color and to sort row by date Ascending but later I needed to add 03 rules to remove all filters in the table to show all data then to go to the last row in table and to save the workbook but it seems that they need to be set in a professional...

Not sure if this is possible - but wanted to ask. Need to calculate a "Year-to-date" balance of a savings account while using the TODAY() function as the start date (so it dynamically changes). Ex: Total Goal Amt: 5000 End Date: Dec 2026 Total # of Months till completion: 24 (*calculated...

I piece together weekly reports for my team. I keep row heights at a minimum 75.00, 100 pixels and maximum 203.25, 271 pixels. To take a lot of time out of this task and make it automated, I would like to conditionally format (though probably not possible based on my research) or enter a code /...

Hi All, I'm looking for help on a formula reference using VLOOKUP. I have a table which maps some project names to Sheet names, as the project names are very lengthy but the Sheet names are small enough for the tabs in Excel. Using that table and VLOOKUP, I'm looking to use the output of the...

Hi, And again, i need help from some bright "excellers". This time, as per the attached screenshot, there is a table with 14 rows and 6 columns (A2:G17, A2 and A3 merged just to have the title "Name", then whole A4-A17 filled with names, B3-G3 filled with time slots). 14 rows corresponds to 14...

I am looking for a solution for my excel sheet and am not finding any on the internet. I have the following data for the dropdown list. I'd like my dropdown list to reflect Column B and the color from Column D according to Column C value that corresponds to the cell from Column B. I seem to not...

I'd be really grateful if some one could help me with this, I've been trying to work it out for a while but I'm not getting anywhere. I have a VBA to send an email based on individual rows and the data they contain. I'd like a way of sending individual emails to all recipients and the data on...

(Note: I have already posted this question in other groups but have not received any response) My goal is to close a file without being prompted to save after changing a shape, specifically the size of a button; to this end, after changing the button, I set Thisworkbook.saved to True but if I...

If I have query (1) with multiple steps and I need to have query (2) based on query (1). For performance and/or good practice is it better to: A) duplicate it and then modify and or remove the steps carried over to get what I need or B) is it better to reference it and then create steps to...

Greetings, I have an excel document that tracks items on a "to-do list", I have an active and historical tab. Active for anything that is still outstanding and the historical for anything that has been completed. I am running a code that will automatically transfer my active tasks to my...

Hi everyone. I'm currently building a new order form for work and I've been asked to have one of the tabs auto-concatenate certain information from three other tabs - to prevent the customer from overtyping and getting it wrong. So I have four tabs:- Product A, Product B, Product C and Control...

Hi, In cell R66 I am trying to return a blank cell if the J66 is also blank. I currently have the following formula: =IF(S66="No",J66,"Reference"&"_"&J66&Q66) In cell R66 I have "Reference" and would like this to be blank. Can anyone assist?

I have a few users who are reporting some type of "new" saving progress bar that comes up in Excel. It comes up in the middle of the screen, stays for maybe 30 or so seconds and goes away versus the normal saving progress which is at the bottom right in Excel. It does save the document but due...

Morning all (well, it is morning here). So I'm using O365 and I'm wondering if there is any way to have excel clear a cell (lets say D16) when you make ANY selection from a drop down box located in another cell? And continuing on from that, as well as clearing a cell so that it contains...