Im new to VBA and im trying to write a code to skim through 2 columns. if value 1 from column A match with a value 2 from column B but is on a different row, it would copy from value 1 to the rest of the column A and move down to match with value 2 on Column B.

I’m trying to figure out the best way to handle this situation.
I have an excel spreadsheet I need to find duplicate numbers in column C and then concat the data in column AB in each of the cells in in AD.

I have over 300 sheets whose name needs to be changed as the first cell (A1).

See the following situation, I have a Workbook called “MÊS CORRENTE.xlsm” with the following values ​​in C3 and C4

I have hundreds of rows of time entered as “min.sec” (10.15) in column A. Column B converts these times into “min.% of min“. for example; 10.15 is being converted into 10.25. 8.30 would be converted into 8.50 etc. I need this conversion to happen in column B and cannot add any additional columns to the worksheet.

I am trying to insert this formula into a dynamic range, and I cannot get the last formula to enter as I keep getting a Data Mismatch error message. I think this is because I am getting lost in the quotation marks for all of the interior functions. Any advice on how to get this formula to post into the cells?

With the below screenshot, I am trying to figure out how I can concatenate all the emails associated with a company on one line. I have tried TEXTJOIN, but can’t figure out the logic to make this work. I am also open to any VBA solutions.

I am new to the group.