Automatically populate values into 2 columns

[pbabu2404]

Hi All,

am quite new to VBA program so kindly help me with macro which should populate given values into particular columns till end of the sheet/work book.

input and output excel files are as follows here for your understanding purpose.

9th row name </SPAN>	class</SPAN>	date
Rose</SPAN>
Nally</SPAN>
Vanny</SPAN>
a</SPAN>
b</SPAN>
c</SPAN>
d</SPAN>
b</SPAN>
e</SPAN>
f</SPAN>
g</SPAN>
h</SPAN>
j </SPAN> NAME</SPAN> class</SPAN> date</SPAN> Rose</SPAN> 1234</SPAN> 01/09/2014</SPAN> Nally</SPAN> 1234</SPAN> 01/09/2014</SPAN> Vanny</SPAN> 1234</SPAN> 01/09/2014</SPAN> a</SPAN> 1234</SPAN> 01/09/2014</SPAN> b</SPAN> 1234</SPAN> 01/09/2014</SPAN> c</SPAN> 1234</SPAN> 01/09/2014</SPAN> d</SPAN> 1234</SPAN> 01/09/2014</SPAN> b</SPAN> 1234</SPAN> 01/09/2014</SPAN> e</SPAN> 1234</SPAN> 01/09/2014</SPAN> f</SPAN> 1234</SPAN> 01/09/2014</SPAN> g</SPAN> 1234</SPAN> 01/09/2014</SPAN> h</SPAN> 1234</SPAN> 01/09/2014</SPAN> j</SPAN> 1234</SPAN> 01/09/2014</SPAN> <TBODY> </TBODY><COLGROUP><COL><COL><COL></COLGROUP>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>

 

[oldbrewer]

it is not clear what you want as all 13 people are in class 1234 date = 1/9/14

 

[pbabu2404]

it is not clear what you want as all 13 people are in class 1234 date = 1/9/14

Oops sorry for the below example.
I wanted to print two values (1234,01/09/2014) under 2nd and 3rd columns in the complete excel sheet where ever it finds the first column data as mentioned in the second table below.
Hope this clear to you !

 

[oldbrewer]

so to be clear, if you enter Rose you want class and date to be populated automatically ? (from the data in your table which is presumably every pupil)