Hi all
I have encountered another problem today due to a change of requirements in my workbook.
I currently have a worksheet where Column I contains numeric data. I now need to add an adjacent column (J) where the adjacent cell will equal the contents of Column I by default but also allow for a manual entry to overwrite the copied contents.
In others words J2 = I2 unless manually overwritten.
The range of each column will be from I2 & J2 downwards as there is a header title for each column and the contents of the columns will expand each week, with the addition of new data.
Data validation is not a solution; so I hope this can be solved using VBA. I did a search but nothing came up that matches my requirements.
TIA ...David