Forum Discussion
Need help with if function or macro copy cells if cell = y?
Hello,
if you keep all the data in the Master sheet, why do you want to duplicate the data into other sheets? Duplicating data is not good data architecture, because then the data can be changed in two places and how do you ensure that master and copy are kept in sync? How do you know which version is the correct one?
So, from a data architecture point, keep only one master list, and then filter or report to see only the data you're interested in.
You could turn on Autofilter on the Master and quickly filter to see only the rows where Veteran is "Y", or Deceased is "Y" or any other filter.
Or, you could use a report sheet, build a pivot table and pull the data from the Master sheet. The pivot table can have filters to show only Veterans or other filters. The point here is that there should be only one place where the data is stored and edited.
That does make sense, I wanted to have it sorted for me. In this case, once the data is entered it really won't change. I am talking about logging a cemetery list of interments. Those are fairly final. I do however understand what you mean and it is a very good point. I can play with a pivot table. I have a very limited knowledge of excel so I'll cross my fingers.
Thank you