T
Tacrier
I have limited, beginner VBA knowledge and have been researching online for
ways to create an excel 'database' for employee attendance (worked time,
holidays accumulated/used, overtime accumulated/used, other types of leave
accumulated/used, etc).
My research has led me to the idea of using Personal.xls by creating a
Summary workbook to show all data from several sheets (1 sheet per employee).
I was going to continue reading up on it but I didn't bookmark the page!
(doh!).
Is Personal.xls only for storing macros? Or can I put the employee data
sheets in Personal.xls and use this workbook to enter my time data? I read
somewhere (but didn't bookmark the page - doh!!) that it could be possible to
have a Summary workbook that links to a "workbook that is always open" i.e.
Personal.xls. Is this possible?
Also, if I do use the Personal.xls could I then put the Summary workbook in
a network folder that is accessible to another staff member and still link
correctly to my Personal.xls?
All help is greatly appreciated. Thank you!
Trina
I am using Excel 2007. Further to my question, can I put my Summary workbook
in a network folder to be used by another employee and still have the Summary
workbook refresh it's data based on my Personal.xls contents?
All help/ideas is greatly appreciated!!
ways to create an excel 'database' for employee attendance (worked time,
holidays accumulated/used, overtime accumulated/used, other types of leave
accumulated/used, etc).
My research has led me to the idea of using Personal.xls by creating a
Summary workbook to show all data from several sheets (1 sheet per employee).
I was going to continue reading up on it but I didn't bookmark the page!
(doh!).
Is Personal.xls only for storing macros? Or can I put the employee data
sheets in Personal.xls and use this workbook to enter my time data? I read
somewhere (but didn't bookmark the page - doh!!) that it could be possible to
have a Summary workbook that links to a "workbook that is always open" i.e.
Personal.xls. Is this possible?
Also, if I do use the Personal.xls could I then put the Summary workbook in
a network folder that is accessible to another staff member and still link
correctly to my Personal.xls?
All help is greatly appreciated. Thank you!
Trina
I am using Excel 2007. Further to my question, can I put my Summary workbook
in a network folder to be used by another employee and still have the Summary
workbook refresh it's data based on my Personal.xls contents?
All help/ideas is greatly appreciated!!