I have a text box and a command button
My data to be fed are , Sl no, doc no
Now my data entry in sheet comes like
In cell A: sl no comes
In cell b : doc no (from text box)
A. B
1. Sl no Doc no
2. 1 456
3. 2 789
4 3. 678.
If I need to get result
If sl no is odd , then in cell A odd sl no and in Cell B corresponding text box entry.
If sl no is even , then sl in cell c and doc no from text box in cell D
Like this
A. B. C. D
1. Sl no Doc no. Sl no. Doc no
2. 1. 456. 2. 789
3. 3. 678. 4. 457
This will help saving of paper while printing
Please advice, thank you
Ajish
