Cancelled

Excel 2010 resources - Formula (not macro) driven

Hello a small, quick and simple job this time:

HAVE A excel 2010 spreadsheet with 3 tabs.

The spreadsheet allocates resources / tasks to a small team

The requirement is to automate searches within the spreadsheet

Tab 1 – Admin

Here is where most data results will appear mandiotry in every search is the search by single date or to and from date fields then select either single or multiple options of:

Search by team, staff name, task or skill ( you can chose multiple)

Every cell highlighted in Yellow means this is a answer that should come up in search results or with a formula

Row J-M WILL show results for the above.

====================================

Tab 2 Resources Tab

Column F will show today’s tasks (Just a vlookup from the date section (column H onward)

From column H onwards dates will always be 1st July – 30 June

as per colour key - colour to auto fill when text is input into resource chart - NOTE when word "Project" appears - colour will ALSO appear with partial word eg: Project cat, project dog, project x - will all reflect the conditional colour

If a new task type is entered in H-nk on sheet 2 "resource" then also B82 key should reflect this new type

Keep row 1 and 2 frozen as well as row A-G

====================================

Tab 3 Daily stats tab

Collect team resources by day (excluding leave) team, FTE, annual leave, % not BAU

====================================

Tab 2 Skills

ALL SKILLS DATA FOR THE SEARCH ON “ADMIN TAB” A 7 WILL FEED FROM HERE – UPTO 20 SKILLS PER PERSON

====================================

PLEASE NOTE:

Sample DATA available on request

Needs to be completed within 48 hrs

Prefer formulas and NO MACROS so I can use on SHAREPOINT

ONLY respond if you have read email and can show me sample of your excel work

Skills: Excel

See more: sharepoint job, onward search, job with excel skill, excel macro to word, answer tab, 0.7 fte, text macros, task driven, excel spreadsheet formula, excel sheet formula, Vlookup, simple macro, sharepoint word, sharepoint admin, Resources, fte, excel work today, excel vlookup, excel stats, excel automate, email multiple tabs, excel formula spreadsheet spreadsheet, excel colour, excelchart, automate data feed

About the Employer:
( 11 reviews ) sydney, Australia

Project ID: #6170689

14 freelancers are bidding on average $43 for this job

zExcel

A proposal has not yet been provided

$55 AUD in 1 day
(87 Reviews)
6.3
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this reg More

$29 AUD in 3 days
(33 Reviews)
5.4
MDavidCrompton

Sorry to bid so high but from the very full description you give the budget is too low. There is at least 6 to 8 hours work in it. I have been developing applications in both Access and Excel for 20 years with extensiv More

$130 AUD in 7 days
(26 Reviews)
5.0
ethicalboy

Hello ready to start asap to deliver you, I am thinking to use vlookup, hlookup and also conditional formatting but need to see your file and If you can give me your notes and conditions, I can deliver it to you fast, More

$38 AUD in 2 days
(40 Reviews)
4.8
MuradMurad

A proposal has not yet been provided

$45 AUD in 1 day
(5 Reviews)
4.6
JonNxt

Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing code / debugging Excel VBA code. You may check my More

$29 AUD in 2 days
(13 Reviews)
4.1
Midlander

I can finish this within two days, providing you pay the fee into the site today. I will also need the sample data to get a better picture of what you want, because you said there were three tabs, and then described fo More

$98 AUD in 1 day
(7 Reviews)
4.1
elqueabandona

Hello, my name is Cristian, I have a degree in Business and I am Financial Advisor. I also work with excel every day. I have a lot of experience creating and modifying spreadsheets, working with complex formulas. Chat More

$30 AUD in 1 day
(12 Reviews)
3.9
toxicman

Hello I'm a software engineer with good knowledge in excel I can help you to do this without macro or with it, please check my reviews and if you need i can send you my work sample too.

$25 AUD in 1 day
(13 Reviews)
4.0
vjmakwana

A proposal has not yet been provided

$25 AUD in 1 day
(1 Review)
2.3
mdmaroufb

Hello sir, I am new at freelancer but I have 12 year experience about data entry, Analyzes, excel, data processing, prof reading These type of work. I have a Cybercafe at my country there are some computer and English More

$25 AUD in 1 day
(3 Reviews)
1.4
sharmilaa1

A proposal has not yet been provided

$25 AUD in 1 day
(2 Reviews)
1.4
syedasadrizvi1

Hello! I have vast experience in this field, I am willing to offer my services for this project. Please let me know about further details. Looking forward to hear from you soon. Regards,

$25 AUD in 2 days
(0 Reviews)
0.0
yenlyn

A proposal has not yet been provided

$25 AUD in 1 day
(0 Reviews)
0.0
zulfiqarbadiana

A proposal has not yet been provided

$25 AUD in 1 day
(0 Reviews)
0.0