hi,
i am using worksheet change event to add data auto when i input data in range F10:F300
I need here some changes
i want when i enter data (only numbers ) in range f10:f300
then
in range d10:d300 genrate number auto 1 to ....99999
in range h10:h300 genrate page number according to range f10:f300 1 to ....
in range i10:i300 genrate sum of range of range F10 to.....
sample added here for example
Capture.JPG
Bookmarks