|
|
#1
04-06-2009, 08:23 AM
|
|||
|
|||
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
|
||||
|
||||
|
Quote:
 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
|
|||
|
|||
|
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.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Download of mails to both outlook and web-based mails
|
ran_sushmi | Outlook | 2 | 03-26-2009 05:37 AM |
| Auto entry of email address (who I'm sending to) | Miket | Outlook | 5 | 12-10-2008 04:41 PM |
|
Last Number in a Column
|
paulrm906 | Excel | 1 | 12-05-2008 07:51 PM |
| Outlook 2000 Net Folders failing to make entry | motiv8d | Outlook | 0 | 08-07-2008 02:28 AM |
| Entry point not found? | Zanmax | Outlook | 0 | 02-14-2006 06:26 AM |
Windows XP 
Office 2003
Linear Mode
