automatic row copying

  • Thread starter Thread starter Mikki~
  • Start date Start date
M

Mikki~

Hello; I have a workbook with several worksheets representing months in the last
18 months, each month with its own worksheet. It's for tracking jobs, each
separate job listed in its own row with information about that particular job,
including job number, street address, cost of the repair, etc.

Is it possible in Excel to have a full row of information automatically copied
to one specific sheet in that same workbook if the repair value is greater than
a certain amount? So, all jobs from all months that have a repair value of over
5,000, for example, would automatically be transferred to this one worksheet
called Follow-up.

I appreciate any helpful suggestions!
 
Mikki,

There's no automatic feature in Excel that will copy rows to another place.
You must do it either manually, or write a macro to do it specifically the
way you want.

You may well find that putting all your records (rows) in one worksheet will
actually make things simpler. You could use Autofilter to reduce it to your
follow-up items. Something to definitely consider. Take a look at "Data
across multiple sheets" at
http://www.smokeylake.com/excel/excel_truths.htm.

Earl Kiosterud
www.smokeylake.com
 
Earl,
Thank you. I'll check it out.

Earl Kiosterud said:
Mikki,

There's no automatic feature in Excel that will copy rows to another place.
You must do it either manually, or write a macro to do it specifically the way
you want.

You may well find that putting all your records (rows) in one worksheet will
actually make things simpler. You could use Autofilter to reduce it to your
follow-up items. Something to definitely consider. Take a look at "Data
across multiple sheets" at http://www.smokeylake.com/excel/excel_truths.htm.

Earl Kiosterud
www.smokeylake.com
Click to expand...
 
Suggestion: given you want to find ALL orders over $5k regardless of month,
you may find it easier to combine all the sheets so you only have to filter
the data once for the desired for the given report rather than 18+ times
then combine the results as now.
 
Back
Top