Excel VBA macro automation
- or -
Post a project like this4003
$$
- Posted:
- Proposals: 6
- Remote
- #240359
- Completed
Automation Expert,web designer,SEO Practitioner, Oracle PL/SQL developer, Windows desktop app developer(C#, sql server)
Stanmore
Microsoft ASP.Net, C#, Deskto application and Web developer. Office application expert.
Scarborough
4281564346117676351470381767426214
Description
Experience Level: Intermediate
There are 4 excel sheet in one workbook
1) Summary sheet
2) Projections (Mar 18 - Mar 31)
3) Actuals (Mar 18 - Mar 31)
4) Projections (Apr 1 - Apr 15)
Summary sheet gets value from other 3 sheets
Please note- values in green coloured columns in summary sheet are input given manually and values in all other sheets are manually given except summary sheet where automation is to be done
I want to develop a macro in such a way
Step 1 ( button 1)
Create new projection sheet (Projections april1 –April15) and and transfer data into summary sheet table 4 (projection april 1 april 15)
note dates are picked from projection sheet (CI-CJ) columns
Step 2
Transfer data from projection sheet (april 1 – april 15 ) to summary sheet 4 table
Step 3 button 2
Copy data from summary sheet 4 table (april1 – april 15 ) to summary sheet 1 table march 18 –march 31 and clears data from actual and variance table in summary sheet and creates a new table 4 in summary sheet with dates april 18- april 30
and also create new actual sheet
1) Summary sheet
2) Projections (Mar 18 - Mar 31)
3) Actuals (Mar 18 - Mar 31)
4) Projections (Apr 1 - Apr 15)
Summary sheet gets value from other 3 sheets
Please note- values in green coloured columns in summary sheet are input given manually and values in all other sheets are manually given except summary sheet where automation is to be done
I want to develop a macro in such a way
Step 1 ( button 1)
Create new projection sheet (Projections april1 –April15) and and transfer data into summary sheet table 4 (projection april 1 april 15)
note dates are picked from projection sheet (CI-CJ) columns
Step 2
Transfer data from projection sheet (april 1 – april 15 ) to summary sheet 4 table
Step 3 button 2
Copy data from summary sheet 4 table (april1 – april 15 ) to summary sheet 1 table march 18 –march 31 and clears data from actual and variance table in summary sheet and creates a new table 4 in summary sheet with dates april 18- april 30
and also create new actual sheet
Rahul K.
95% (4)Projects Completed
3
Freelancers worked with
3
Projects awarded
43%
Last project
14 Jun 2014
India
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies