ExcelBanter - Rather Complicated Process...

My temporary job at the moment basically consists of working with one
excel file. This file being work allocations.

I have to keep the columns of the end and start dates of projects in
line with the days people have been allocated to work on them. The
allocation columns are graduated in weeks, and a number is entered
under the week and next to the person corresponding to how many days in
the week that person is intending to spend on that project.

What i would really like is a macro that, when executed on the final
allocated week spot, would look to the top of the sheet, copy the week,
return to the original row, go left and paste that value into the
"Scheduled finish date" column.

The problems i've encountered in doing this is that it needs a
combination of relative and absolute references. For example, the week
is always in row 3, but the macro needs to be able to slide along to
different columns. While the "Scheduled finish date" is always in
column T, but needs to be able to slide up and down to go to different
people.

It's quite possible that all of the above made no sense to anyone, in
which case please say. Otherwise, could someone help me a template with
which to build a macro that could do this?

Many Thanks, Tom.

--
JamAlarm
------------------------------------------------------------------------
JamAlarm's Profile: http://www.excelforum.com/member.php...o&userid=37028
View this thread: http://www.excelforum.com/showthread...hreadid=567505