Iterative Macro required to solve sequence problem
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
anayet1988
8 - Asteroid
‎12-14-2021
12:40 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi everyone,
I have come across a complex problem that I am having issues resolving.
I have attached the file an excel file with two tabs. The original input data and the Excel Attempt.
I am attempting to create the Sequence number depending on The ToolID, From-To and ConnectionNum. The first Sequence number will always be 10001 and From-to will be Origin, then the next sequence number is made by finding the the ConnectionNum thats the same as 10001 (which is 1) and then that will also be 10001 but because that's a destination, we then have to find the next Tool ID which is 5 and then the next Sequence Number will be 10002.
I have also provided a video explaining my problem
Can anyone help me to create an iterative macro?
Thank you
Labels:
- Labels:
- Iterative Macro
- Macros
0 REPLIES 0
