Frustrated

  • Thread starter Thread starter onedeviousmale
  • Start date Start date
O

onedeviousmale

On Row 59-63, I want to set up my program to find any repairs done that
month, so that I can Track the cost of the Materials used in Repairs (eg. in
Column B - Job # if I Entrer "Repair#1" instead of a Job #. I have the same
Sub - headings on Row 58 and I want to Copy everything on that row to Row 59
( eg. All infow from Row 3). I can get it to work untill i enter a second
repair "Repair#2" in Column B Rows 6-49, I would like the Second Repair to
appear in Row 60 with all Info pertaining to that row (eg. Info From row 7)

A , B , C , D , E , F , G

Date, job # , Company , Suplier , siding, Soffit/Fascia, Roofing,
1
2
3 Repair#1, Daas , Totem , , $10.84 ,
4
5
6
7 Repair#2, Destiny , Home Depot ,$ 47.84
Etc.
 
I can't picture this so
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.
 
Basically where ever the word "Repair" Show up in Column B - Rows 6-46,
Either as "Repair#1" or "Repair#5" I would like excel to take the info from
each column refering to that specific repair starting with repair#1 and
re-enter it in rows 59-63, but I also need it to distinguish the Difernence
between Repair#1 and Repair#2 without changing the ascending order in Column
B

any help would be greatly appreciated
 
Hi,

1. You could apply an AutoFilter on the column containing the word Repair#
and choose the Custom option "begins with" and enter Repair. Copy the
selected data.

2. You could make a pivot table with the Repair column in the Row area and
adding the column you want totaled in the Data area. - by default pivot
tables sort on the row field. there is a workaround but if you decide that a
pivot table is appropriate and you don't get the sort order you want then
post a new question.
 
I've tried your suggestions, but I couldn't get either one to do what I need
it to do I have realized that my knowledge of excel is very limited as to
what formulas to use to get the results you want
 
Don has made a generous offer of help - since you are so new to Excel and are
having troubles with other help offered, as from Shane, you may want to send
that file to him and let him assist you more directly. Direct dialog often
works wonders.
 
I'm goignto try to clarify the question here....

Are you saying in rows 6 - 46, you have, say, repair #1 a bunch fo times and
repair #2 a bunch of times... and in rows 58 and 59, you want to sum up the
totals for each repair?

if so, in cell E58, type =SUMIF($B$6:$B$46,$B58,E$6:E$46), then copy the
cell and paste into F58 and G58 and down to row 59. Otherwise, may need more
explanation.
 
Back
Top