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! |
increase number in cell by one continuously...
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! -------------------- (Ms-Exl-Learner) -------------------- -------------------- (Ms-Exl-Learner) -------------------- "urlocaljeweler" wrote: 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! |
All times are GMT +1. The time now is 10:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com