I'm trying to create a project tracking workbook made of multiple worksheets, with each one representing a milestone made of about 100 rows showing each task. Once a task is marked as complete, certain cells in that row should link to a row in the next spreadsheet, etc.
More specifically--
On Worksheet 1, I want to link certain cells in each row to cells on Worksheet 2—based on a condition, such as an x appearing in the last column. If there is no x, there is no linking.
For example, on Worksheet 1, cells B3, C3, D3 link to the cells on Worksheet 2 –if there is an x in H3 on Worksheet 1.
Then, once that row on Worksheet 2 is marked complete, A3, B3, and E3 link to Worksheet 3.
The linking does not need to match the same rows on Worksheet, and in fact, it would be better if rows accumulated from the top as tasks are completed on the previous Worksheet.
I've tried this IF statement, and it works from Worksheet 1 to 2, but not beyond.
=IF('1. Inventory Existing Site'!$H:$H="[x]",'1. Inventory Existing Site'!A:A,0)
Any ideas? Formulas and Macros welcomed.
Thanks!
More specifically--
On Worksheet 1, I want to link certain cells in each row to cells on Worksheet 2—based on a condition, such as an x appearing in the last column. If there is no x, there is no linking.
For example, on Worksheet 1, cells B3, C3, D3 link to the cells on Worksheet 2 –if there is an x in H3 on Worksheet 1.
Then, once that row on Worksheet 2 is marked complete, A3, B3, and E3 link to Worksheet 3.
The linking does not need to match the same rows on Worksheet, and in fact, it would be better if rows accumulated from the top as tasks are completed on the previous Worksheet.
I've tried this IF statement, and it works from Worksheet 1 to 2, but not beyond.
=IF('1. Inventory Existing Site'!$H:$H="[x]",'1. Inventory Existing Site'!A:A,0)
Any ideas? Formulas and Macros welcomed.
Thanks!