Forum Discussion
Needing Help having Master tab copy rows to other sheets based on code entered.
Hello, I am needing to build a new spreadsheet for myself that talks to each other entirely. I know there are many people WAYYYY more knowledgeable than I am in excel and I would LOVE LOVE LOVE ...
This is one of the most popular requests on this forum. This can task can be handled with FILTER. I've attached a demo workbook.
Before you undertake this project, I ask you to consider the arrangement of the workbook. Excel is capable of housing 1,048,576 rows by 16,384 columns - that's 17,179,869,184 cells on a single sheet! There's plenty of room for most any data set.
It's best to keep data that has the same field headings in 1 central location because it's easier to analyze it. If you need to view subsets of the data, you can filter, sort, create a pivot table, analyze with formulas, etc. Dynamic arrays are great and can make this silky smooth but why copy the data to multiple sheets if it's not needed.