NEED DYMAMIC DATE INSTALLED INTO ARRAY
NEED TO ACCESS MULTIPLE SHEETS
hi everyone im new to excel but had the challenge at to devise a work rota with names down the left column and days across the top from left to right with what shift each person is i.e. EARLYS,MIDDLE,LATE,DAY OFF,SICK. now I have got an array formula which lists the names in the correct table for the first row. but this is not interactive with the date. what do I need to add to the array to make a dynamic "date"????? please help
first you need to see answers to your other post here
http://www.excelforum.com/excel-new-...amic-date.html
please do not post the same question in two places
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks