copy data from a range in multiple sheet to master sheet

Hi,

I have searched in almost all the forums, but i have not been able to achieve what i need. I have to create a work sheet for my manager where he will assign different task/projects to us, and the same would be a updated in a shared file kept in our common DIR thus whenever we open we can view our individual sheets view the task assigned and update accordingly.

Now, i have already created a Master sheet where task assigned gets populated on individual sheet but i am stuck at is how get the master sheet updated for column (Status) & column(update) when we update our sheets in column (F) & column (G) the same needs to be updated on master sheet ?

Formula/macro anything is it possible?

Attach the following code to a update on the Master worksheet. You cannot use vllokup on this problem since it will cause an almost circular reference and the individual worksheets will loose their data.

Please Login or Register  to view this content.