Change Roster values

**ohlalayeah** · 06-10-2012, 11:37 PM

Wow! I like this so much! But I am using Excel 2003, can you post a workable roster file for me here?

**jaslake** · 06-10-2012, 11:52 PM

Hi ohlalayeah

See this rule...act accordingly
2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread

**Bloodywog** · 02-07-2013, 07:17 AM

jaslake

The spreadsheet is working beautiful! Few changes along the way but it's saved me sooooo much time. Many thanks.

I have few more questions. I didn't see any ruling regarding this. Can you help me out?

**jaslake** · 02-07-2013, 11:11 AM

Hi Bloodywog

I know of no rule that prohibits this

I have few more questions. I didn't see any ruling regarding this

However, this is a rather old Thread. I'd recommend you start a new Thread with your questions...you'll get much more Member interest. Add a link to this Thread if relevant.

Or, if related to this Thread...ask away.

**Bloodywog** · 02-08-2013, 03:41 AM

Hi jaslake

Or, if related to this Thread...ask away.

I do understand but I hope it's not too much trouble.

I just like to add an additional sheet (LineSwap) to the spreadsheet we did. Using VBA, when staff take leave, the relief staff covering leave will automatically updated to roster. The relief staff will cover his "line" (shifts) while away. For this example,I manually updated the roster to show you. The update cells are in RED. I understand some days (before&after) may have to manually done. I accept that.

Due to confidential information, I created a new sheet with additional sheet (LineSwap). All the codes in my current spreadsheet works great. I'm stuck.. I can't tell excel to replace "a" specific shift without doing my head in.

Let me know if you have any questions.

If I don't get much member interest, I will post a new thread.

Thanks.