complete

I have a number of queries in a workbook that are giving an error of 'download did not complete' It is not giving me any more info or any clues on how to fix the error. I have multiple sheets pulling from the same tables, and this is the only one with the error, so I'm not sure where to start...

Hi Folks I can't figure this out at all. :mad: I have a table of data. They are all formula links to various other sheets. Once each row has been checked the last column in the row has the text 'complete' typed into it. I then select the row and copy/paste values to remove the formulas. It...

Hello, I found this VBA that auto sorts a Multiple Column Groups Separately. ____________________________________________ Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then...

Ultimately what I am attempting to achieve is the following action: (based on the Selection made in the cells of Column M & N on Sheet 1): (NOTE: Cells "M" and "N" have a drop-down: Blank, YES, or NO) 1) On Sheet 1: If...

Hello, I have a spreadsheet with two tabs and a table in each. The first tab contains data that is added to on a regular basis, say column D is called "Complete", what i want is if a a row in the first tab has a "Y" entered in the complete column then that row is moved from the first tab to the...

this occurs when copying and pasting from one worksheet to another worksheet (impossible for me to confirm but I strongly believe the sheet being copied from was created in 2003 Version and is being pasted into file created in 2010 Version - if that matters. Also integrated with a database...

Hi all, I have a userform with a group of 9 text boxes that I would like to check. If the user has left them all blank or filled them all, they should be able to click "OK" and complete the form. If the user has only filled in 1-8 of the textboxes, I'd like a message box to display telling...

Hi I am new here and to VBA and am looking to make some cells in my spreadsheet mandatory if another cell is completed, If column B is complete then there must be something in C,E,F and this would be for rows 1:17 Thanks in advance Sharon

Hey guys, I need to automate a process in my excel sheet and I am not even sure what terminology to search for in order to find what I need. I have a tasks list that I share with various people on my team. There are a few recurring tasks that happen on a regular basis. Right now, I have to go...

Hi - I have a large dataset where i'm looking at applications going through various stages of testing and the machine name on which they live. What I want to do is to create a rule that highlights the machine in Green when everything is complete. For example Machine Name---App Name---App Status...

Hello, I'm trying to create a checklist. There is a drop down menu on one end of the checklist that allows you to choose "C" to mark a particular item complete. I want the spread sheet to log the time each individual checklist item is complete. Currently I have in the cell that needs to show...

hi I was hoping that someone could help with a countifs formula I am having problem with. I need to count how many times a bus takes more than 17 minutes to complete a circuit of a specific route on a specific day. My data is organised like this. <tbody> A J Date Length of time...

Hi I use below to save my work after I run all my vba, but I need to add something to this if I can. Right now it save file name and time as you can see SaveName ="LCP Complete File" & Format(Now, "HH.MM.SS") . but I need to add the date of the ending period that's on active sheet I'm saving...

Is it possible to to assign a button to complete 1 loop then a second click would perform the the next part of the loop?

Hi all, I'm using an excel file which selects 5 names out of a pool of 50 names. The sheet is such that if 5 names are selected randomly, next time 5 names will be chosen from remaining 45 names. This goes on till 1 cycle is complete. However, in the next cycle which will be iteration 11, I...

Hello all, I have 3 columns with YES NO in first 2 columns and status in the 3rd. I'm using COUNTIF yes in both first 2 columns but I want to ignore the row if the status is 'Out of Scope' OR 'Complete' =COUNTIF('B. General' !$E:$F, "yes") <tbody> E F G Answer 1 Answer 2 Status YES NO...

Hi, Is there a possible formula for this? I have been going throug SUMIF's and SUMPRODUCTS but both seem to be for a positive criteria. I am trying to get a formula that would basically be: If Column C is not equal to "Complete" then Add columd D = AB + Column E =CD Thanks

Hi All, I have a spread sheet (excel 2016) that has 2000 rows of data (not consecutive). Column Z has the following formula to create the text for a hyperlink: =IF(U2="Vetted","\\SERVERS.XXXXXXX.COM\SHARE\SHARE\RRR\GRAPHICS\QQQ"&G2&".pdf","") Column U is used to state the information in the...

Thanks to shg, I'm now able to estimate how much time a sub has left before it's complete. However, when I put this function within a loop, I'd like to test if the % complete (dPctComp) is a multiple of 10% (so that the function doesn't produce an output with every loop, only at each 10%...

Hello, I need to build a master order list from a master list. I have included two files. The original "Master List" and the output I need it to accomplish "Master List Complete". The original "Master List" will contain a unknown amount of rows when complied. I need the sheet names to be...