Forum Discussion
copy cell data from other sheets
Hi,
I have a question regarding copying contents of cells from different sheets.
for instance I type =sheet1!A3 and I drag to the right to =sheet1!N3. From here I need to copy 2000+ rows and from several sheets.
Is there a quick way I can automatically get the information of the cells that contain text/values? My thought was similar to double clicking on the solid square ont he bottom right corner used for formulas.
Many thanks for your help and input.
Paste Link
Reference to the source cells instead of the copied cell contents.
Select copy area,
right mouse button and copy.
Go to the desired worksheet,
select the starting cell,
right mouse button,
paste content ...,
further paste options,
paste link (N).
Should be copied with reference cell :).
Hope I was able to help you with this info.
NikolinoDE
I know I don't know anything (Socrates)* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
4 Replies
Paste Link
Reference to the source cells instead of the copied cell contents.
Select copy area,
right mouse button and copy.
Go to the desired worksheet,
select the starting cell,
right mouse button,
paste content ...,
further paste options,
paste link (N).
Should be copied with reference cell :).
Hope I was able to help you with this info.
NikolinoDE
I know I don't know anything (Socrates)* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
- Thank you, but this I have tried. It does not copy the formula right for the other sheets. It takes it from the wrong cells.
I do not know how to get one specific cell always to corresponding cell on the other sheets so that I would not have to make the formula one by one by hand.
The point is that when I fill out the for example the name off my customer in sheet one, it would transfer the info automatically to sheet 2 and 3 and maybe 4.Is the link on merged cells?
If this not helps…
With your permission, I recommend to provide more information.
You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.
I recommend: Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).
If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description. In this case, a file (without sensitive data) would be very beneficial.
Don't forget that not every Excel user has a clue about every job and what you see he can't see.
Thank you for your understanding and patience
I know I don't know anything (Socrates)
- Thank you very much for your suggestion, this is a lot faster compared to how I was doing it.
