Hey guys,
Unfortunately I cannot attach a file because I would get fired for putting information on the internet. In short, I'm trying to auto sort data into spreadsheets based off of the month the project was started. We have a "Master" spreadsheet with all the projects, dates started, and other information which is irrelevant here. I would like the projects and all the data to get sorted into the correct spreadsheet via month. So we have the master sheet, a sheet for january, february, march, etc. For example, if project A was started in January, B in february, C in march; this data would get sorted into the correct monthly spreadsheet (the master sheet will be continuously added to daily). I thought I could figure this out with a vlookup but soon realized I had nothing on my monthly sheets as a lookup value. Any ideas at this point would be great!
-Dan
Bookmarks