Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default tracking table data

Product # colour stage time
111 red s1 12:00:00 AM
222 white s2 1:00:00 AM
333 blue s1 2:00:00 AM
444 red s3 3:00:00 AM
555 red s4 4:00:00 AM


the above table updated automatically from another sheet , each product goes trough stages the start sage S1 and the end stage S4 ,what i want , for example take product number 111 , the stage S1 become S2 I want the tracking information to be in another table as below




111 red s1 12:00:00 AM
111 red s2 12:30:00 AM
222 white s2 1:00:00 AM
333 blue s1 2:00:00 AM
444 red s3 3:00:00 AM
555 red s4 4:00:00 AM

could this be done by formula or VB code please help - highly appreciated.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default tracking table data

On 27/09/16 07:07, TheExpat Wanderer wrote:
Product # colour stage time
111 red s1 12:00:00 AM
222 white s2 1:00:00 AM
333 blue s1 2:00:00 AM
444 red s3 3:00:00 AM
555 red s4 4:00:00 AM


the above table updated automatically from another sheet , each product goes trough stages the start sage S1 and the end stage S4 ,what i want , for example take product number 111 , the stage S1 become S2 I want the tracking information to be in another table as below




111 red s1 12:00:00 AM
111 red s2 12:30:00 AM
222 white s2 1:00:00 AM
333 blue s1 2:00:00 AM
444 red s3 3:00:00 AM
555 red s4 4:00:00 AM

could this be done by formula or VB code please help - highly appreciated.


Looks like you have to clone a textual copy and sort the whole sheet on
product then stage?

Sorry, not near Excel at the moment.

--
Adrian C
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tracking data Pat Rice Excel Discussion (Misc queries) 5 October 24th 08 06:06 PM
Tracking Data LV Excel Discussion (Misc queries) 4 September 10th 08 01:15 AM
A running-balance column in a bank-tracking table DeeDeeCee New Users to Excel 7 September 5th 07 11:37 AM
TRACKING DATA Akash Excel Programming 3 January 8th 07 05:36 AM
How to insert tracking numbers into my webpage for RMA tracking wiglady Excel Discussion (Misc queries) 0 April 4th 06 12:44 PM


All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"