ProjectionExample.xls . ProjectionExample.xlsm 2 sample copies (not sure which one works)
I am an intern responsible for sorting information based on promise dates into separate tabs for a weekly report. We have 6 teams (six different spreadsheets) each has 18 worksheets (one tab for late, one for each week -16 weeks out, and one for anything beyond that). There are between 200 and 2000 items (rows) per team.
I am trying to build a macro that will select rows based on the date in the promise_date column and paste that selection to the appropriate worksheet (Tab?).
I've built a mock-up of the spreadsheet I am using.
I work for a company that deals with the government, so I'm not allowed to provide any Real Data.
Additionally, I have excel 2007 at work and 2010 at home, so my macros don't work very well when I try to build them off the clock.
I'm building one macro for each tab and then a "Lord of the Macros" - (Read in Gandalfs voice - "One macro to rule them all").
Specifically, I think I'm stuck on moving from one row to the next.
This macro will select one row based on the criteria, but then it stops.
The message box just lets me know that I haven't broken something else (it's not really necessary).
And, Yes, I have to do it this way. The guy I replaced built this and there are alot of other moving pieces.
No, I can't use the data filters. I already do that (and use weeknum function too) and it still takes 3-4 hours.
Any and all help is appreciated.
Please Login or Register to view this content.