I am relatively new to excel and know what I want to do but little idea on
how to do it.

Background
The data is for our transport company who is carting numerous material types
from a number of locations to one central point. The company gets paid by
the tonne for material taken to this one central point.

Problem,

The template that I am working with is not a good formatt (inherited from
someone else). It has a number of worksheets all with relitively the same
information in each work sheet. Because the company is paid by the tonne I
need to have confidence in the data that any formula produces.

What I want to do,

1)Cut out some of the repeditive data entry eg drivers name, truck
regstrations, material type.
2)Ommit some worksheets by being able to filter, sort or formatt the sheet
so I can have like information on one worksheet regardless of where the
material has originated from, (currently a different worksheet for each
location or customer)
3)Create a summary page that shows the amount of tonnes from each location
for a week ending.
Any help would be appreciated

First, if this is mission critical to your company, I'd STRONGLY advise
hiring this job out.

Second, your problem statement is very generic. It's almost certainly
possible to do what you're asking, but HOW to do it will depend on a
whole host of factors that make it difficult to propose solutions in a
newsgroup like this.

If you have *specific* questions on how to accomplish smaller tasks
within your larger one, post back with detail on how your data is laid
out and what results you want to see.


In article ,
KeK23 wrote:

I am relatively new to excel and know what I want to do but little idea on
how to do it.

Background
The data is for our transport company who is carting numerous material types
from a number of locations to one central point. The company gets paid by
the tonne for material taken to this one central point.

Problem,

The template that I am working with is not a good formatt (inherited from
someone else). It has a number of worksheets all with relitively the same
information in each work sheet. Because the company is paid by the tonne I
need to have confidence in the data that any formula produces.

What I want to do,

1)Cut out some of the repeditive data entry eg drivers name, truck
regstrations, material type.
2)Ommit some worksheets by being able to filter, sort or formatt the sheet
so I can have like information on one worksheet regardless of where the
material has originated from, (currently a different worksheet for each
location or customer)
3)Create a summary page that shows the amount of tonnes from each location
for a week ending.
Any help would be appreciated