I tlooks from your description the 2 worksheets are identical except one
displays % and the other displays hours? Then to convert from % to hours you
need to multiply by 40?

You may not need VBA just a simple formula.

if on sh1 cell B7 has 40%, then in sheet2 place the following formula

=40 * sheet1!B7

This formula can be copied to every cell on sheet2 where hours are required.
If you want to skip the cell where 0 is placed then add an if statement

=if(sheet1!B7 < 0,40 * sheet1!B7,"")


You would only need VBA code if the two sheets were arrange differently. I
can't tell how different the two sheets are arranged from the information
provided. when you said the worksheets are dynamically changing. Does that
mean new projects and new team members are beeing added or just the % and
hours changing.
"Reluctant_Programmer" wrote:

Hi All,

I am not very conversant with excel VBA programming but I have a certain
activity to complete which requires me to do that.Currently, I am stuck right
at step one.

I am trying to create a very basic resource/project planning worksheet which
will be dynamically picking up data from another worksheet in the same
workbook. Looks pretty simple but the idea is that there should be some
behind the scene calculations and selections.

To explain:
I have a worksheet which has a listing of team members and what projects
they have been allocated to, and for how much of their time per week (i.e.
40% or 60% of a normal 40hrs workweek). This information can change over a
period of time.

Now I have another worksheet which ideally when opened should list out each
team member, show the project(s) he/she is assigned to, and show the hours
(not % , which means the program picks the allocated % and calculates the
hours and displays that) per week that he/she has to spend on that project.
This should be continuing till the last of the team member has been listed
out.

If anyone can point me in the right direction or provide links to resources
for (hopeless) beginners, it would be a great help.

Thanks!!