increase number in cell by one continuously...

  • Thread starter Thread starter urlocaljeweler
  • Start date Start date
U

urlocaljeweler

I am using Excel 2007...

I have a column with rows such as follows;

store.murpheythejeweler.com/store/p/7055-Tungsten-Flat-8mm-Polished-Band.aspx
store.murpheythejeweler.com/store/p/7056-Tungsten-Flat-8mm-Polished-Band.aspx
store.murpheythejeweler.com/store/p/7057-Tungsten-Flat-8mm-Polished-Band.aspx
store.murpheythejeweler.com/store/p/7058-Tungsten-Flat-8mm-Polished-Band.aspx
store.murpheythejeweler.com/store/p/7059-Tungsten-Flat-8mm-Polished-Band.aspx
store.murpheythejeweler.com/store/p/7060-Tungsten-Flat-8mm-Polished-Band.aspx
store.murpheythejeweler.com/store/p/7061-Tungsten-Flat-8mm-Polished-Band.aspx
store.murpheythejeweler.com/store/p/7062-Tungsten-Flat-8mm-Polished-Band.aspx

I need to copy and paste this into new cells but I need the numbers to add to
one another so I do not have to manually go in and add one number to each
paste.

For example-- I have this;
store.murpheythejeweler.com/store/p/7062-Tungsten-Flat-8mm-Polished-Band.aspx

Now I need to copy and paste 100 more of that with a change to all of
the 100 pastes to have one more number than the previous paste; (7062, 7063,
7064, 7065, 7066, 7067 etc...

Any help is much appreciated!
 
Just copy and paste the below formula in any of the cell

="store.murpheythejeweler.com/store/p/"&7062+ROW(A1)&"-Tungsten-Flat-8mm-Polished-Band.aspx"

Now place the cursor on the pasted cell and drag it for the remaining cells.

Or

Copy that cell and paste it for the remaining cells.

If this post helps, Click Yes!
 
Back
Top