add

Hello, I am working with different tools based on workbooks at work. Now I don't want to write/update the code, which is over some workbooks the same, again and again in every tool. The solution should be to write this tool, which is exactly the same in every tool, in an add in, and connect...

Hi I am Struggling to solve this! I need to calculate time between two dates, but need to be only between 8:00 AM and 5:00 PM, excluding weekends. I got some results, but when the start time is over 5:00 pm still add the time... example below: Start End Transmission time (h:mm) 28/09/2019...

Hi, I have a worksheet called POSTAGE. There are customers names in column B Current range at present is B10:B979 I would like some help with a basic code where any customer that doesnt have a number after there name then the code would add 001 So TOM JONES would then become TOM JONES 001...

Hi I am trying to add time but it does not work. Please see the excel file in the link. in cell P = SUM(C15:O15) But it is giving me 0 I tried to format to [h]:mm but did not help. Not sure what else I could have done. I also multiple the SUM(C15:O15) * 24 but still 0:00:00 shown?! I am...

Hello, I have searched for an answer but I am probably asking the wrong question. What I am looking to do is a create a cell that will start with a value of zero and every Thursday it adds a 2 to the number already there. I'm sure it's possible but I can't seem to find anything. I thank you in...

Hello, I hope someone can help; I'm sure this is fairly straightforward but I'm not that far along the VBA learning curve so please forgive me if this seems like a stupid question. I have an Excel pivot table. I need to use VBA to add certain calculations to the far right of it (the...

From this post: The OP's question was this: Why does the lookup range start with "1/"? What does it do? All I can think is that it really is meant to be a reciprocal, because the OP wants the previous non-blank cell - ? I experimented with removing "1/" and got an #N/A error. Also, if...

I have this formula <d2,"in darkness",="" if(h8="D2,"Under" light",="" if(and(h8=""><f2),"under light",="" if(h8=""><d2,"in darkness",if(h8="D2,"Under" light",if(and(h8=""><f2),"under light",if(h8=""> <d2,"in darkness",if(h8="D2,"Under" light",if(and(h8=""><f2),"under light",if(h8=""><d2,"in...

Hi guys, I'm trying to merge about 3k text files into a single excel sheet. Now this is easy enough to do with power query or even some VBA I've seen, but I also need to add a column with the file name as each file represents a different day's information. I can't seem to find a way to add...

Hi everyone, I have a shape on a worksheet that when clicked opens a userform to add data, what i would like to do is add to my exsisting code so that when the shape is clicked it not only opens the userform it also scroll the worksheet to the next empty row. Below is my code to call the...

Hello, I have a userform and looking for a way to add a popup calendar to insert a date in a textbox, I searched google and found the way below, I followed it step by step, but it didn't work, https://chandoo.org/wp/pop-up-calendar-excel-vba/ Do you have any way to activate it? I have...

Hi guys, I forgot in the process to add data from power query to the data model, now when I have a lot of formulas referring to this table, I cannot change it as it throws error on all those formulas. Is there way to pause the evaluation? I remember I saw it somewhere but I don't know where...

I have this textbox that I want it to hold this kind of text format: "12345678" or "ABC/1234/12" Now these are the conditions I want to validate: 1. If I start with a number, then accept only numbers and stop registering any key stroke when the length of the textbox reaches 8 characters 2...

Hi, i have a range of sales starting in column Q2 and I need to add a formula that will add a value based on the range of the sale. Say Q3 has a sale value of 43.00 I would want this to return Group A because its within the 0-50 range of sales for first column. The complete list would be...

Title sums it up pretty much. I'm not seeing how to upload a sample file here but maybe this is simple enough. Suppose I have a column of data, numbers, that I add rows to daily in a table and I want a cell above the table to display the last value in the column. We'll say this is all in...

I have the following formula that works: =IFERROR(IF(AND(D5="Y",E5="Y"),C5*$G$2,0),"") I need to add an additional piece that says to look at a cell in B5 and if it says INACTIVE then multiple C5 with G1, otherwise I want it to do the original formula posted above. I have not successfully...

I have a small script that logs when a user opens an excel file. Currently the username and date/time are populated in the txt file. I would like to add filename to the txt file, but not sure how. Thanks Private Sub Workbook_Open() On Error GoTo errhandler: Open "D:\Reports-Service\Old...

Good Morning, I have an extensive data set. Within the data set, one column has date and one column has time (both formatted as such). On another page/tab, I have a series of dsum formulas that add various columns from the data set. One of those formulas is below. I used to use the formula to...

Good Morning, I have a current formula that I'm trying to modify. The below formula looks up and is supposed to add all numbers in a data set that meet between the dates specified in the two cells. However, I'd like to tweak this. Currently, in the data set, the Date is one column and the Time...

Hi, I have a code for listbox with textboxes. how can I format the box to $ currency by adding this line of code to each box that has dollar amount, I would like to add this line of code: " & Format(Range("E").Value, "$#,##0.00;($#,##0.00)") to this code: (Bold and red colour) Private Sub...