I gang

NEED BASIC EXCEL REPORTING SHEET MAYBE VBA / MACRO

HI

HERE IS THE PROJECT.

MY BOSS HAS +/- 40 SHOPS.

THERE ARE +/- 11 MANAGERS.

EACH MANAGER MANAGES +/- 2 TO 5 SHOPS.

EVERY WEEK MY COLLEAGUE RECEIVES AN EXCEL FILE WHERE THE SHOP MANAGERS REPORT ALL THE ISSUES THE SHOP HAVE HAD DURING THE PAST WEEK.

REPORT IS SENT EVERY TUESDAY.

THIS REPORT IS ATTACHED (WEEKLY OUT ADMIN [url removed, login to view]).

MY COLLEAGUE NEEDS TO REPORT ALL THESE ISSUES TO THE CEO ([url removed, login to view]) BUT UNDER THE FORM OF FIGURES.

EXAMPLE:

SHOP XXX HAS WRITTEN ABOUT 2 ISSUES UNDER THE STAFF TO STAFF ISSUES.

MY COLLEAGUE WILL ONLY WRITE THE FIGURE 2 UNDER THE SAME COLUMN AND FACING THE SAME SHOP XXX IN HER REPORT TO THE CEO.

THE CEO REPORT NEEDS TO SHOW HIM:

THE FIGURES PER KIND OF ISSUE/SHOPS FOR 1 PARTICULAR WEEK

AND

THE TOTAL BY KIND OF ISSUE/MANAGER FOR 1 PARTICULAR WEEK

AND

THE TOTAL BY MANAGER FOR 1 PARTICULAR WEEK

AND

THE TOTAL FOR ALL SHOPS FOR 1 PARTICULAR WEEK

AND

THE SAME AS ABOVE BUT INSTEAD OF TOTAL FOR 1 WEEK, SIMPLY TOTAL TO-DATE

AND ALL THE ABOVE IN EASY TO READ GRAPHS THAT AUTOMATICALLY UPDATE WHEN MY COLLEAGUE ENTERS THE NEW FIGURES IN THE CEO REPORT.

IDEALLY: THAT THERE WOULD BE SOME KIND OF "HOOK" BETWEEN THE 2 REPORTS (CEO REPORTS AUTO UPDATE AFTER MY COLLEAGUE FILLS THE FIRST ONE). BUT IF IT IS TOO COMPLICATED (MAYBE BECAUSE MY COLLEAGUE RECEIVES INFO FROM SHOPS UNDER THE FORM OF "STORIES" NOT UNDER THE FORM OF ISSUES...).

I HAVE TRIED TO DO SOME WORK.

IT IS PARTLY DONE. IT MIGHT BE VERY USEFUL AS IT MIGHT BE COMPLETELY USELESS.

YOU WILL FIND THEM ATTACHED.

DO NOT HESITATE TO CHANGE ANYTHING NECESSARY.

REMEMBER:

SHOPS MANAGER SEND THE WEEKLY OUT ADMIN REPORT TO MY COLLEAGUE.

MY COLLEAGUE USES THE WEEKLY OUT ADMIN REPORT TO FILL THE CEO WEEKLY OUT ADMIN REPORT.

THE CEO NEEDS TO BE ABLE TO SEE EASILY AND AUTOMATICALLY (BUTTONS ETC...) THE REPORTS BY:

SHOPS

MANAGER

WEEK

KIND OF ISSUE

AND MAKE ALL KIND OF TOTALS

AND AUTOMATICALLY MAKE ALL KIND OF GRAPHS

IT IS NOT TOO DIFFICULT I KNOW BUT I SIMPLY DON'T HAVE THE TIME ANYMORE.

PLEASE DON'T ONLY TELL ME IN PM "I AM THE BEST", GIVE ME YOUR IDEA OF HOW NICE AND SOLID AND PROTECTED YOU CAN MAKE IT.

THANKS

P.S:

I ALSO NEED THE FREELANCER TO TAKE CARE OF THE DATES.

THE DATES ARE EASY TO INPUT.

IT IS SIMPLY THE DATE OF EVERY TUESDAY OR 2011 (AT LEAST 31/12/2011) AND WHY NOT 2012

THANKS

PRIORITY TO SMALL PRICE AND SUPER FAST RESULT...

Færdigheder: Dataindførsel, Databehandling, Excel, Visual Basic

Se mere: where to write my work in freelancer, where to find freelancer work, where can i write my stories, where can find freelancer to write project, visual basic price, vba freelancer excel, the visual freelancer, super freelancer, staff care, simply done freelancer, reports freelancer, reporting freelancer, project managers freelancer, project manager at freelancer, price for vba for excel, new boss, need info about freelancer, need data input freelancer, need best freelancer, need an freelancer, me excel, i need excel freelancer, i need an excel freelancer, how too update freelancer, how to find your manager

Om arbejdsgiveren:
( 16 bedømmelser ) Salmiya, France

Projekt-ID: #940457

Tildelt til:

sathish2connect

Hi, I can do this task. Will finish the project within deadline. Ready to start now. Thanks.

$30 USD in 3 dage
(3 bedømmelser)
2.0
pavanasamr

Hi Please check your PM.

$30 USD in 3 dage
(1 bedømmelse)
1.6

38 freelancere byder i gennemsnit $171 for dette job

nagybatonyi

Such jobs are my daily practice, please see PMB for details! Regards!

$200 USD in 10 dage
(39 bedømmelser)
5.6
fedalal2

Hi, I can do it.

$140 USD på 1 dag
(32 bedømmelser)
5.5
vbexcel

Ten years Excel / VBA management reporting experience.

$100 USD in 2 dage
(26 bedømmelser)
5.3
anwar01740

@@@@@ Dear sir/madam, Kindly refer to inbox for details of my bid. Thank you, Anwar @@@@@

$30 USD in 10 dage
(49 bedømmelser)
5.2
binaryromel

Lets start. Please check PM. Thanks.

$150 USD in 3 dage
(48 bedømmelser)
5.2
djucuti

Hi, please check PM

$100 USD in 4 dage
(19 bedømmelser)
4.7
dev3dworx

Please check PMB for details.

$200 USD in 7 dage
(19 bedømmelser)
4.7
johnsinit

Dear Ghaylan! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

$125 USD in 2 dage
(18 bedømmelser)
4.2
UltimateJob

Please check PMB. Regards UJ

$120 USD på 1 dag
(8 bedømmelser)
3.7
cdumitru

Hello, I am interested to do this task. Best regards

$50 USD in 2 dage
(5 bedømmelser)
3.2
cheungkc

Hi I have reviewed the sample files provided. Mrs XXX is the manager and sheet tab names are the shops looked after by her. Then it is a matter of counting cells with entries (not blank) with date within the 7 day Mere

$150 USD in 7 dage
(7 bedømmelser)
3.0
yugalgoyal

Hello Sir/Maam, We offer high quality work at most affordable rates. Please see PMB for our expert samples and [url removed, login to view] is an easy job for us.

$50 USD på 1 dag
(2 bedømmelser)
2.6
deeudeec

I can definitely perform this task with ease.

$30 USD in 3 dage
(2 bedømmelser)
2.4
sagnikpal

Hi, I am into excel reporting for executive committee members for large MNCs. Please refer to PM for further details.

$250 USD på 1 dag
(1 bedømmelse)
2.1
NeilSmith1962

Hi I can't open your examples so I'm presuming that the following is (or could be) the case: each shop has its own identifier (name or number) and that the data within identifies the manager. that the spreadshee Mere

$200 USD in 5 dage
(2 bedømmelser)
2.2
neelu7779

hi, I am an expert in Excel VBA. Please check the sample sent in PMB.

$130 USD in 2 dage
(2 bedømmelser)
2.0
pmch

ready to do this work

$150 USD in 7 dage
(0 bedømmelser)
0.0
AnshulNatani

I can do your job fastly and with zero defect.

$150 USD in 2 dage
(0 bedømmelser)
0.0
kkhatri

I am a professional working in an MNC FMCG. Having more than 10 years of professional experience in data management and writing. Freelancing is an addition to my profile besides other works I have. Reliability and Mere

$31 USD in 2 dage
(0 bedømmelser)
0.0
lixai16

ready to do the job sir. please check your pm. thank you.

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