I currently am using excel for my preference at this time but I was wondering
if there may be a more compatible program to what I am doing?

I have a workbook for each job which contains 6 worksheets each.
(Job record, quote, wages, Takeoff, Invoice, Change Order) I enter multiple
data into several of these worksheets, I have set some of them up to link to
each other for some of the information needed for all.

I was wondering if another program (access, project etc) may be more
compatible and easier for setting up for what I am doing. I keep track daily
of jobs and there activity and entered information in daily also.

Thanks
tb

Not sure whether this will help, but
It sounds like an awful waste to use a sheet per category, as you state.
Why not create ranges on the first sheet to accomodate all these sections?
You could then create a template file, and have all the basic info available
everytime you start a new document. Each file will however be updated with
its own unique info, and saved e.g. as a job number.

If this does not solve your problem, we would need more info, before we can
give real advice.

"tb" wrote:

I currently am using excel for my preference at this time but I was wondering
if there may be a more compatible program to what I am doing?

I have a workbook for each job which contains 6 worksheets each.
(Job record, quote, wages, Takeoff, Invoice, Change Order) I enter multiple
data into several of these worksheets, I have set some of them up to link to
each other for some of the information needed for all.

I was wondering if another program (access, project etc) may be more
compatible and easier for setting up for what I am doing. I keep track daily
of jobs and there activity and entered information in daily also.

Thanks
tb

What do you mean by ranges on one worksheet? All my worksheets now per
category are different templates.

I am not sure if that makes any sense but not one of the categorys are the
same, would I still be able to make ranges on one worksheet?

I have been only working on excel for about a year so some of the stuff I am
still learning, or experimenting with. I have built everything myself for
this workbook and I am loooking for the easiest possible way to link or
connect all these worksheets into one so if you could give me some ideas that
would be great.

I know it sounds like alot of waste but I thought if I had different
templates or worksheet layouts I had to start a new one. And I have one of
these workbooks for every job which sometimes we can have quite a few jobs at
the same time, these are all the things I need to keep track of my jobs.

Thanks again for all your help! Its really appreciated!
tb

"Kassie" wrote:

Not sure whether this will help, but
It sounds like an awful waste to use a sheet per category, as you state.
Why not create ranges on the first sheet to accomodate all these sections?
You could then create a template file, and have all the basic info available
everytime you start a new document. Each file will however be updated with
its own unique info, and saved e.g. as a job number.

If this does not solve your problem, we would need more info, before we can
give real advice.

"tb" wrote:

I currently am using excel for my preference at this time but I was wondering
if there may be a more compatible program to what I am doing?

I have a workbook for each job which contains 6 worksheets each.
(Job record, quote, wages, Takeoff, Invoice, Change Order) I enter multiple
data into several of these worksheets, I have set some of them up to link to
each other for some of the information needed for all.

I was wondering if another program (access, project etc) may be more
compatible and easier for setting up for what I am doing. I keep track daily
of jobs and there activity and entered information in daily also.

Thanks
tb

To put it simple, a range is a block of contigous rows and columns, e.g. from
A1 to F360. Since you have in excess of 65 000 rows and something like 5 432
columns per sheet, you can surely fit in a lot of ranges. I do not know how
many columns and rows you use per sheet, but think of this.

You could create a range from say A1 to Z300, another from AA1 to AZ300 etc.
By the time you reach the right edge (Column IV), you have already created
something like 28 huge ranges. You can use one range for a job card, one
range for quote, one for your wages, one for Takeoff, one for your Invoice,
and one for your Change Order area, and sttill have a lot to spare. You can
name these ranges, and quickly go from one to the other with (at the
simplest) <Ctrl<g, and then entering the name. If you become more
proficient, you can record a little GoTo macro, create a button, and merely
click on that to navigate from one to the other.

I do not know what your spreadsheets entail, or what info you keep in each
workbook (except that you are using many sheets), and would need a lot more
info to provide specific help, but the principle of using a worksheet to its
potential, rather than just adding on worksheets, is something that makes a
lot of sense to me.

Obviously, if you are continually going to add columns or rows to an
existing sheet, you have to plan carefully, otherwise you will end up with a
messy sheet. If you have no choice but to use multiple sheets, then that is
the way to go, but normally one can do a tremendous amount of work using only
one sheet as opposed to using many sheets per workbook.

I hope this is helpful, rather than confusing. To come back to your
original question, yes, you can use Excel. You can also use Access. The
question here really is with which one are you most proficient. I can assure
you Excel is a lot easier to work with than Access. Since you have already
set yourself up, it is now a matter of fine-tuning your application. You can
do this by adding code (macro's), consolidating your information etc.

"tb" wrote:

What do you mean by ranges on one worksheet? All my worksheets now per
category are different templates.

I am not sure if that makes any sense but not one of the categorys are the
same, would I still be able to make ranges on one worksheet?

I have been only working on excel for about a year so some of the stuff I am
still learning, or experimenting with. I have built everything myself for
this workbook and I am loooking for the easiest possible way to link or
connect all these worksheets into one so if you could give me some ideas that
would be great.

I know it sounds like alot of waste but I thought if I had different
templates or worksheet layouts I had to start a new one. And I have one of
these workbooks for every job which sometimes we can have quite a few jobs at
the same time, these are all the things I need to keep track of my jobs.

Thanks again for all your help! Its really appreciated!
tb

"Kassie" wrote:

Not sure whether this will help, but
It sounds like an awful waste to use a sheet per category, as you state.
Why not create ranges on the first sheet to accomodate all these sections?
You could then create a template file, and have all the basic info available
everytime you start a new document. Each file will however be updated with
its own unique info, and saved e.g. as a job number.

If this does not solve your problem, we would need more info, before we can
give real advice.

"tb" wrote:

I currently am using excel for my preference at this time but I was wondering
if there may be a more compatible program to what I am doing?

I have a workbook for each job which contains 6 worksheets each.
(Job record, quote, wages, Takeoff, Invoice, Change Order) I enter multiple
data into several of these worksheets, I have set some of them up to link to
each other for some of the information needed for all.

I was wondering if another program (access, project etc) may be more
compatible and easier for setting up for what I am doing. I keep track daily
of jobs and there activity and entered information in daily also.

Thanks
tb