I gang

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.

Færdigheder: Dataindførsel, Databehandling, Excel

Se mere: template guru, setup guru, microsoft excel job, me excel, job matches, guru ask, file guru, data entry macro, ask excel, ask guru, new excel, microsoft macro, urgent need excel, urgent excel, product data sheet template, macro, macro excel, excel guru, create excel worksheet, sheet excel job, microsoft excel template, data entry worksheet excel, range macro excel, file filter excel, excel time sheet

Om arbejdsgiveren:
( 16 bedømmelser ) Toronto, Canada

Projekt-ID: #958669

Tildelt til:


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

$50 USD på 1 dag
(59 bedømmelser)

9 freelancere byder i gennemsnit $57 for dette job


Please see PMB

$66 USD in 0 dage
(86 bedømmelser)

Ten years experience.

$75 USD på 1 dag
(25 bedømmelser)

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

$30 USD på 1 dag
(20 bedømmelser)

Hi, I am interested in this project

$65 USD in 2 dage
(7 bedømmelser)

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

$50 USD på 1 dag
(1 bedømmelse)

You can think about my bid.

$30 USD in 5 dage
(0 bedømmelser)

Please see PM.

$100 USD in 30 dage
(0 bedømmelser)

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

$50 USD på 1 dag
(0 bedømmelser)