Hey there.


New here and I'm a complete excel and vba newbie and getting completely overwhelmed by it

Im setting up a project plan template workbook for my team and i need a vba code that i can alter to achieve the following;

1.On inserting or deleting a new row/s in my gannt table the same row in inserted or deleted in my two other gannt tables for consistency and my workplan spreadsheet ( i have a daily, weekly, and monthly gannt spreadsheet as well as my workplan spreadsheet in the same workbook) so 4 spreadsheets in total for the purpose of this query. These are labelled as spreadsheets 10 ( all three gannts) and 12 ( the workplan) in the workbook

2.I have an iD column on all three gannt tables and the workplan which need to correspond to each other but the column numbers are broken up in the three gannt tables by 3 summaryrows summary rows of the section above and 2 header rows for the section below so 5 in total.
So generally i have a sequence of 10 numbers in column A starting at A25, followed by 5 header rows, then 10 numbers, then 5 header rows, then 10 numbers, and 5 header rows, then 10 numbers and 5 header rows etc

I need to be able to right click and insert or delete row/s and for the ID column to either increment by one, or more upon the row/rows insertion or reduce by one or more following a row/rows deletion and in both cases for the number sequence to update accordingly
In all three gannt spreadsheets the number sequence starts at the same Cell, that is cell A25. However to complicate matters the workplan spreadsheet ID columns begins at B9, and it doesnÃ�?*’Ã�*’¢Ã�?*’¢â€šÂ¬Ã�?*’¢â€žÂ¢t have the 5 rows breaking up the number sequence as in the three gannt tables. So however the sequence is changed on the gannt tables the B column starting at Cell B9 will need to be able to account for this and matain the number consistency without having 5 periodic blank rows as you go down column B.

3. In addition for ease i want a hyperlink in a column of my gannt tables so that for ease the user can go straight from the gannt table to that section of the work plan. So if i was looking at task line ID number 7 for example in my monthly gannt chart i could jump to task number 7 on the workplan spreadsheet and visa vera. So as well as the numbers incrementing and taking account of the breaks in the sequence i also need to increment the hyperlink on the three gantt tables and the workplan, or decrease the increment in the event of a row deletion on any of the 4 spreadsheets

4. FINALLY i also need the new row if inserted to take the formating of the row above it including data validation, formulas, and drop down boxes ( the excel boxes not the developer tab ones)
Any help would be greatly appreciated!

PS when i say im a newbie i REALLY am so would appreciate also knowing "where" the code needs to be placed. ie module, workbook, wookrsheet etc .I just want to be able to right click and insert or delete row/rows in the 4 spreadsheets mentioned to achieve the above