Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to number all pages in all the worksheets continuously from 1. | Excel Discussion (Misc queries) | |||
Number in cell increase with increase in font size. | Excel Discussion (Misc queries) | |||
How do I continuously number pages for the entire workbook? | Excel Discussion (Misc queries) | |||
I need to increase a number which is held in a cell by 1 | New Users to Excel | |||
how to increase the number by 1 from the cell above? | Excel Worksheet Functions |