Microsoft Office Forums Sequentail Number Each Row Based On Another Column Entry
 Register FAQ Search Today's Posts Mark Forums Read

#1
04-06-2009, 08:23 AM
 KramerJ Windows XP Office 2003 Novice Join Date: Mar 2009 Location: Las Vegas, NV Posts: 5
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.
#2
04-12-2009, 11:35 AM
 Bird_FAT Office 2007 Expert Join Date: Apr 2009 Location: South East Posts: 271

Quote:
 Originally Posted by KramerJ 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.

I don't know about the rest of us on here, but you've lost me completely!!

Could you upload an example Workbook, and annotate it with what you want it to be able to do - then we may be able to understand better!

Hoping to be able to help,
#3
05-07-2009, 02:02 PM
 KramerJ Windows XP Office 2003 Novice Join Date: Mar 2009 Location: Las Vegas, NV Posts: 5

Sorry for the confusion. I have received a solution. Column 1 will have a sequential number starting from 1 to 178 or to 185 based on a value in column 5. Example:
Column 5 has a value of XYX for rows 1 to 178. Column 5 row 179 now has a value of ZOZ for rows 179 to .... and starting with new sequential number series again starting with 1 and so on.
#4
05-07-2009, 11:35 PM
 Bird_FAT Office 2007 Expert Join Date: Apr 2009 Location: South East Posts: 271

Quote:
 Originally Posted by KramerJ Sorry for the confusion. I have received a solution.
Any chance you could post the solution here for other forum users, please?

Thanks!

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post ran_sushmi Outlook 2 03-26-2009 05:37 AM Miket Outlook 5 12-10-2008 04:41 PM paulrm906 Excel 1 12-05-2008 07:51 PM motiv8d Outlook 0 08-07-2008 02:28 AM Zanmax Outlook 0 02-14-2006 06:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:49 AM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top