Update Excel Workbook
- or -
Post a project like this- Posted:
- Proposals: 10
- Remote
- #1326448
- Expired
Description
Thanks
Extra notes:
Saqib A.
100% (62)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
THANK YOU FOR THE INVITE. I HAVE GONE THROUGH YOUR FILE WHICH IS MORE FORMULAS. I FEEL THAT THE WHOLE FILE CAN BE SIMPLIFIED AND MADE TO EASY TO WORK FILE.NEED YOUR TIME TO HAVE DISCUSSION ON THIS AND MORE ACCURATE UNDERSTANDING BEFORE I PROPOSE SOMETHING.
DELIVERY OF THE PROJECT WILL BE 100% PROFFESSIONAL AND IN THE TIME FRAMES AGREED. -
Hi,
Are you still looking for someone to complete this?
Regards,
Ash -
Dear Saqib,
Do you mind if I change a little bit on the file? Here is my thinking:
1. Build input tabs for each month to input the data, like what you currently key in at column AO - AW. These tabs are purely for input data.
2. Month tab change to "Report" will be purely formulas to extract data from input pages, both current and last week. Thus, no more macro needed to copy and paste to last week.
3. All trend lines built at right side of the "Report" table.
4. There will be 12 months input tabs, thus only one report tab required. This page is a powerful page with spin button built in. When you click at the spin button, it will spin to the required months, and the numbers will updated accordingly. As mention at 2 above, this page is all formulas.
5. Instruction tab will remain, but additional need to be built in, as and when you move to a new year, you need to change the year.