How To Set auto Printing in excle sheet

[promits89]

Hi!
I want to print some data in selected range one by one according to serial no automatically. for example see following....

sl no. -------- name-------amount------code-------age------- income

1 ----------- Amit Roy -------34-------- 25---------41--------200000
2---------Promit Roy--------- 200 ------- 21 ---------25 -------150000
3 ----------Chris Gayle---------500--------35---------41-------- 250000

type sl no. ............

Now my question is that when i will type sl no 1 in the type sl no sell then it will auto print entire first row without sl. no. and when i will type 2 then will print 2nd entire row without sl no 2 and so on. how can i do this in office 2007.

And i will be glad if there is any way that will print above sheet one by one when i type print sl no 1 to 3 and it will automatically print entire data in sl no 1 and then 2 and then 3 etc.

[kvsrinivasamurthy]

If the cell address is O3 for entering Sl No the Worksheet_Change event can be used.
It will print that row only.

If cell is different make the change in the code given below.

Please Login or Register  to view this content.