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

Tagged with

#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#Excel alternatives for data analysis
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#spreadsheet API integration
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance