Macro for Calculating Productivity

[Aswinraj]

Hi Guys,

I have created a Macro to calculate productivity per day. ie., In Sheet "Raw Data" - i will copy paste the data and click "RUN" in Output sheet. So that it will calculate the Productivity. But i need to do it for whole month.., So please help me to finish this.

Input: File 1 - Productivity Data , File 2 - Productivity Macro

In a Folder i have both above files.

In productivity macro -> Output Sheet -> When i press "Monthly data" it has to process following steps,

Step 1 - It has to open FILE 1 -> Filter 1 Date -> Copy all -> Paste it in Productivity Macro "Raw Data" -> Click "RUN" in Output sheet.


Step 2 - Based on Employee ID in "Output" Sheet - it has to Vlookup with Employee ID in "Monthly" Sheet and copy the "Actual" (Column D) from Output to "Monthly" Sheet.

(Same steps needs to be repeated for all Dates in "FILE 1" (Productivity Data))

Example: when we click "Monthly Data" button -> If 1st February was filtered from Date (File 1: Productivity Data) and Copy items to "Raw Sheet (File 2: productivity macro) - From Output sheet the "Actual" needs to be updated in "Monthly" In Column D2 (D1 Column name should be 1st Feb)

And Goes on....

Please help me guys.., I couldnt find the solution for this.

 

[Aswinraj]

Can someone please help me...,

 

[Marc L]

Hi !

First use worksheet formulas …
If really a code is needed, activate Macro recorder and do it manually :
you will get your own free code !
If you need some code optimization, join here this generated code
and crystal clear explain what you expect …
​

 

[Aswinraj]

Hi

Initially we were using some Worksheet formulas which our team not able to work comfortably. So I am searching for macro coding to complete the remaining task since i completed almost.

STEP 1: Filter Single Date and Copy paste the data from Workbook 1 to Workbook 2.

STEP 2: Once copied, Move to "Output" Sheet and Click "Run" Button.

Hope this is clear on what i expect..,

 

[Marc L]

So as yet written :

activate Macro recorder and do it manually :
you will get your own free code !

As worksheet formulas are often more efficient than a gas factory VBA code,
the reason why even within a VBA code you can see formulas used …
​