Hi,
My scenario is that I have a long list of drawings that are interconnected. The drawings describe a large production process.
Each drawing has multiple (+10) inputs and outputs that are coming from the other drawings.
I am making a table that describes properties of each drawing. Having the drawings on the rows and the properties on the columns.
What I would like it if I could in row X have a column for inputs, where the input cell would have multiple input drawing numbers.
And here comes my main issue.
I would want to be able to filter on one of those input drawing numbers and then have the whole line show.
The idea behind this is, that if I have a distribution of fx. cooling water with drawing no. X, then I would like to be able to filter on that number and then find all the other drawings that are linked to that drawing no.
Oh and yes I would like if I could have this as VBA code for column X in range K4:K200 ( for example)
I hope it makes sense and that some can help me.
BR
JAZ
My scenario is that I have a long list of drawings that are interconnected. The drawings describe a large production process.
Each drawing has multiple (+10) inputs and outputs that are coming from the other drawings.
I am making a table that describes properties of each drawing. Having the drawings on the rows and the properties on the columns.
What I would like it if I could in row X have a column for inputs, where the input cell would have multiple input drawing numbers.
And here comes my main issue.
I would want to be able to filter on one of those input drawing numbers and then have the whole line show.
The idea behind this is, that if I have a distribution of fx. cooling water with drawing no. X, then I would like to be able to filter on that number and then find all the other drawings that are linked to that drawing no.
Oh and yes I would like if I could have this as VBA code for column X in range K4:K200 ( for example)
I hope it makes sense and that some can help me.
BR
JAZ