Hello Excel Gurus,
I have two workbooks - I copy the cells from the original 'Data' workbook, and paste links into my 'WIP' workbook, then reorganise the column order etc.
While most info is pulled through from 'Data' workbook, I still have several columns in my 'WIP' which require manual input.
Question
Is there any VBA coding that allows me to 'tie' the manual cells to the linked cells in the same row... so if the linked cells drop down a row, the manual cells drop down too? See example below
Scenario example
In 'WIP' doc
Cell A10 has been manually updated with a job number eg 'OPT101'.
Cell B10 is linked to 'Data' Cell F10 which has the job name eg 'New Product Launch'
Row looks as follows:
Then someone adds a new row at row 9 in 'Data' workbook (ie Row 10 drops down to Row 11)...
Back in 'WIP' doc
Rows now look as follows:
Any thoughts or ideas would be greatly appreciated
Thank you in advance,
Rox
I have two workbooks - I copy the cells from the original 'Data' workbook, and paste links into my 'WIP' workbook, then reorganise the column order etc.
While most info is pulled through from 'Data' workbook, I still have several columns in my 'WIP' which require manual input.
Question
Is there any VBA coding that allows me to 'tie' the manual cells to the linked cells in the same row... so if the linked cells drop down a row, the manual cells drop down too? See example below
Scenario example
In 'WIP' doc
Cell A10 has been manually updated with a job number eg 'OPT101'.
Cell B10 is linked to 'Data' Cell F10 which has the job name eg 'New Product Launch'
Row looks as follows:
Column A (manual input job no.) | Column B (linked to 'Data' Workbook, cell F10) | |
Row 10 | OPT101 | New Product Launch |
Then someone adds a new row at row 9 in 'Data' workbook (ie Row 10 drops down to Row 11)...
Back in 'WIP' doc
Rows now look as follows:
Column A (manual input job no.) | Column B (linked to 'Data' Workbook, cell F11) | |
Row 10 | OPT101 | |
Row 11 | New Product Launch |
Any thoughts or ideas would be greatly appreciated
Thank you in advance,
Rox