Vba for move data & clear entry screen for entry new data..

[santosh226001]

Friends i m working a excel sheet & i wanna a vba for my easy working..

I have 2 sheet in my excel work book
1 entry
2 items

in entry sheet we enter data & after run vba data move to item sheet & ... Entry space clear

my example sheet attach with this

where we show what i want

[arlu1201]

Do you mean that the data from Sheet1 should be copied to Item Sheet? Only data having "Yes" in the 1st column should be copied, then changed to No and then the remaining columns cleared?

[Jakobshavn]

If there is already data in the items sheet, do you want it over-written, or do you want the new data transferred to the bottom of the old data??

[santosh226001]

oh sorry i forgot to change sheet1 name to entry ......

in entry sheet that is example data.. that i want to move... every time move data.. add below last blank row

[santosh226001]

Do you mean that the data from Sheet1 should be copied to Item Sheet? Only data having "Yes" in the 1st column should be copied, then changed to No and then the remaining columns cleared?

yes i wanna same.. only yes in the 1st colunm shoud be copied.. then change to NO and then the remainging columns cleard.. but in category colum.. where i want predefiend data validation data...

[santosh226001]

Dear arul1201 Sir/Mam

i have given ans of ur query regarding create vba for my workbook... hope u understand what i want in a vba.

looking for ur +ve responce...

Thanks

[santosh226001]

Friends my problem still un solved..

If u ppl understand my problem then tell me is it possible through vba or not...

[santosh226001]

frnds i m still waiting responce to my thred.. for vba help..

[jaslake]

Hi santosh226001

This code is in the attached...let me know of issues.

Please Login or Register  to view this content.