counter

Hi, Consider the following table, it is an exam record for students. There is a name column at the start and then the Semester Check column and Semester 1 till Semester 6 columns. I want to Find the missing represented by null, The failures (any value < .4) and Want to display the failure...

Hi I have a counter with a minimum value of 17. As long as this value is not reached, then extra dates should be added to an array of dates. The extra dates should be workdays: if for example 2 extra dates are needed to reach the 17 value, but the 24th of December is not a workday, yet 23rd and...

Hey all, Im currently working on an excel project in which I use a counter. Right now I use following code to reset the counter to 0 everytime excel is opened. Private Sub UserForm_Initialize() counter = 0 End Sub I now noticed that this is actually not what I need. I would need the counter...

What I am trying to accomplish is increment my CONCATENATE formula by one. My issue however is that this is already located within a counter that applies the formula to every other row. I have tried to include detailed comments in my VBA code to follow what everything does. In short, in the...

Hello! There is value in a cell that shows a percentage - Lets say A1 = 5%. I want to enter a formula that starts counting the number of days when cell A1 changes to a value greater than 10%. Let's say on day 8, Cell A1= 9%, the counter should reset back to 0 days. Thanks and I really...

I have this code here that copies, and pastes from one sheet to another if the match is not found. However, I cant seem to get the row counter to reset to the top of the row. Once it is done looping through a row, it should reset to the second row (as the first row will be a header row)...

I am trying load Picking Sheets with data from another sheet. I cannot workout the syntax to access the data. Receiving Compile error - Syntax. how do I access the other sheet? Sub Macro4() ' ' Macro4 Macro ' ' Dim OrderCount As Integer For OrderCount = 0 To 600 ActiveCell.Offset(0...

Hi I'm working on a code to make a copy of my template for every day of the year. All goes well, apart from my counter not counting up to number the folders which are created for every month. This is my code: Function Create_Multiple_Workbooks() Application.ScreenUpdating = False...

Hi everyone. I am hoping someone can explain a solution for me in layman's terms please! I am not great with complex formulas. In my original sheet I have the following data as an example: This can be interpreted as Test Employee needs to attend 123 Example Street every Tuesday and Thursday...

Dear all, I'm using a macro just to suffle a sequence of numbers and then assign that to a button (attached), as follow: Sub Embaralha_seleção() Dim numm() numm = Range("A1:A100") ct = UBound(numm, 2) lt = UBound(numm, 1) ReDim dex(1 To lt * ct) n = 0 For h = 1 To...

Hello all, I have a spreadsheet that I fill out as customer requests come in - each request typically takes up 3 rows; the first row contains titles for each column (I know this is redundant, but it needs to be very clear for upper management as they sift through), the second row is details...

Hello. I am working on a workbook that uses random numbers that loops until a certain condition is met; a specific number. I am wanting to be able to count how many times the loop has to cycle until the number is calculated correctly. Essentially a counter of the cycles. Any help is appreciated.

hi, I am struggling to get an offset to work on a goal seek i am trying to do. Essentially i want to goal seek a value in row1, column1 to zero by changing the value of the cell in row 3, column 1. In the next round of calculations, ie when i apply the offset, I want to goalseek row1, column2 to...

I am trying to create a function that will count how many numbers are in a range on an excel sheet, and also between a min and a max number that are also on the excel sheet (Without using any excel formulas, Ex. countif). The range on the excel sheet also includes empty and non numeric texts...

I have this vba code but it returns ALL of the sheet names. But I want another-one that returns the sheets that start with the letter "D" and list them in column H58 on "switchboard". Sub WORKSHEETLIST() Dim ws As Worksheet Dim Counter As Integer Counter = 0 For Each ws In...

This seems ridiculously easy, but I cannot figure it out after many tries. Scenario: I have approx 35 columns (and rows of course) of data. I want to sequence through each column and delete any columns that meet a certain condition. Here's one of my many attempts that do not work. Example of...

i am working an excel file that i need the counter to stop after i enter date in another cell G4 has date entered: 5-apr-19 H4 is the due date formula: =WORKDAY(G4,9) I4 is counter: =TODAY()-H4 J4 is date completed: 9-apr-19 what i need is I4 to stop counting when J4 date is entered

Hi again, I got something I think is a big problem for me but I don't know what you think: I have a loop like For i = 1 To 100 ......... Next The loop is pointing to numbers in column B. However, all the numbers may not be present. For example, 2 or 54 etc, may not be available in the...

I am trying to delete columns if the header of the column is NOT a header containing the word "Transaction Status" and other headers, but when I run this (below) it doesn't delete columns based on these criteria. It deletes every column. Any help on what I'm doing wrong would be greatly...

Hello All, I want to convert the below Sub Procedure into a function that I can call into Excel sheet. Sub SplitTextIntoMultipleCells() Dim Counter As Long Dim WordArray() As Variant Dim WordList As Dictionary Dim dKey As Variant Set WordList = New Dictionary...