Excel Forum

Resource Wise Activity and Overall time Taken to Complete the Activity

Nishith Srivastava

New Member

Members

Forum Posts: 1

Member Since:
June 28, 2020

Offline

June 28, 2020 - 5:11 am

I am trying to prepare a tracker sheet in which i have 5 Resources(Can Be Dynamic) and each resource has its own set of activities (Document Deliverable) .

a) While filling the Activity sheet resource name should be available from Drop Down - Currently DOne.

b) List of Activity should get populated as per the Matrix -Currently DOne.

c) In the same worksheet if the dropdown (a) is change then the hours assigned remain same and should change as per the new resource so that finally overall hours consumed per activity in a month shall be available.

Anders Sehlstedt

Eskilstuna, Sweden

VIP

Members

Trusted Members

Forum Posts: 870

Member Since:
December 7, 2016

Offline

June 29, 2020 - 2:45 am

Hello,

I would suggest that you gather the data in a tabular format, as you then can use that data to feed Pivot Tables / dashboards. Gives you lots of flexibility and dynamic updates.

Br,
Anders

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Ngoc Tinh

Guest(s) 9

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

michael serna

mashal sana

Tiffany Kang

Leah Gillmore

Sopi Yuniarti

LAFONSO HERNANDEZ

Hayden Hao

Angela chen

Sean Moore

John Chisholm

Forum Stats:

Groups: 3

Forums: 24

Topics: 6215

Posts: 27248

Member Stats:

Guest Posters: 49

Members: 31897

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen