1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How do I link cells ?

Hi everyone! So I am using data validation to pull information from one spreadsheet to create another. I am then going in to the new spreadsheet and adding relevant information next to each cell. I have found though when I pull data from the original spreadsheet, it is not adding it to the bottom on the new spreadsheet, but rather keeps the order it is in on the original document. This means though that the information I have added next to the data on the new spread sheet, does not move and becomes out of sync. Is there a way to link the cells so that they will move together? Or is there a may to make the data go to the bottom of the new spreadsheet?

I hope that makes sense !

Thank you :)

submitted by /u/fluffypokeball
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article