Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-06-2009, 08:23 AM
KramerJ KramerJ is offline Sequentail Number Each Row Based On Another Column Entry Windows XP Sequentail Number Each Row Based On Another Column Entry Office 2003
Novice
Sequentail Number Each Row Based On Another Column Entry
 
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
  #2  
Old 04-12-2009, 11:35 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Sequentail Number Each Row Based On Another Column Entry Sequentail Number Each Row Based On Another Column Entry Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

Quote:
Originally Posted by KramerJ View Post
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,
Reply With Quote
  #3  
Old 05-07-2009, 02:02 PM
KramerJ KramerJ is offline Sequentail Number Each Row Based On Another Column Entry Windows XP Sequentail Number Each Row Based On Another Column Entry Office 2003
Novice
Sequentail Number Each Row Based On Another Column Entry
 
Join Date: Mar 2009
Location: Las Vegas, NV
Posts: 5
KramerJ is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 05-07-2009, 11:35 PM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Sequentail Number Each Row Based On Another Column Entry Sequentail Number Each Row Based On Another Column Entry Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

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

Thanks!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sequentail Number Each Row Based On Another Column Entry 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
Sequentail Number Each Row Based On Another Column Entry 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

Other Forums: Access Forums

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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft