View Single Post
 
Old 04-06-2009, 08:23 AM
KramerJ KramerJ is offline Windows XP Office 2003
Novice
 
Join Date: Mar 2009
Location: Las Vegas, NV
Posts: 5
KramerJ is on a distinguished road
Default Sequentail Number Each Row Based On Another Column Entry

I have a worksheet that has five columns starting at row 17 and ending varing from row 178 to row 185. The first field is for the sequential number. The fourth column has a an entry up to the 178th or 185th row. Using VBA how can I seqentially insert a number from 1 to n based on the fourth field entry. Please help.
Reply With Quote