Dynamic link between sheets

[Paul Bergholtz]

Hi!
I have a workbook which contains 6 sheets. Imagine that each sheet "belong" to a machine. When there's a problem with a machine, I fill in it's problem in that machine's sheet. The value in cell "Status (%)" and "Finished" will change until the fault is solved.
In the 6th sheet I want to have some overview of all the registered tasks from every sheet.
Example: When I write "Yes" in cell "Transfer?" in sheet1 (Task 1), the information in that row should be transferred to the first available row in Compilation Sheet. When the data changes in row "Task 1" in sheet1, this will be also be seen in Compilation Sheet (see attached file).
Is this doable?

Regards,
//Paul

 

[vletm]

Paul Bergholtz​

About Your: I have a workbook which contains 6 sheets.
Why You did send a workbook which has one sheet (Blad1).
Your Blad1-sheet has mentioned five sheets ... where is 5th sheet?
Your sample should show some sample data ... now Blad1-sheets shows Task1s & Task2s with 0's.
Could You send more realistic sample file with some realistic sample data?
Is it doable?

 

[Paul Bergholtz]

Hi,
I don't have any workbook of these sheets yet. The question was if it's doable to make a dynamic link as I explained in my post.
The attached file is just a graphic picture of the process.

 

[vletm]

Paul Bergholtz​

Many things are doable, if ...
You could send more realistic sample file with some realistic sample data?
About Your used term 'dynamic link' ...
... the information in that row should be transferred to the first available row in Compilation Sheet.
could do without any link.
BUT
When the data changes in row "Task 1" in sheet1, this will be also be seen in Compilation Sheet
Do You mean that after 'Yes' ... Compilation Sheet's that row should still refresh?

 

[Marc L]

Hi, it seems Excel is not the appropriate tool, better move to a database software.​

Anyway it could be doable under Excel with some smart data structure in order to use Excel basics​

like worksheet functions and filter or advanced filter or a pivot as you can train yourself …​

​

 

[Paul Bergholtz]

Paul Bergholtz​

Many things are doable, if ...
You could send more realistic sample file with some realistic sample data?
About Your used term 'dynamic link' ...
... the information in that row should be transferred to the first available row in Compilation Sheet.
could do without any link.
BUT
When the data changes in row "Task 1" in sheet1, this will be also be seen in Compilation Sheet
Do You mean that after 'Yes' ... Compilation Sheet's that row should still refresh?

I do not yet have a sample file to update, since I've only have a workbook with 6 sheets. Before I dive into this little project, I just wanted to know if it's doable or if I'm more or less wasting my time.
"Do You mean that after 'Yes' ... Compilation Sheet's that row should still refresh?" Yes, that's right.

 

[vletm]

Paul Bergholtz​

You've gotten the answers above - yes.
and
You should know - what do You really need?

 

[Paul Bergholtz]

Hi, it seems Excel is not the appropriate tool, better move to a database software.​

Anyway it could be doable under Excel with some smart data structure in order to use Excel basics​

like worksheet functions and filter or advanced filter or a pivot as you can train yourself …​

​

Hi Marc,
Yes, a database is probably a better way but this little project doesn't quite include that much data so it's worth the effort by setting up a DB. I have some ideas which I'll be testing during this weekend.

 

[vletm]

Paul Bergholtz​

Why do You need six sheets and duplicated datas?
Instead that, You could use something like this
... with one table and some slicers.

 

[Paul Bergholtz]

Sorry for late reply. I'll try this in my application and see if it works. Thanks.