I have a workbook with 12 sheets named by month E.g (Jan24 – Feb24 etc..) in each sheet 30-31 pages with the month days. in column “E” I add daily tasks to be done but sometime this task date maybe in the future not today so in this case I add in coulmn “G” the task action date e.g “31-May” as you can see in the following screenshot

I am a beginner and I am trying to create an Excel Macro to do the following.

I am a beginner and I am trying to create an Excel Macro to do the following.

I’m not expert with vba codes and I have a workbook with 9 sheets have the same table design and I have got a vba code to copy the adjacent cell if the cell value equal any other cell in the range but it’s not working properly- my range is between columns “G:N” … in “G” I have “name” and in “H” I have the “phone number” and the same in the other coulmns as you can see in the screenshot

I’m not expert with vba codes and I have a workbook with 9 sheets have the same table design and I have got a vba code to copy the adjacent cell if the cell value equal any other cell in the range but it’s not working properly- my range is between columns “G:N” … in “G” I have “name” and in “H” I have the “phone number” and the same in the other coulmns as you can see in the screenshot

I am looking to simply copy all rows from Sheet1 to a protected Sheet2 every time the last column (let’s say G) is populated.