How to fill a database with variable numbers

benny0414

New Member
Joined
Feb 14, 2018
Messages
7
I have database where I need to make 3 million codes so dragging the bottom right of each cell is not practical--but doing it all at once or filling messes up the formula and numbers for example I have attached the image
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
pub
 
Upvote 0
white preblack presuffixwhite numberblack numbermerged numbersGbarcodei
6076081607000000000000001608000000000000001607000000000000001 [FONT=&quot]EBJIMAAHBEFFEFFEFFEFFEFFEFFFEF<wbr>CBFGIAH[/FONT]000000000000001
6076082607000000000000002608000000000000002607000000000000002 [FONT=&quot]EBJIMAAHBEFFEFFEFFEFFEFFEFFFFE<wbr>BFIGIAH[/FONT]000000000000002
6076083607000000000000003608000000000000003607000000000000003 [FONT=&quot]EBJIMAAHBEFFEFFEFFEFFEFFEFFBBG<wbr>IEIGIAH[/FONT]000000000000003
6076084607000000000000004608000000000000004607000000000000004 [FONT=&quot]EBJIMAAHBEFFEFFEFFEFFEFFEFFBCF<wbr>GEEGIAH[/FONT]000000000000004
6076085607000000000000005608000000000000005607000000000000005 [FONT=&quot]EBJIMAAHBEFFEFFEFFEFFEFFEFFCBF<wbr>GCAGIAH[/FONT]000000000000005
6076086607000000000000006608000000000000006607000000000000006 [FONT=&quot]EBJIMAAHBEFFEFFEFFEFFEFFEFFBFC<wbr>GAIGIAH[/FONT]000000000000006
6076087607000000000000007608000000000000007607000000000000007 [FONT=&quot]EBJIMAAHBEFFEFFEFFEFFEFFEFFBGB<wbr>KEAGIAH[/FONT]000000000000007
6076088607000000000000008608000000000000008607000000000000008 [FONT=&quot]EBJIMAAHBEFFEFFEFFEFFEFFEFFCFB<wbr>DBEGIAH[/FONT]000000000000008
6076089607000000000000009608000000000000009607000000000000009 [FONT=&quot]EBJIMAAHBEFFEFFEFFEFFEFFEFFFBC<wbr>MIAGIAH[/FONT]000000000000009
60760810607000000000000010608000000000000010607000000000000010 [FONT=&quot]EBJIMAAHBEFFEFFEFFEFFEFFEFFFCB<wbr>MBBGIAH[/FONT]000000000000010
60760811607000000000000011608000000000000011607000000000000011 [FONT=&quot]EBJIMAAHBEFFEFFEFFEFFEFFEFFGBB<wbr>AMCGIAH[/FONT]000000000000011
60760812607000000000000012608000000000000012607000000000000012 [FONT=&quot]EBJIMAAHBEFFEFFEFFEFFEFFEFFAFJ<wbr>FEFGIAH[/FONT]000000000000012
60760813607000000000000013608000000000000013607000000000000013 [FONT=&quot]EBJIMAAHBEFFEFFEFFEFFEFFEFFBEJ<wbr>FCBGIAH[/FONT]000000000000013

<tbody>
</tbody>
cleardot.gif

 
Upvote 0

Forum statistics

Threads
1,214,621
Messages
6,120,563
Members
448,972
Latest member
Shantanu2024

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top