darkstar71
New Member
- Joined
- Sep 3, 2002
- Messages
- 2
Hi,
First let me say I am a Excel Newbie , I use it for one function at work.Im hoping some kind soul here can save me some typing.
Heres what I have, I have a spread sheet with many columns and some of them have formulas already made by someone else, when I need to expand the sheet I take a section of 10 rows and copy and then paste at the end of the sheet. The 1st column in the spreadsheet is a incrementing number 1,2,3 ... and so on, what I have to do after I paste a bunch of sections of 10 is go through and change this number for each cell counting up.I've looked and looked for a function that would let me just specify a starting number and then it would automatically fill in the rest of the column from there. Can any kind soul help me automate this and please remember I'm a newbie
Thanks
This message was edited by darkstar71 on 2002-09-04 08:18
First let me say I am a Excel Newbie , I use it for one function at work.Im hoping some kind soul here can save me some typing.
Heres what I have, I have a spread sheet with many columns and some of them have formulas already made by someone else, when I need to expand the sheet I take a section of 10 rows and copy and then paste at the end of the sheet. The 1st column in the spreadsheet is a incrementing number 1,2,3 ... and so on, what I have to do after I paste a bunch of sections of 10 is go through and change this number for each cell counting up.I've looked and looked for a function that would let me just specify a starting number and then it would automatically fill in the rest of the column from there. Can any kind soul help me automate this and please remember I'm a newbie
Thanks
This message was edited by darkstar71 on 2002-09-04 08:18