LinkBack URL
About LinkBacks
I want to insert a row and keep the numbering in column D sequencially, so no row number will be skipped.
Please see attached. Both "before" and "after" worksheets.
I want to insert a row and keep the numbering in column D sequencially, so no row number will be skipped.
Please see attached. Both "before" and "after" worksheets.
Hi
try this in D2 and copy down
=ROW(D1)+1
Hope to helps you.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
You really just need this in D1, then copied down:
=ROW()
@FOTIS: I don't think yours works, if you use that and insert a row, the numbers don't adjust properly.
Last edited by JBeaucaire; 01-18-2012 at 07:44 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
You could use =ROW(A1)
However, the formula may not be copied automatically into the new row.
The good news is that all the other rows would be numbered correctly.
If you made that data area a table, the formulae would be copied into new rows ... just a thought.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
@TMShucks... I don't think so, insert a row after using that, notice the rows move down without correcting? You have to leave the cell reference out to get it to work using this method.
@JB, With all due respect
No one of our solutions, gives this: " the numbers don't adjust properly"..@FOTIS: I don't think yours works, if you use that and insert a row, the numbers don't adjust properly.
Hi & thanks.
Is there anyway to make the numbering go down the column automatically without putting a new formula in the blank cell when I insert a row? I know this works in a table, but is there anyway without a table? I'm assuming a macro is the only way?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks