Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rather Complicated Process...
Let's give that a bump.. -- JamAlar ----------------------------------------------------------------------- JamAlarm's Profile: http://www.excelforum.com/member.php...fo&userid=3702 View this thread: http://www.excelforum.com/showthread.php?threadid=56750 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
way to automate this process | Excel Discussion (Misc queries) | |||
Time to process | Excel Discussion (Misc queries) | |||
If/then Process? | Excel Discussion (Misc queries) | |||
How to count process running time ( process not finished) | Excel Programming | |||
How to count process running time ( process not finished) | Excel Programming |