Hi All,
In the interest of avoiding tremendous data entry of new data every day, i want to link my daily raw data so it gets updated automatically which i am able to. However the challenge i am facing is this:
For example:
Col A-D are linked and updated automatically daily in excel, but Col E-H i want to be able to input data manually and i cant because its a linked excel file and it wont let me edit.
Is there anyway to achieve this?
I wont mind importing and rewriting Col A-D on a daily basis in my database ONLY IF it OVERWRITES/UPDATES everything in JUST THOSE COLUMNS so as to NOT skew up the corresponding manually entered columns...
Please advise.