How Do You Keep Track Of Your Collection?

My master data sheet is the simplest to set up. I ALWAYS design a spreadsheet on paper first. It actually saves time in the end. Determine what column headers you want, i.e. Coin Date, Grade, Denomination, etc. In the denomination column I use the series name of the coin instead of the denomination itself. Example " Jefferson nickel". By doing this I can extract information specific to the Jefferson's I have. I then designed the additional sheets. I think the best thing to do for this is design one that you can use for ALL your different series. Once you have the design completed you can do all of your other sheets at the same time. This is how to do multiple sheets at once. Design the first one on paper. Next decide how many different sheets you will need. Open Excel and click on the + at the bottom to add blank sheets until you have the required number of sheets you want.. Now, go back to the first tab and click on it. Next, move to the last tab, hold down the SHIFT key and click on the tab. That will select ALL the sheets. Enter the information on the first sheet, which is still the active sheet, and it will automatically enter the same information and format on all the other sheets simultaneously. You can also use this technique to enter formulas but have to be very careful as cell references can be either "relative" or "absolute". I hope this helps.