Simple question...

[ArisZ]

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!

 

[ranman256]

IF every workbook has the same tab names
then you can save 1 workbook as a generic file..like File2Import.xlsx
then in access, attach (link) all 4 sheets as external tables.
build a macro that imports each sheet.

Then you just,
select the next file, save as File2Import.xlsx
run import macro.
done.

 

[ArisZ]

IF every workbook has the same tab names
then you can save 1 workbook as a generic file..like File2Import.xlsx
then in access, attach (link) all 4 sheets as external tables.
build a macro that imports each sheet.

Then you just,
select the next file, save as File2Import.xlsx
run import macro.
done.

Not quite sure I follow. Let me explain it better.
Right now, I would have a folder, called Change Order #01. In that folder is the excel sheet we use. Any time we add a Change Order,
we make a new folder and copy the file over and fill in the needed info.

Every Change order has a copy of the file (Template) and the info we fill in. I only want to have one file (Template) that I can put a menu
in that let's you select the CO# you want to work with, and have it fill in the user info automatically. Now we would just have a Change Order
File, and we can select from within which number we are to work on.

Does that make more sense?

 

[ArisZ]

Anyone?