I have a workbook I made that the other PM's in my office use as well. It has several worksheets and I want to add
to it so our jobs have everything in it's own workbook and not need different workbooks.
Here is what I want to do and I was wondering if Access can help me achieve this.
When we do change orders, we have a different excel sheet for that. On average, we can have around
30 change orders per job. Each change order workbook has 4 work sheets. Instead of having 30 different files,
I want to have it so when we make a change order, it saves the entered info into the job "database", and when needed, can be pulled back up again. This way, we have one workbook, and I can have a menu that you pull down, select the change order number, and it fills in from the database.
I assume this would keep the workbooks down and size as well. Is this how access works? I can totally re do my entire workbook I created to make it more streamline!
to it so our jobs have everything in it's own workbook and not need different workbooks.
Here is what I want to do and I was wondering if Access can help me achieve this.
When we do change orders, we have a different excel sheet for that. On average, we can have around
30 change orders per job. Each change order workbook has 4 work sheets. Instead of having 30 different files,
I want to have it so when we make a change order, it saves the entered info into the job "database", and when needed, can be pulled back up again. This way, we have one workbook, and I can have a menu that you pull down, select the change order number, and it fills in from the database.
I assume this would keep the workbooks down and size as well. Is this how access works? I can totally re do my entire workbook I created to make it more streamline!