Hi everyone,
Each product has four stages s1 s2 s3 s4
I want to track the stages each product pass through
As per below explanation
Table1(the main table)
Pro1 s1
Table2
Pro1 s1
Table1
Pro1 s2
Table2
Pro1 s1
Pro1 s2
Table1
Pro1 s3
Table2
Pro1 s1
Pro1 s2
Pro1 s3
So table2 track the changes in the product stage.
I think All the coding should be done on table2
Please help
Re: Track new data
I would doubt anyone could help with the information you have given. Please take the time to explain your process, what information changes, how, and what information you want to track.
Ideally upload a sample workbook showing a before and after scenario.
[sw]*[/sw]
Re: Track new data
Quote from cytop;778208I would doubt anyone could help with the information you have given. Please take the time to explain your process, what information changes, how, and what information you want to track.
Ideally upload a sample workbook showing a before and after scenario.
[sw]*[/sw]
Please help i uplaoded the sample detailed file
Re: Track new data
I'm sorry, there's still not enough information.
Quotethe above table updated automatically from another sheet
How? Formula? VBA code?
As mentioned in my previous post
Quoteit is essential that the structure of the actual workbook is retained.
QuoteIf a cell contains a formula keep the formula in the sample
You need a representative sample workbook plus any additional data/workbooks to supply the source data.
Table track data
Please help me in coding , my question is clearly explained in the attached excel file.
Don’t have an account yet? Register yourself now and be a part of our community!
