I need excel macro or string. see below the details: find 01-04-71 and select 01-04-71 to 07-4-71 enter row and then cut paste to another column. see below after ********* I need like that output in excel. simply say column value cut to paste row 01-04-71 10.34 11.3 4.64 02-04-71 10.37 11.33 4.65 @@@ 1.14 10.09 0.51 05-04-71 10.37 11.33 4.67 06-04-71 10.39 11.36 4.7 07-04-71 10.42 11.39 4.7 01-04-71 24.5 25.25 6 02-04-71 24.5 25.25 6 @@@ 2.71 20.375 0.66 05-04-71 24.5 25.25 6 06-04-71 24.75 25.5 6 07-04-71 25 25.75 6 ********************** 01-04-71 10.34 11.3 4.64 01-04-71 24.5 25.25 6 02-04-71 10.37 11.33 4.65 02-04-71 24.5 25.25 6 @@@ 1.14 10.09 0.51 @@@ 2.71 20.375 0.66 05-04-71 10.37 11.33 4.67 05-04-71 24.5 25.25 6 06-04-71 10.39 11.36 4.7 06-04-71 24.75 25.5 6 07-04-71 10.42 11.39 4.7 07-04-71 25 25.75 6 If you reply any one my post. I would be very happy Thanks, Raj
It looks like you have two sets of lists. And with the first string in each list, you want to output data in the first set then data in the 2nd set corresponding to the leading string. My thought process is to outline the task and flesh out the action. 1) read data set 1 2) read data set 2 3) for each line in data set1 dstring1 = getstring1(dataset1) 'this function returns an array item1 = 1st string, item 2 = rest of line dstring2 = getstring1(dataset2) printline = dstring1(1)&" "dstring1(2)&" "&dstring2(2) next line I know this needs more work.
can we write macro without visual basic? I am non-tech, so I want simple command to use it.