Thread: Fill Numbers between two colums

it is separation and listing of articles via a reference number

attaching a file for your reference

there top gray color is place where i add my area name.
down i enter the reference number via a barcode scanner

i enter the first number and the last number ...
i want it to fill number between them

please help me

Originally Posted by zbor

It's protected sheet with password.

password is 1

i need not make any changes in protected sheet

i type
CS-1000 in a2
CS-1100 in a2

i want it to fill automatically like

CS-1000 in a2
CS-1001 in a3
CS-1002 in a4......
.......
.......
CS-1100 in a101

i may be a or b column

please help me ... waiting for you reply online

yaa exactly

but i am scanning data via barcode scanner

as soon as i do it it gone.....

Originally Posted by sailesh9630

yaa exactly

but i am scanning data via barcode scanner

as soon as i do it it gone.....

attaching you file

Originally Posted by sailesh9630

attaching you file

may be this format

i enter in sheet 1

data imported in sheet 2

Originally Posted by Haseeb A

Hello,

See the attached, if this helps.

thank you for your help........
but the first 2 digits always changes..........
may be CS or CR or something like that

and in data extraction it is showing count on top that should be eliminated...

Originally Posted by zbor

Maybe this:

thank you guys finally found a solution...

with your formulas and slight changes according to me.. work done successfully..


thank you