Ghayyasg said:
Salam Dosto,
Mujhay ek aur help darker hai agar koi dost help kar skay to please,
Attached file me 2 sheets hain jin pe work karna hai,
Sheet number two me mujhay yeh function chaheye k mera text cursor sirf 3 cells me move karay jo k mai ne yellow kar diye hain, aur aik cell se next cell me enter press karne se jaye ya tab press karne se, magar jese hi last cell jo k weight ka hai, us me mai value put kar k enter ya tab job hi key ap set kar dain press akroon to cursor wapis item name me aa jaye, aur jo aik item ki detail mai ne darj ki the uski ek list neechay generate hoti rahay, aur seriel number bhi auto generate hotay rahain, jab mai tmama entries complete kar loon to jo details neechay list me aa chukay hain, unki same detail sheet 1 me bhi aa jaye aur print sample sheet 1 jessa ho, sheet 1 me jo function darkar hai wo yeh hai k sheet 1 me sirf utnay hi serial numbers generate hon jitney items enter kiye gaye hain, aur us se neechay jo blank cells hon wo print nahon, yeh kaam agar excel seet me ho jaye to bahut behter, agar es me mumkin na ho to please access me isi qism ka database bna kar day diya jaye,
Jahan Print likha hai wahan print ki command bhi chaheye
Ek aur baat, gate pass number, agar gate pass number bhi auto method e chalay to kia hi baat hai, yeh number daily bases per bhi ho saktay hain, yani sirf aaj ke prints cunt kar k generate hon gate pass k numbers…
File attach kar raha hoon. AP sab k reply ka intezar rahay ga.
Bookmarks