View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
urlocaljeweler urlocaljeweler is offline
external usenet poster
 
Posts: 15
Default increase number in cell by one continuously...

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!