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, 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, macro, macro excel, macro + excel, excel guru, data entry job in microsoft excel

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

Projekt-ID: #958669

Tildelt til:

bharanisrihari

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

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

9 freelancere byder i gennemsnit $57 for dette job

koolsidz

Please see PMB

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

Ten years experience.

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

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

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

Hi, I am interested in this project

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

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)
1.9
masoftware

You can think about my bid.

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

Please see PM.

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

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

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