•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Info within cells or new sheet?
Our take
When managing a spreadsheet with numerous properties, organizing data efficiently is crucial. You’ve created a tab to breakdown details by address, but it’s become unwieldy with over 400 lines. To enhance navigation, consider linking specific cells in your main sheet to corresponding entries in the new tab. This way, you can quickly access relevant information. Alternatively, explore creating a pop-up feature on the main sheet that provides a breakdown per unit, streamlining your data management and making it more accessible.
I am trying to figure out the best option for data within a cell. So the company I work for has about 200 properties in an excel spreadsheet. Some are single family up to multi apt complexes. With any property having more than unit for rent, we would like to be able to see a break down by address. I created a tab, and linked the tab to the address on the main tab. But now that new tab is over 400 lines long and it makes it hard to find certain data.
Is it possible to make the link take me to the corresponding cells in the new tab? Or can I make something on the main sheet, pop up with a breakdown per unit?
Thanks
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Slow spreadsheet - need troubleshootingHi, I have a spreadsheet that has two tabs, one is essentially the original data which is YTD driven for a particular GL account, the company has smaller amounts of transactions, so by December we are talking about maybe 3-5k rows of transactions for the account total. The main tab being utilized, has about 30 columns of look up and sumifs formulas referencing the source data and in total approx maybe 500 rows by year end? To me it doesn’t seem excessive. I’ve dealt with way heavier spreadsheets that have more omph and run faster. But for some reason this one is slow as all hell to work in. I’ve even tried barcoded some data and not seen any improvement. I’m not too techy into what else could be slowing it down. And ideas on what to troubleshoot from here? submitted by /u/SlideTemporary1526 [link] [comments]
- 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]
- 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]
- 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]