Help with Deciding how to go about
Closed
nksoni
Posts
7
Registration date
Thursday 8 July 2010
Status
Member
Last seen
19 July 2010
-
8 Jul 2010 à 20:30
nksoni Posts 7 Registration date Thursday 8 July 2010 Status Member Last seen 19 July 2010 - 12 Jul 2010 à 18:44
nksoni Posts 7 Registration date Thursday 8 July 2010 Status Member Last seen 19 July 2010 - 12 Jul 2010 à 18:44
2 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
8 Jul 2010 à 20:38
8 Jul 2010 à 20:38
you need a macro. a small extract of the four sheets may be uploaded to
www.speedyshare.com without password.
www.speedyshare.com without password.
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
11 Jul 2010 à 21:42
11 Jul 2010 à 21:42
I have downloaded the file "vendor work model.xls" and saved in my computer.
I read your first messge. It is not clear what you want? Give some examples.
For e.g in the sheet "projects" again Project A and High the value is 6 in the cell C2. the start date is april 10 and the end date is Jun 10. I presume vendor name is not relevant.
Now go to the sheet"high". In this sheet it is not clear which is start month the columnA or row 5 and which is the end month . what is to be done with this 6??????
Give one more example also.
What is that sheet called "work data"
Can you clarify all the pints and also give any additional points which can help me to write the macro. clearly what is in your mind.
Greetings.
I read your first messge. It is not clear what you want? Give some examples.
For e.g in the sheet "projects" again Project A and High the value is 6 in the cell C2. the start date is april 10 and the end date is Jun 10. I presume vendor name is not relevant.
Now go to the sheet"high". In this sheet it is not clear which is start month the columnA or row 5 and which is the end month . what is to be done with this 6??????
Give one more example also.
What is that sheet called "work data"
Can you clarify all the pints and also give any additional points which can help me to write the macro. clearly what is in your mind.
Greetings.
nksoni
Posts
7
Registration date
Thursday 8 July 2010
Status
Member
Last seen
19 July 2010
11 Jul 2010 à 22:28
11 Jul 2010 à 22:28
Hello,
Thank u so much venkat
i have Projects where complexity of projects and vendor are given
depnding upon the complexity i have to drill data from the specfied work sheets
the ref would be start month/duration or if its simple it may be end of the month
and then copy that to new worksheet possibly for every vendor
This would tell us generically how much is the vendor busy in a time peroid which would be drawnn using graphs thats the whole idea behind it
In Regards to the work data im sorry to confuse u i was trying to work on that so it should be blank instead of data on it
Configuration: Windows XP / Firefox 3.6.6
Thank u so much venkat
i have Projects where complexity of projects and vendor are given
depnding upon the complexity i have to drill data from the specfied work sheets
the ref would be start month/duration or if its simple it may be end of the month
and then copy that to new worksheet possibly for every vendor
This would tell us generically how much is the vendor busy in a time peroid which would be drawnn using graphs thats the whole idea behind it
In Regards to the work data im sorry to confuse u i was trying to work on that so it should be blank instead of data on it
Configuration: Windows XP / Firefox 3.6.6
11 Jul 2010 à 20:35
https://authentification.site/files/23342101/Vendor_Work_Model.xls
This is the link for sample worksheet data
Please help me to find a direction
Read so many books but really didnt help me to have my task done
12 Jul 2010 à 18:44
is it possible to do this kind of thing, can you tell me some books or some site sample projects so that i can get this task done