Adding data on condition in different Cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2329848%22%20slang%3D%22en-US%22%3EAdding%20data%20on%20condition%20in%20different%20Cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2329848%22%20slang%3D%22en-US%22%3EI%20have%20a%20text%20box%20and%20a%20command%20button%3CBR%20%2F%3EMy%20data%20to%20be%20fed%20are%20%2C%20Sl%20no%2C%20doc%20no%3CBR%20%2F%3ENow%20my%20data%20entry%20in%20sheet%20comes%20like%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20cell%20A%3A%20sl%20no%20comes%3CBR%20%2F%3EIn%20cell%20b%20%3A%20doc%20no%20(from%20text%20box)%3CBR%20%2F%3EA.%20B%3CBR%20%2F%3E1.%20Sl%20no%20Doc%20no%3CBR%20%2F%3E2.%201%20456%3CBR%20%2F%3E3.%202%20789%3CBR%20%2F%3E4%203.%20678.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20I%20need%20to%20get%20result%3CBR%20%2F%3EIf%20sl%20no%20is%20odd%20%2C%20then%20in%20cell%20A%20odd%20sl%20no%20and%20in%20Cell%20B%20corresponding%20text%20box%20entry.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20sl%20no%20is%20even%20%2C%20then%20sl%20in%20cell%20c%20and%20doc%20no%20from%20text%20box%20in%20cell%20D%3CBR%20%2F%3ELike%20this%3CBR%20%2F%3E%3CBR%20%2F%3EA.%20B.%20C.%20D%3CBR%20%2F%3E1.%20Sl%20no%20Doc%20no.%20Sl%20no.%20Doc%20no%3CBR%20%2F%3E2.%201.%20456.%202.%20789%3CBR%20%2F%3E3.%203.%20678.%204.%20457%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20will%20help%20saving%20of%20paper%20while%20printing%3CBR%20%2F%3EPlease%20advice%2C%20thank%20you%3CBR%20%2F%3EAjish%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2329848%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor
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
0 Replies