Assign serial number for entry

**ebin charles** · 05-11-2010, 12:27 AM

Hey!

Sir, I am using excel for entering purchase data into it.
In this I need to assing a serial number to each entry. when i enter the data it should change as auto serial.

Can u help me sir?

Regards
Charles

**royUK** · 05-11-2010, 01:12 AM

I can't see where you would get the serial numbers from

**JBeaucaire** · 05-11-2010, 01:13 AM

Add serial numbers where? What is the starting serial number?

**ebin charles** · 05-11-2010, 01:31 AM

Sir,

I need to assing serial number for the entry in serial column. In the sheet Parts Data the
data are stored, in first column the serial number should assign.

The serial shall be in "serial" (first column).

Regards
Charles

**royUK** · 05-11-2010, 01:45 AM

How do you intend generating the serial number,what would make it

The Column referred to is headed Edit. Maybe

Please Login or Register  to view this content.

I also can't see why you are looping through a range to fill the comboboxes,there are more efficient ways

Also there's no need to add your workbook to each post unless it has changed

**ebin charles** · 05-11-2010, 02:11 AM

Sir,
When I run the serial is not auto. When i go for another entry it shows me empty and like normal entry.

Regards
Charles

**royUK** · 05-11-2010, 02:21 AM

Well adapt the code,it populates the new serial when the form is initialised,add the at part to your other code or call the initialisation event

**ebin charles** · 05-11-2010, 06:07 AM

The Serial number for the entry is assinged and the entry need to move according to the serial number.

example: if i give serial number for 2, then the 2nd entry need to come (If 2nd entry already entered). This is for correction of previous or next entry.

Regrds
Charles