Results 1 to 2 of 2
2014-03-12, 10:42 #1
- Join Date
- Jan 2014
- Thanked 0 Times in 0 Posts
Copy from one sheet to another depending on the date entered.
I have a database where I enter data onto the first sheet call "All years table." I then have sheets specific to the individual years. What I want is is to enter the info into the "All Years Table" and have it copy over to the corresponding sheet I.E if I enter the date 12/12/2013 in "All Years Table" it will copy over to "2013 table" I have included a dummy file so you can see how I have my table set up.
Thank you for any assistance you can offer.
2014-03-12, 12:10 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- Thanked 342 Times in 335 Posts
I do not recommend the practive of trying to keep multiple copies of the same data in sync. In practice it is easier to maintain a master list and use filtering to limit what it viewed. The whole list can be filtered to look like the 2013 and any charts made with the whole will be plotted with only the filtered data. You can also use subtotal function to get averages and other stats of the filtered data if desired. If you must maintain the 2 copies, a userform that adds the entry to both all and subset sheets would be best. entering into the master and trying to automatically put into the child is problematic about the timing of when it should be transferred (if triggered by the date cell, any information in that row entered after the date is entered will not be copied. If you maintain a full table (no blank entries, you can check each entry and when the data-row is completely full it could copy it over.) The auto approach will not allow editing, however (the userform is better for this) since editing an entry after it is transferred will just create a new entry.
The Following User Says Thank You to sdckapr For This Useful Post: