someone kindly help me in generating macro or VB code to select, copy & insert rows on a click of button, it should also update associated formulas with the addition of rows.
Basically its a date & time wise schedule, could range from 1st to 31st of any month & time wise it could be any half hour time.
secondly also need to convert date wise schedule into new sheet with pre determined format. therefore needs button, when clicked it insert rows and another button to subsequently convert data into new sheet in a different format. Rows to copy & insert are from A10 A40.
i have attached my file, with desired result and formatting. Also tried to explain with colors from where the values are to be copied; colors marked on both sheet are just for reference.
Bookmarks