Excel 2010 resources - Macro and vlookups

Hello a small, quick and simple job this time:

HAVE A excel 2010 spreadsheet with 3 tabs, It allocated DAILY resouces and requires much manual upkeep.

I want it automated with the following:

Sheet 1 - Admin

Resources allocation spread sheet that can be

Search by Single date (select from calendar)

Seach by to & From date (select from calendar)

Search by Team (all teams found in column e)

Search by Name (all name found in column B)

Search by Task (all tasks found in column h - Nj

Provide a "daily" view of name, position, team

Sheet 2 - Resources

Column d1 to show last edit date

Column e1 to show last editor name

Column f1 to show todays date

Change currently "Weekly date format to daily dates (1 day per column)

as per colour key - colour to auto fill when text is input into resource chart - NOTE when word "Project" appears - colour will appear with partial word eg: Project cat, project dog, project x - will all reflect the conditonal 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

sheet 3 Daily stats

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

Sample available on request

Needs to be completed within 24 hrs

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

Evner: Excel

Se mere: want excel spread sheet, nj job search, job search nj, job seach, job in nj, excel macro to word, task allocation, simple macro, Resources, macro e, job search editor, h and h, fte, fill in spread sheet, fill in a spread sheet with, excel stats, work allocation macro, spread sheet fill, excel colour, edit macro, excelchart, editor excel, calendar resource view, excel macro row, spread chart

Om arbejdsgiveren:
( 11 bedømmelser ) sydney, Australia

Projekt ID: #6042785

11 freelancere byder i gennemsnit $33 på dette job


Hi, Let me introduce myself as an expert on Excel. I am also well versed with creation of macros in Excel using VBA. I have used many advanced features in Excel for creation of Dashboards, charts, Pivot tables etc.. Flere

$25 AUD på 1 dag
(23 bedømmelser)

Excel and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [url removed, login to view] Estate (video demonstration) [url removed, login to view] (video demonstrat Flere

$150 AUD in 3 dage
(20 bedømmelser)

Hi , I have done alot of excel projects . You can check my profile. I have read Your project description and Ready to start work on your project right now. Looking forward to hear from You soon. so we can move on Flere

$29 AUD på 1 dag
(21 bedømmelser)

Greetings! I have full command over Microsoft Excel and I am 100% confident of completing your task within a day. I have some excel reviews which will give you an idea of my proficiency at Excel. Expecting a positive r Flere

$25 AUD på 1 dag
(3 bedømmelser)

A proposal has not yet been provided

$15 AUD på 1 dag
(0 bedømmelser)

I can help you 24 hours a day, 7 days a week and I am ready to solve any problem, or answer any query you may have immediately. * Data Entry * Research * Word Processing * Virtual Assistant * Personal Assistant Flere

$11 AUD på 1 dag
(0 bedømmelser)

Hi, sir. I think i am an expert in excel and word. if you contact with me, you will know my typing speed is very good. i can do it fast, correct. regards.

$25 AUD på 1 dag
(0 bedømmelser)

I M WORKING IN DAWLANCE COMPANY as a accoutant so i work daily on excel so its very easy for [url removed, login to view] me this project

$25 AUD på 1 dag
(0 bedømmelser)

Dear Sir I am ready to do this project. I am experienced in excel. I can assure that you will 100% satisfied by my work.

$10 AUD på 1 dag
(0 bedømmelser)

A proposal has not yet been provided

$20 AUD på 1 dag
(0 bedømmelser)

Excel Macros are my specialty and I will give quality work within the 24 hour time frame at a reasonable cost.

$25 AUD på 1 dag
(0 bedømmelser)