input items and write into a sheet then select some datas

I am new to this excel world. I use to write some items with its qty as per invoices made everyday in notebooks. i want to write the same in an excel sheet where i would like to input these details through input boxes or forms and later print some of the records as per a condition, say items which or not marked. once the items are selected and printed it should automatically marked for over / printed. This may seem complicated i hope there could be a solution. Please Help.

Originally Posted by arlu1201

This is possible. Why dont you attach a sample file with some dummy data?

Thank God! You have noticed. Usually we write datas under fields on the first row. which can be written using a userform. I want a code that would create fields every time i input new items and the datas under it. if the item as field exist it would write the datas under it.Like., items :-ivory 9.5 = 20 numbers, Ivory 10.5 = 30, white 7.0 = 50, white 9.5 = 20,white 10.5 = 30. If the itmes i write is already available it should be added/written under it else it should create a new field. Please find attachment.

Originally Posted by arlu1201

You have not included your userform in the file.

Will there be only 1 printed column for each row?

Thank you very much for helping me. I didn't mean to print tha records as it is.
I thought i should select only those records which are displaying "no" in the printed? colum
I want to select these records after it has been marked "no". once it was selected and added by a code i would use the totals. Every time i select the records marked no, after it has been used it should be marked for printed? "yes".Next time another set of records with mark "no" can be selected by the macro code.

I further want this datas input by a input box in code rather than creating a userform.everytime we input datas it should check for already available field. If it is there it should add datas under it. If not a new field should be created and work with the input box.

I am really feeling sorry for asking you something cumbersome. I hope still there is a possibility of your helping.

I have not created a userform. If you want i can create one but i am not fluent with them.

May God Bless you for your helping tendency.