I have Sheet 1 where my data is entered from A1 to A10.
Now I want the data to automatically be updated in Sheet 2 from A1 to J10.
How can I do this? I thought using the absolute and relative references will help, but not in this situation.
I have Sheet 1 where my data is entered from A1 to A10.
Now I want the data to automatically be updated in Sheet 2 from A1 to J10.
How can I do this? I thought using the absolute and relative references will help, but not in this situation.
It can be done with indirect().
See the attached file.
d1=INDIRECT("a"&column()-3) and drag to the right.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Can the Indirect Function also refer to other sheets?
yes, it can,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks