Forum Discussion
Coding in multiple sheets
Honestly it's a hypothetical question,,, please edit your post & be specific all about your need, better share some sample data & expected output with us!!
Here is an example of what Im trying to accomplish. when I type transactions on the primary tab, I want it to show up in the corresponding tab. Does this make sense?
I've suggested to possible methods, first is VBA macro and another is an array (cse) formula,, check the attached sheet and read the instructions carefully.
Jurac29 I believe you are on the right track when you want to collect all transactional data in one sheet. But I wonder why you would, then, want to split everything into individual sheets. That's certainly not the most effective approach. Excel has several in-built tools that can do the summaries per type for you. No VBA, no difficult formulae. You mention to be "completely new to this". It may be a challenge, but perhaps you want to explore pivot tables, built on the Primary data. I suspect that your real data isn't as simplistic as your example file, so if you could upload something that is closer to your real life situation, that would be helpful. And if you are up for a slightly bigger challenge, you might want to learn about Power Query, or Get & Transform Data as it is called in Excel 2016 and later.
Jurac29 The file you uploaded is very similar to what you uploaded before. It it really so basic (Type, Amount, Description) ?
If so, add one more column with, for example, a sequential transaction number. Create a pivot table and then, from that one, you can create one table for every Type with a few clicks. See attached.
Would that work for you?
- There are more ways to do this, such as with VBA.Here are just 2 quick examples with out VBA.Hope I can help you.Thanks for your time and patience.NikolinoI know that I know nothing (Socrates)
This model also doesn't allow them to stay in transaction order.
For instance:
If I make 10 company transactions and record these all on the primary tab
Those 10 transactions are spread over 3-4 different simultaneous projects and not in any order.
The tabs indicate a different project, but the primary (where i input data) represents the entire company.
I'm researching VBA (no clue) to see if this more what i need. i feel as though I have seen a spreadsheet similar in the past , just cant find currently.
I can make that work....but I was hoping for the opposite direction. I would be able to input ALL the data on the first sheet and it go to the corresponding sheets once I coded it on the first. If this isn't possible, let me know. You have been a big help either way. Thanks
