How to associate manually filled cells with cells linked to other excel files?
Hello everyone,
First of all, I’d like to apologize if I made any mistakes. English isn’t my first language.
I have encountered a problem at work and I wonder if you could help me.
I have linked some cells to other Excel files so they can fill themselves according to the cells from those files.
Furthermore, I manually filled some other cells on each line corresponding to the imported cells.
The problem arises when I update the files from which the data is imported.
Indeed, when lines are added to those files, they are also added to my main Excel file (which is good, that’s what I want), but when those lines are added, my manually written data doesn’t move with the cells they were next to originally. As a result, they appear next to cells they shouldn’t be next to. Basically, my whole column of manually written data becomes incorrect.
What can I do to ensure those manually written cells stay with the imported cells so they move together if more lines are inserted in between?
Thank you for your help,
Wiljunow.
Hello everyone,First of all, I’d like to apologize if I made any mistakes. English isn’t my first language.I have encountered a problem at work and I wonder if you could help me.I have linked some cells to other Excel files so they can fill themselves according to the cells from those files.Furthermore, I manually filled some other cells on each line corresponding to the imported cells.The problem arises when I update the files from which the data is imported.Indeed, when lines are added to those files, they are also added to my main Excel file (which is good, that’s what I want), but when those lines are added, my manually written data doesn’t move with the cells they were next to originally. As a result, they appear next to cells they shouldn’t be next to. Basically, my whole column of manually written data becomes incorrect.What can I do to ensure those manually written cells stay with the imported cells so they move together if more lines are inserted in between?Thank you for your help,Wiljunow. Read More
