Hi - I have a workbook with 10 sheets
I created a copy\link from Sheet1 to Sheet1
Sheet 1 contains 'code' in column F
Users fill out column F for one group then click save which moves the completed data to G, H, I for as many groups as they fill out
There is another button on Sheet 1 that says 'change data'. Rather than have code in every column I have all my code in column F.
The macro asks the user 'which column is the data in'
They enter column i.e. H
The macro moves the group with all data in column H over to column F for any updates then upon save, moves it to the first blank column and removes the blank original column H - reason for this is because when the pop up box asks the user which column they need to change, and moves it to F, I couldn't determine how to find 'where it came from' but knew how to tell it to put the new saved version in first blank and remove the 'in between' blank column
This of course causes the link on Sheet 2 to change to #REF!
Sheet 2 still has the column data but it now resides in F, X and AO
How can I fix this? TIA
I created a copy\link from Sheet1 to Sheet1
Sheet 1 contains 'code' in column F
Users fill out column F for one group then click save which moves the completed data to G, H, I for as many groups as they fill out
There is another button on Sheet 1 that says 'change data'. Rather than have code in every column I have all my code in column F.
The macro asks the user 'which column is the data in'
They enter column i.e. H
The macro moves the group with all data in column H over to column F for any updates then upon save, moves it to the first blank column and removes the blank original column H - reason for this is because when the pop up box asks the user which column they need to change, and moves it to F, I couldn't determine how to find 'where it came from' but knew how to tell it to put the new saved version in first blank and remove the 'in between' blank column
This of course causes the link on Sheet 2 to change to #REF!
Sheet 2 still has the column data but it now resides in F, X and AO
How can I fix this? TIA