loop

hello, i have this one page simulating labor cost, net salary to the month, average net salary to the year, and etc. depending on gross salary for each employee. it is a useful page both for the employees and employer as it shows all deductions, taxes and etc. for every month. Don't need to...

I am trying to loop find tomorrows date in Column H in file "dummy.xls" and every time it finds that date; then copy all the data in that Row into file "final.xls".

How do I convert each row into a list without adding a new column? What I have so far: = Table.TransformColumns(TESTT, each Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv)([TESTT])) It gives error: Expression.Error: We cannot convert a value of type Function to type List. Details...

Hi, Community! I will really appreciate some help with a VBA code that I'm trying to create for my project. This is 1 step in a macro that i can`t figure out miself. Images attached. I need to loop search every cell in D column in J column and transpose data from a matching row in D Column...

I have this code and I am wanting to loop through all the sheets in my workbook. I want it to unhide all rows/columns, delete all comments and copy/paste the entire sheet as values, then proceed to the next sheet. Sub xCheck() Dim ws As Worksheet For Each ws In Worksheets...

Hello and thanks for reading. I have code that copies data and pastes to another worksheet on the next available row. I am trying to delete a dynamic number of rows from a worksheet if they exist. I can search for a value in column C and lets call that value "dekalb". If vendor name exists i...

Rather than have all my column names across the top of the worksheet, I'm looking to have them down the left hand side eg in Column A. The value of that will then be in Column B. I have used a recordset which loops through and pulls the first column correctly, but I need 30 more columns to do...

Hi, Code mentioned below has an issue to it. I have two columns ( A & B ) A contains unique IDs B contains values I'm using a macro with a loop to update the values in B column for respective IDs. However, the condition to stop the loop is not working. The null value condition is working...

I'm having a heck of a time figuring this one out and haven't found exactly what I'm looking for in the threads. Any help is very much appeciated! I am attempting to loop through the range("AN27:AP35") for each cell with the text "b" I want to copy it and paste it to the corresponding row in...

Hi I'm looping trough an array and want to increase the integer every iteration. In most languages I've used u could do something like var = 1 foreach x as x { action i++ } And it would add a 1 to the integer. I couldn't find a good alternative for VBA, I only managed to find some...

Script below: Dim rng As Range Set rng = Range("BJ5:BJ500") Sheets("Daily Runboard").Activate For Each cell In rng If cell.Value = "MCC" Then cell.Select ActiveCell.Offset(0, -59).Select ActiveCell.Resize(11, 22).Copy Sheets("H Runs").Select...

Hey, I bring another problem to you people. I have some VBA code to check the last row of a certain table and create a checkbox in that row, if there are none. Problem is, if a row is created in the midle of the table, no checkbox is created in this row, because it is only looking for the...

Exercise 12: Find a student Open the workbook "Résultats examen.xlsx". In the first spreadsheet (Results) you have a list of students. 1) Build a VBA macro that asks the user with a dialog box, the name of the student to find. This macro will browse the list and select the cell corresponding to...

Hi, I need some help adding a loop to an existing code and can't figure it out. Newbie here. Current: I have a single cell (a9), that has hundreds of results. Each result has a carriage return after it. I need each result to be split out having their own row. The current code basically does a...

Hi there, i need a hand to help me with a simple VBA code, i got my sheet1 here ABC1DateTeamName205/10/2022ALupin322/10/2022AFox405/10/2022BRuby522/10/2022BSusan605/10/2022BGarland705/10/2022AAnthony and here is sheet 2, i simply want to list their name in sheet2 here which matched their date...

I have started to use VBA and I have the following problem. I want to calculate the variance of the 6th and 9th row. Then, 6th and 12th row (yellow). The loop should then calculate the 7th and 10th and 7th and 13th row (beige) Finally, the loop should then calculate the 8th and 11th row, 8th...

Hi, I'm trying to create a macro that will replace all the "1"s in a column with a value in Range "A1", then move onto column 2 and replace it with the value in Range "B1" and so on. this is what I have so far Sub Macro2() ' ' Macro2 Macro Dim X As Integer X = InputBox("What column...

Hello - I have a need to consolidate data from two worksheets in 2,700 workbooks into two worksheets in 1 big workbook. I have a piece of code that works well enough, but after a varying number of loops it crashes excel altogether. Sometimes it may make it through 10 files, others it may get...

Hello! I have a workbook which has up to 280 worksheets in it. I need to pull the data from one cell into a consolidated worksheet (named WIP in the attached file). I have the formula for the index and match: =INDEX(Sheet1!$P$1:$P$387,MATCH($G$1,Sheet1!$H$1:$H$387,0),1). I need a VBA which...

Hello all, I've written a transformation to look up a column header in a table and return the number of hours corresponding to that value. The original value in the cell is then divided by this number. The amount of header columns and their names can vary depending on the workbook so it doesn't...