Need macro to insert rows & convert sequence of records into new sheet

[tabkaz]

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.

[tabkaz]

Bump no response

Please someone kindly help me in generating macro to copy & insert rows on a click of button,,, also need to convert occurrence of data into new sheet with pre determined format. Need button to insert rows and subsequently convert data into new sheet in a different format. Rows to insert is A10 A40.

Sheet contains various formulas associated from data sheet, so addition of rows should update formulas accordingly.

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.

[tabkaz]

Bump No response

[FDibbins]

I have pushed this to the other experts for you

[tabkaz]

Many thanks

[humdingaling]

Please Login or Register  to view this content.

the basics of the extraction

the code itself isnt optimised just a roughie to get the extraction out
formatting will need to be tuned

[tabkaz]

Thanks humdingaling for looking into problem it & helping me with the solution.

i am able to extract data as required but there is 2 issues i have figured, firstly the occurrence of values in date column are not being considered;
for example if 2 is mentioned on may 2 at 9:00 AM, data extraction showing it only single time. Also if code cell is blank macro does not proceed further to extract remaining data.

[humdingaling]

the occurrence of values in date column are not being considered

sorry didnt understand that was part of the request
ill just need to tweak the code in order for this to happen

if code cell is blank macro does not proceed further to extract remaining data

this was not shown in your example

[humdingaling]

see attached version 2
commented all i could...there are a number of variables to keep track of...
in hindsight i should of named them better but i didn't know i would be requiring so many variables

Please Login or Register  to view this content.

[tabkaz]

its awesome .... Thanks for your help..
now its exactly doing what i was trying to do and best thing its super fast...in couple of seconds it can convert 1000s of record.

FDibbins really appreciate your effort in solving this thread. Many Thanks

[humdingaling]

glad to hear its working as you want it

thanks for the rep
cheers
Hum

[FDibbins]

tabkaz, Im glad I was able to assist, thanks for the feedback