Create Formula's in Excel Workbook

Ukończone Opublikowano Mar 2, 2014 Płatność przy odbiorze
Ukończone Płatność przy odbiorze

I have created a basic workbook that I require formulas and functions to link sheets.

Tab 1 - Summary.

Tab 2 - Details

Tab 3 - Open Action Items

Tab 1 - Summary

I would like a page that illustrates the list of items specified. This should be in a table and graphs.

Tab 2 - Details

This is where all mannual data will be entered. Other two tabs will rely on this tab for data input and formula/function linking

Tab 3 - Open Action Items

If an item is specified as being "Open" in Tab 2 "Details", column "I" then I will need a function to link this to Tab 3 "Open Item"

If possible when an Open Action Item is closed in Tab 3 - "Open Items" in Column "H" then I would like it to then enter the word "Closed" in Tab 2 "Details" Coumn "I"

Excel

Numer ID Projektu: #5507212

O projekcie

2 ofert Zdalny projekt Aktywny Mar 2, 2014

Przyznany użytkownikowi:

k00lcaptchrz

Hi , I have experience in excel. Kindly come on PM so we can discuss and start it right now . waiting for your message . THanks Kool

$12 AUD w 1 dzień
(4 ocen)
3.1

2 freelancerów złożyło ofertę za $31 w tym projekcie

zExcel

Hi, I will be happy to help you with this now if you're ready. ------------------------------------------------------------------------------------------------------

$50 AUD w ciągu 1 dnia
(48 Oceny)
5.7