josephm
06-06-2008, 08:30 AM
I have an excel workbook that i am designing for some users
i have attached the file i am developing with sample data
here are the requirements.
The workbook will be updated by different users at any time.
the sheet named ''enter information here'' is where each user will enter their information.
The sheet name Summary will pull information from the ''enter information here'' sheet whenever a user adds their information.
the issue now is to remove any duplicate names from the summary sheet, show multiple start and end dates and the total number of days
i want to create a chart from the summary data. but the duplicate are an issue.
so for example:
''Information Systems'' wants to go on vacation three times, thus they are 3 start dates and 3 end dates respectively.
one the summary sheet i need to see
''information systems'' once
3 start and end dates
1 total days value for ''information systems''
how do i use vba to achieve this and still allow the summary sheet to collect the required data form the ''enter information here'' sheet?
i tried using the deletedups macro to delete the duplicates
but it also deletes the sheet references and then when new information is put-in it is not passed to the summary sheet.
i really need help
i have attached the file i am developing with sample data
here are the requirements.
The workbook will be updated by different users at any time.
the sheet named ''enter information here'' is where each user will enter their information.
The sheet name Summary will pull information from the ''enter information here'' sheet whenever a user adds their information.
the issue now is to remove any duplicate names from the summary sheet, show multiple start and end dates and the total number of days
i want to create a chart from the summary data. but the duplicate are an issue.
so for example:
''Information Systems'' wants to go on vacation three times, thus they are 3 start dates and 3 end dates respectively.
one the summary sheet i need to see
''information systems'' once
3 start and end dates
1 total days value for ''information systems''
how do i use vba to achieve this and still allow the summary sheet to collect the required data form the ''enter information here'' sheet?
i tried using the deletedups macro to delete the duplicates
but it also deletes the sheet references and then when new information is put-in it is not passed to the summary sheet.
i really need help