Thanks MARC, very much appreciated. Excellent work
But since I am new to VB, what was wrong in my approach and if you could explain your method line by line.
Thanks once again
I have this file where in column A the data are clubbed w.r.t to other columns.
I need to split the value in a Column A on each cell rows into multiple rows by inserting rows and copy the remaining column data B onwards.
I have started with this code below but now I am lost. Can you please help...
Hi everyone..
I have a problem for which I seek your help.
I have daily reporting format given by construction and these contains comibination of qty and activity. One such e.g is below.
Concrete pouring (2.84m3) in say cell A1 and..
concrete pouring for 1 part (3.4m3)
concrete pouring for...