copy data from one column to another on certain condition

[cds]

	a	b	c
1	batsman		runs
2	sunil		14
3	c kapil b salil
4	malcom		28
5	runout
6	peter		49
7	b steeve
8	sachin		35
9	c lily b steev
10	extra		4
11	total		130

<tbody>
</tbody>

Hi, I have data something like aboves

I want help to write vba for copying data in between batsman to extra. Here I want to copy a3 to b2, a5 to b4 & so on whenever c column is blank between batsman & extra . Please help me out


thanks in advance

 

[Peter_SSs]

If I want to add similar data from multiple sheet to One sheet . How Do I do it,

Remember that we are not familiar with your circumstances so we need details like ..
Where are the multiple sheets? Are they all in the same workbook as the first one?
- If so, is it every sheet in that workbook that needs to be 'treated'? If not, how do we work out which ones need this action and which ones don't?
- If not, how do we identify where the sheets are?

Also, how should the multiple results get arranged on the single result sheet? The sample I used ended up putting data in columns A:E starting at row 1 of the new sheet. Is that what happens for you or do I have may sample data not quite right? Where should the other score sheets go on the results sheet?

Also advise me any resources available to improve my excel skill.

MrExcel forum & lots of practice.

 

[cds]

Dear Peter_SSs thank you for reply reply and advise. All my sheets are in one workbook. first I will insert column in all worksheet and copy worksheetname or worksheet identifier in all sheets through VBA and run your code and copy selected rows to sheet called as summary sheet" at the end for further analysis can you help me out please .

 

[cds]

Further while copying I want add autonumber or sr number at the 2nd column.. first coulmn will remain as sheetname or sheet indentifier ie., match nos say 1,2,3,4 etc and result will start from 3rd column . thanks io advance

 

[Peter_SSs]

That still isn't clear to me. Can you show two of the raw data sheets and what the final result sheet would look like? To do so, please use one of the methods I suggested previously so that we can clearly identify what rows and columns the data (& results) are in. We cannot tell that information if you only post your data like in post #11 .