• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

i need help with the following plz

M

mohammed saeed

New Member
hi all
thanks in advance
i was making a file list contains the employees name and another sheet contains job activities with it's date and project name and another yearly calender to refer each employee to his work on the calender with the referenced project name from the project plans list but i couldn`t refer all these i don't know what i have missed if any body can help.
 

Attachments

Hi Saeed ,

I am not able to understand what you want ; since you have uploaded your file , with respect to the file , can you say exactly what you want done , with specific references to sheets / columns / cells ?

Narayan
 
hi narayan ,
Thanks for your reply and sorry for that
i will try to explain as much as i can in details ,
from the "project plans" sheet in need column c6 named start Date to Add D6 column named duration to get the sum in new column called for ex end date the to get employees names in H6 named "done by" column in the same as a drop down menu sheet from B2 column in "sheet1"
i need all these data to be arranged and filled automatically in jan - feb -mar .... etc sheets as follows :
A5 column in jan sheet to get the B2 column from sheet 1 then fill each "employer name" row in "jan" sheet with the start to end date we got from "project plans sheet" so by that the calender fills automatically as a time line for each employee .
i wish i could explain it well
thanks in advance
 
Hi Saeed ,

No problems with your explanation ; the job is a time-consuming one ; I hope someone else will take it up.

Narayan
 
thanks narayan and if you don't mind just post general tutorial links for me to just read and utilize it or give me head points and i will read it
thsnkd
 
-For the "Ex- End date" col,: Simply add a column startdate+duration and format it same as the start date format
-For the Done by Col: Add a data validation(Alt+D+L+L), select the list option and select the desired range from Sheet1

I dint understand the later part about adding the employee names to the Month Sheets, how will the calculations be(depending upon the activity, days worked,etc..)
 
hi Abhijeet R. Joshi,
thanks for your reply ok i got the part you said now the thing that i could not do or even know how to do or which functions to do with is the other part in which i have list of employees and list of tasks done by some of these employees so i need to fill a monthly calender by this tables automatically not like what i have made manually so if X employee worked from 12-12-2012 to 20-1-2013 for example in one of the tasks i need this to be filled opposite to his name in the monthly calender i made it in the file i attached but manually but i need it to be automatically done from the tables i fill
 
You must log in or register to reply here.
Back
Top