This job is for someone who is a Microsoft Excel Guru.
I am using Excel 2003.
I need a macro that does the following.
- On the file ([url removed, login to view]),the first sheet "Sheet1" holds all the data that i need filtered.
I need to filter some data from the "Sheet1" to go to sheet "1"
-Sheet "1" is a template.
- ID 1 and ID 2 are fixed and always together.
I need the macro to do the following by checking the template and see what id 1 and id 2 are together, than goes on the data file sheet "Sheet1", the range will be product 1 or 2 or three (will be decided by me), finds those matches, and filles the column F on sheet "1" with the numbers from "Week 1 - january". After that i will create another worksheet names "2", in that worksheet the template will be the same, but this time the column will be filled with numbers from column "Week 2 - january" .....and so forth.....
If the ID 1 and ID 2 are present more than once for Product 1 on "Sheet1", the macro needs to put the SUM on the template.
Keep in mind that "Sheet1" will be updated every week so the macro has to take the new week and put in the template that i create.
So basically i need this process automated.
I need this urgent...ask any questions if i have not been clear.