need some help

Hello everybody,
I need some help to make a make a spreadsheet
Here is what I need:
3 columns:
bus# date inspected QC defect

the first thing I need to do is create a button that will sort the
sheet in bus# order then I need another button to sort the sheet in
date order
now I need to be able to delete the row when the bus was fixed (maybe
with some key combination?)
this sheet has to be unlimited in length because we will be adding the
buses and deleting them
I don't know if I need some kind of VBA codes or macros...?
can somebody help me with this, please

Mark

Use one row for headers.

Then record a macro when you:
select columns A:C
sort by column A

Record another macro when you do the same thing, but sort by column B.

Rightclicking on the row and choosing delete row is probably the simplest way.

Mark wrote:
>
> Hello everybody,
> I need some help to make a make a spreadsheet
> Here is what I need:
> 3 columns:
> bus# date inspected QC defect
>
> the first thing I need to do is create a button that will sort the
> sheet in bus# order then I need another button to sort the sheet in
> date order
> now I need to be able to delete the row when the bus was fixed (maybe
> with some key combination?)
> this sheet has to be unlimited in length because we will be adding the
> buses and deleting them
> I don't know if I need some kind of VBA codes or macros...?
> can somebody help me with this, please
>
> Mark

--

Dave Peterson

As for deleting rows, you may not want to do this.

You can use DATA | FILTER | AUTOFILTER to show/hides values in the
column. You can record a Macro while you set the filter (select custom
after the AUTOFILTER) and then set it to "does not equal" complete - or
whichever term you are using to indicate that the bus was fixed. You
can also set Macros to show only the fixed buses, to track the work of
the mechanics. Or to show all.

On Thu, 14 Jul 2005 16:38:02 GMT, Mark <123@hotmail.com> wrote:

thanks for your help
I'll try and if I have any questions I'll get back on this forum,
if you don't mind of course

Mark