Management Tool help

AniKaur

New Member
Joined
Oct 17, 2014
Messages
14
Hi

This may get complicated so please be patient with me. A management tool was developed to track staff performance. There are three tabs that my administrator will paste information into which is extracted from our different onlinr management systems. There is a tab that automatically populates when all information is pasted into the other tabs. The problem is, that not all the information can be extracted from our various systems, so we have a few fields that are required to be completed manually.
Now each of my team are requested to maintain their own performance, if the admin copy and pastes the information in from the systems, is there a way for the fields that staff have entered manually, to generate automatically without having to re-enter again? And also be able to add this information for rows they did not have the info available for before?

All help appreciated

Ani
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top