Excel 2003 macro setup

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.

Skills: Data Entry, Data Processing, Excel

See more: template guru, setup-guru, setup guru, need someone to create a excel template for me, microsoft excel job, me excel, job matches, guru ask, file guru, data entry macro, ask the guru, ask guru, ask excel, ask a guru, what is macro in excel, new excel, microsoft macro, urgent need for excel, urgent excel, product data sheet template

About the Employer:
( 16 reviews ) Toronto, Canada

Project ID: #958669

Awarded to:


Hello, excel expert here. I can get this done for you. Please check PM. Thanks!

$50 USD in 1 day
(59 Reviews)

9 freelancers are bidding on average $57 for this job


Please see PMB

$66 USD in 0 days
(86 Reviews)

Ten years experience.

$75 USD in 1 day
(25 Reviews)

^^^^^^ Please SEE PMB ^^^^^^^^^^^

$30 USD in 1 day
(20 Reviews)

Hi, I am interested in this project

$65 USD in 2 days
(7 Reviews)

Hi, I can do it with macro. I'd like an example for know best what to do. Thanks.

$50 USD in 1 day
(1 Review)

You can think about my bid.

$30 USD in 5 days
(0 Reviews)

Please see PM.

$100 USD in 30 days
(0 Reviews)

Hi I can do this job for you. Pls see PM for details

$50 USD in 1 day
(0 Reviews)