I Have an excel file containing following data : -
SCS/0185/11-12
SCS/0186/11-12
SCS/0187/11-12
SCS/0278/12-13
SCS is the company name, 0185 = Unique no and 11-12 is the Financial year. Daily basis entry is to be posted for making despatch instructions to stores dept. For a new entry, entire row is to be pasted fresh and correct the srl nos. Every year around 400 nos sales order is prepared. Pls suggest any command / function to enter the complete data without changing the sr no manually. When I tried to insert the row before the column, for autonumbering/Fill Series, it shows cannot shift objects offsheet.
VDS
SCS/0185/11-12
SCS/0186/11-12
SCS/0187/11-12
SCS/0278/12-13
SCS is the company name, 0185 = Unique no and 11-12 is the Financial year. Daily basis entry is to be posted for making despatch instructions to stores dept. For a new entry, entire row is to be pasted fresh and correct the srl nos. Every year around 400 nos sales order is prepared. Pls suggest any command / function to enter the complete data without changing the sr no manually. When I tried to insert the row before the column, for autonumbering/Fill Series, it shows cannot shift objects offsheet.
VDS