need some help

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

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.
 
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.
 
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
 
Back
Top