forloop

Hi all, I received a file that I need to reformat to upload to a database. The current file is setup where one row represents one client, with twelve values for financial projections for each month of next year. I need this formatted with the same attributes, except i need one row for each...

Hi all, For each cell in column B, I want to count how many cells in that column have the same value. If there is only one cell in the column with that value, change the Cell.Value to Cell.Value & "a", if there are two cells in the column with that value, change the Cell.Value to Cell.Value &...

Hi All, I am trying to write a simple If statement inside a loop which applies to all rows which have a value in Column A. The if statement just needs to check if each cell in Column H is empty and if so paste the value from the same row in Column K. This needs to repeat for every row which...

I have been playing with INDEX Match and Vlookup, however am struggling to solve my problem, I normally end up using 10+ multiple column filters to reach my results. Made an example below where I input 3 variables and wish to find a Row which matches all the criteria, in the example the results...

Hello, I am writing a code that has a For loop so that it will check rows 8 to 40 in column 18 of worksheet"DFM Example ". If a question has a red or yellow status there will be a value of 2 or 3 in column column 18. If there is a 2 or 3 in column 18 then it will select an empty cell in...

Hello Excel users, i am trying to create a macro where i can repeat rows based on from and to date columns. So is there any way using for loop which can get the below desired output in csv by using macro? INPUT from excel sheet <tbody> From To Product Growth 19-09-2018 25-09-2018 A 2%...

Hi there, I have this code which is meant to add two "account totals", each account total is located in two different departments. The macro is then to display the sum of those two "account total" in the row of "grand total" in ColumnD:H. The numbers start in the "Account total" ROW are located...

This is my first post on mrexcel, I have read the FAQ and posting guidelines, but I apologize if make some beginner mistakes. I am writing a macro to add the value of a cell from one workbook, to the total of a cell on another workbook, based on whether two date values are equal. Here is my...

Hello, how would I go about to modifying this code so that it will calculate the total of all the account totals? The code below is below is supposed to look for account totals in each department in each sheet and if that department has more than 1 account total the macro will give it a "grand...

Hello, I have this code which should read all rows that begin with the word ACCOUNT#: which is followed by numbers like this: 1-026-31-00000-3342. The whole this looks like this ACCOUNT#: 1-026-31-00000-3342. If the code reads some row and there is another row identical to the row read in the...

Hi, I have the following macro which I'm using to find a value that is in my ControlSheet in cell B11, in column M of the Datasheet, and then it deletes the row. It also copies the row to the RecordsRemoved tab before completing the macro. My requirements have changed and now i need this...