Thanks for the reply Dhamo. Actually i am totally ignorant agbout vb codes. Here is sample file link. can you plz write the codes for me?
http://www45.zippyshare.com/v/73075699/file.html
Hi there!
On sheet A, I have data in four column i.e Sr. NO, Names, Desigantion, Amount.
On sheet B, I have a pre-designed payment voucher. In cell C7 of sheet B, I have a dropdown list (using data validation) that show all the names mentioned in second column (Names) of Sheet A. I am using...
Exactly, the sheet B is a pre-designed form. As you said in the last para, i already have a list of employees on sheet A. Here is the link of my sample file.
http://www45.zippyshare.com/v/73075699/file.html
There is a drop down list in the cell C7. The dropdown list has following fileds/names.
Dave
Mike
Steve
Jhon
Blair
I clicked on drop down list and select the first name that is Dave. Now I want a button that automatically select the next name/second name from dropdown list and the next...
Actually on sheet B, i have a salary voucher. in cell C7, i have a dropdown list of names. In other cell i am using the index and match funtion, that extract the data from sheet A. As i change the name in cell c7 where the drop down list exist. The relvant amount of salary changed. I want to...
Hi there!
In cell C7 (of sheet B), I have adropdown list (using data validation) of names. (let say, Dave,Mike, Steve,Jhon ,Blair)The things I want to do with vbcodes are as under:-
Let suppose, I select the first name(i.e Dave) from drop. Now I want some codes that’ll automatically
select...