Im working as data analyst in volkswagen

[logesh96]

Hi everyone
This is logesh

[arlu1201]

Hello logesh96,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

[logesh96]

Hi guys
good day

If anyone can slove this problem I can claim you money for this macros work, you will get 300€ after work.

Below im attaching my problem please help to create a macros for this.



These are the steps which I need to perform in this task

Steps:

1.create a sheet(1) with information structure and collect particular data from that(data base)server .

2."Datamining" look for particular data (part number)

find parameters such as (part number, calendar weeks, demands) and copy to sheet (1).

final step create (sheet 2) and cope the collected data from the sheet 1

3. "comparison/ report" sorting out data by part number (like grouping) and create (sum vs capacity & difference{capacity-sum})


we should prepare macro when someone runs this program it should perform this task and give like a report.( database changes every week) main aim is to find the
critical week with demand.

below im attaching the sample and macros which I have done(cant solve that help me )


thank you in advance

have a great day


best regards
logesh