Editing cells in multiple worksheets

[cjgraham92]

Hi all,

I have a tough one. I have two worksheets; Projects in Delivery and Role Utilisation. In projects in delivery I have titles starting in column A as follows


PROJECT | NAME | REGION | ROLE | DESCRIPTION /COMMENTS | START | FINISH | ALLOCATION | INITIAL |

Project A | John Smith | South | PM | - | 1/1/15 | 21/12/15 | 1.0 | JSmi |
Project A | Barry Charles| South | PM | - | 1/1/15 | 21/12/15 | 1.0 | BCh |
Project B | John Smith | South | PM | - | 1/1/15 | 29/8/15 | 0.5 | JSmi |


In the second worksheet; Role Utilisation the data is as follows

NAME | ROLE | BLANK COLUMN | BLANK COLUMN | INITIAL | 23/8 | 30/8 | 6/9 |
John Smith | PM | blank | blank | JSmi | 1.5 | 1.0 | 1.0 |
Barry Charles | PM | blank | blank | BCh | 1.0 | 1.0 | 1.0 |

The dates in the tab called "Projects in delivery plots out the dates as shown according to their allocation. If a person is allocated to two projects as shown on example, their name will appear on both projects as seperate lines. The role utilisation sheet summarises each persons allocation as you can see, John smith had a 1.5 allocation on the 23/8 as he had a 1.0 allocation on project A and a .5 allocation on project B.

What I want to be able to do is automatically transfer the names, role and initial from the worksheet "projects in delivery" into "role utilisation" so whenever a new person is added into projects in delivery, it is automatically inputted into role utilisation.

[xladept]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic