ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   lookup formulas ???? (https://www.excelbanter.com/excel-discussion-misc-queries/235199-lookup-formulas.html)

onedeviousmale

lookup formulas ????
 
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.

Don Guillett

lookup formulas ????
 
Please confine your questions to one subject and one ng or you will not make
friends.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"onedeviousmale" wrote in message
...
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.



onedeviousmale

lookup formulas ????
 
Hi Don,

I have sent you a copy of the work book, I hope you can figure it out, I am
not even sure how many hours i have into this master copy because I am not
that great when it comes to computers, I have re-vamped it a few times
wanting to find out more info. in reguards to expenses, but like i said I
have much to learn.

"Don Guillett" wrote:

Please confine your questions to one subject and one ng or you will not make
friends.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"onedeviousmale" wrote in message
...
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.





All times are GMT +1. The time now is 04:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com