•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Mirroring One Tab to Another, But Not Vice Versa
Our take
Navigating the complexities of income tax season can be daunting, especially when your preferred tools clash with team dynamics. If you're looking to streamline your Excel workflow without sacrificing your meticulous calculations, there’s a way to create a separate tab that mirrors essential client details while retaining your formulas. This approach allows you to manage your data efficiently, keeping your stress levels down. Let’s explore how you can achieve this seamless integration, ensuring you stay organized and empowered throughout the busy season.
Good Morning All,
I'll try and be as TL:DR as possible. I am entering the ever-dreaded income tax season. I am also the only person in our office under the age of 60. Needless to say, my one partner cannot stand Excel, which is unfortunate because I live on it. One reason he doesn't like it is because I have all kinds of formulae calculating how many returns I need to do per day to finish by a certain date, and several other similar computations that keep me on track, in control, and therefore less stressed. He wants to phase Excel out altogether.
My (secretive) compromise is to remove all of the formulae that are really just for me anyway and "dumb" the spreadsheet down to just the client name and the date it was received. I would, however, (and here comes the secretive part) like to have a separate tab that retains all of my formulae but pulls from the "dumbed" down list so I don't have to enter client names and dates received twice. Is there a way to mirror another tab where one has only client name and date but my other tab has a bunch of my original formulae on it? I know I can = another tab, but the problem is I sort returns alphabetically, by which ones are complete vs. not, by which ones got extensions, etc. so it's not just a straight down list. It constantly gets re-filtered.
Any insight would be great. I can probably mess with it and just do =$ calculations, but if there's an easier way, I'd love to hear about it. Also, the Excel nerd in me loves learning new things anyway, even if I can do it my own way.
Thanks!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Is it possible to pull information from multiple tabs and make it customizable without altering formulas?Apologies for the confusing title, but I'm not sure how else to word it. I work in a sales-focused role, recently at my job we have been required to send out sales recaps to higher ups. We need to calculate how many sales points we make daily along with calculating goals. I am using the web version of excel since I have to share this across a team. My current set up is as follows: - Each employee gets their own tab with a list of products we sell + how many points they are. Throughout the day they enter in what they did and it automatically calculated the points they earned. - I have another tab called "calculator". This combines all of the totals across the tabs into one chart. ex: =sum('employee1!' A1, 'employee2!' A1) and so on. - the final tab pulls the important information from the calculator tab and into the format that they want it in. I've been asked to share this spreadsheet with other locations, but many of my co-workers are unaware of how to set up a spreadsheet like this. I want to make it as user-friendly as possible before sharing it. I want to be able to add/ delete "employee" tabs as needed without having to change formulas on the main "calculator" tab. Is there any way to set up the =sum() function to change based on the number of tabs automatically? submitted by /u/electricpaperclips [link] [comments]
- I am trying to prevent the end user from having to insert data twice to see it on two different sheets, and the formulas I've been trying aren't copy/pasting well.I have been making a CRM spreadsheet for a finance business with over 100 clients. In trying to optimize the formatting, I have developed two different views which have two different uses. Sheet 1 is "2026 List View" where the informaiton is all on one row per client. It is annoying to side scroll to see all of the information, but it gives the best overall view as to who has paid. https://preview.redd.it/1yinsuhafikg1.png?width=3370&format=png&auto=webp&s=7559a5cfc76b671e2bbcc4b4700c446e2531ce46 Sheet 2 is "2026 Grid View" where the informaiton is organized differently to not need side-scrolling, and gives a better quick per-client view. https://preview.redd.it/2oip1qrbfikg1.png?width=2697&format=png&auto=webp&s=7b4f9f29f34db95d14e17df60efca580ff4c546a I am writing formulas for Sheet 2's cells to reference Sheet 1's data. For example, Sheet 2's cell B3 has ='2026 List View'!A2 and it is working well in terms of the formula. However, once I finished two tables refrerencing cells in rows 2 and then 3, copy/pasting made the next table do the correct columns but in the rows 16 and 17 instead of 3 and 4. I tried continuing the pattern longer, but copy/pasting still made it skip several rows though it is recognizing the correct columns. Is there a different formula I could use to make the copy/pasting more successful? Or, am I stuck doing this cell by cell for 100 rows, making it not worth the hassle? submitted by /u/urgrlB [link] [comments]
- Working on creating a formula to use information across two cells to determine calculations in other cells(reposted first post got removed) I'm not certain the IF formula(s) are what I need but I'm not sure what else to use. Trying to create a spreadsheet for work: the premise is that if one or two people are the Contact for a project, they will split 5% of the project's earnings, each getting 2.5%; if only one person, they get 5%. The same for if one or two people who are the Winners for the project. I need some way for the spreadsheet to be able to see that if someone's initials are under either Contact or Winner, to then give them either 5% of the net income if they are the only Contact or only Winner, or 2.5% if they share either spot with someone else. The total amount of the net income given out as a bonus will always come to 10%. The first picture shows my 'backend' sheet and a formula I was trying that would calculate 2.5% of the Net Income if someone's initials showed up on the project, but this doesn't work if their initials only show up once because then they would need to get 5%. I would also hope there would be a less clunky way to do this many calculations. The second picture is a section of the main page of the sheet showing the Contact and Winner columns, the Net Income the bonus comes out of, and then the Total C/W amount under everyone's initials that adds up their total bonuses. Backend sheet, 'points' refers to first sheet First sheet of spreadsheet Please let me know if I have not been thorough enough with explaining what I'm trying to do, I'm so deep in this now that I am really really confused and just need help straightening this all out. Using newest version of Excel on a macbook, have also been working on same spreadsheet in Windows. I'm not a beginner at excel but not all that good either. TYSM in advance. submitted by /u/Financial_Device7400 [link] [comments]
- Workbook from Microsoft Form encountering very long load times from excessive complex formulasGood evening, I work in a food production plant in Shipping and Receiving. We have had Microsoft Forms for entering in daily cases produced, cases shipped, and a separate form for doing time studies on trucks that come in, how long to load or unload said truck, and when they leave. I have had a manual workbook to fill in all of this data basically again (this information gets entered into these daily reports we fill out in our Microsoft forms) but to organize it into an easy daily report to give us truck In to Out averages, loading time averages, cases produced vs what was scheduled to produce, etc.. A big issue I have had with this manual data entry workbook, which are done month by month, is the amount of formulas which I have in it..(multiplying cases by item number to give us weight and how many skids, calculating our scheduled amount to produce against what's actually produced, giving percentages, many conditional formatted cells to easily show if we are in the green or red, etc.) Now my boss has always wanted a workbook to do what my manual workbook does but to grab the data from the Excel workbook that these Microsoft forms load the data into. The problem before was we had two separate Microsoft forms for daily cases produced/shipped and the one for our time studies. But I went ahead and made one form which would do both. I was able to copy over many sheets and formulas from my manual workbook into the Excel spreadsheet that loads in the data from this Microsoft Form. My boss really wants it to work indefinitely.. The problem I am encountering which I was afraid of, is the amount of formulas in this one workbook is way too much for a computer to handle. Changing 1 thing results in it needing to calculate a thread for like 20-30 minutes (like with the manual excel spreadsheet, the manual processor has been set to 1). Am I just going about this all wrong? Is there a better way to grab the data from this form that isn't going to overload a computer? Do I make separate workbooks pulling from this form's Excel workbook and just keep the daily report with the initial Microsoft Form workbook (but then would those workbooks update automatically as well?) I imagine there is a way to achieve what my boss is wanting, but my experience with Excel is only so advanced. I'm aware there are other programs or other tools of excel, and that is why I came onto this subreddit for advice. Please help me 🙇🏻♂️ submitted by /u/maverickrose [link] [comments]