•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Can I "link" different spreadsheets together and make them "communicate"?
Our take
Linking different spreadsheets to create a seamless flow of information is not only possible but can significantly enhance your efficiency. In your case, you can use Excel's features like "IMPORTRANGE" or "Power Query" to connect Spreadsheet A and Spreadsheet B. This allows your spreadsheet to update automatically with new hires while retaining historical data, even if entries are deleted in the original spreadsheet.
i am new to excel but hoping to get a quick answer to my question as I am having trouble finding this on the web.
i have Spreadsheet A where new hires get added to a list by someone else. This include their name, division, email, etc.
I manage education and compliance in Spreadsheet B which includes me having to manually go through spreadsheet A and pulling all the info over.
other than this inconvenience, the trouble is the person managing spreadsheet A deletes these people from her spreadsheet after she is done with their on boarding process so if i dont catch it, its a pain in the ass for me to get that info lol.
is there a way for me to have my spreadsheet get updated when she updates hers, but not have that information deleted if she were to delete something from it?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- join content from cells in a column without losing content from the corresponding columns.basically how do i make the highlighted screenshot look like the unhighlighted one but with a function for a spreadsheet with like 170k rows. sorry that this is in sheets. im trying to figure out if what i need is to buy excel basically what i want is to condense duplicative info while listing/joining the different pieces, all controlled for case number. https://preview.redd.it/4rfjrucnjdzg1.png?width=1408&format=png&auto=webp&s=ff424cf0a8553fe30b769986169901c1ca25a3bd https://preview.redd.it/c8mtq58ojdzg1.png?width=1080&format=png&auto=webp&s=21ccbdfd8ae8d41eb2d69368e62163df3737088b submitted by /u/Abi-Ankeney-PMM [link] [comments]
- Hyperlink on Excel MobileI am building a complex spreadsheet for an operational task at work. Without going into detail essentially employees that are out on the road will use cell phones or tablets to enter data for employees that are at the home office to print. The current set up is chaos. In my workbook, there are many hyper links that on desktop are one touch however, in mobile, you have to click, two sometimes three drop downs to open the link. I have a mixture of formula hyperlinks that are title words, button style, hyperlinks attached to a text box or picture that are above the cell and within the cell. They all do the same thing. In Excel online some perform as one touch and some you have to open the link then click the link. It would be fine if the clicking wouldn’t result in hyperlinks getting deleted or messed up and I have too many tasks to micromanage the corrections. Does anyone have any suggestions on how to make these perform as one touch on mobile? submitted by /u/Present_Brush7357 [link] [comments]
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
- Central Data Sheet efficiencyHoping that someone with some in depth technical knowledge of Excel can help me out with a query. We issue Finance Tracker spreadsheets to projects in our organisation, and then link them back to a central sheet that we use for monitoring and reporting. There are maybe 40-50 cells in each spreadsheet that we need to pull in to our central sheet, but they’re spread around the tracker and so are generally linked individually, and we’re now approaching 120 trackers that need to be linked, so the central sheet is starting to get quite slow to load and update. My question is this: When doing cross workbook cell look ups, do arrays work more efficiently than individual cell references, or is there no noticeable difference in runtime? My idea is to, in each project’s workbook, create an “export” tab that contains all the information that needs to be pulled out, and link the central sheet by looking at that array, rather than each individual cell. submitted by /u/Jamespg614 [link] [comments]