T
tjvols
I am trying to move data from one worksheet to another - DATA SHEET
-
COST CODE DESCRIPTION M S O L
010000 Labor Summary 5,000
011700 Burden 1,000
011750 General Liability 500
011775 Data Processing
011900 Equipment Repairs 1,000 4,500
012000 Utilities 200
012100 FLC Equipment 5,000
012200 Non-Owned Equipment Rental 6,000
012220 Toilet Rental 1,190
This is how I want the result to look - SUMMARY SHEET
Cost Code CT Description Amount
010000 L Labor Summary 5,000
011700 O Burden 1,000
011750 O General Liability 500
011900 M Equipment Repairs 1.000
011900 S Equipment Repairs 4.500
012000 S Utilities 200
012100 O FLC Equipment 500
012200 O Non-Owned Equipment Rental 6,000
012220 M Toilet Rental 11,900
Basically it moves only lines with data (ie. 011775 - Data Processing
does not have an amount associated with it so it does not show on
summary sheet). But if line has entries in two columns it moves over
in two lines with the "CT" associated (equipment repairs). Hope I
have explained ok. I have looked at several posts and nothing quite
fits what I need. Any help would be greatly appreciated.
-
COST CODE DESCRIPTION M S O L
010000 Labor Summary 5,000
011700 Burden 1,000
011750 General Liability 500
011775 Data Processing
011900 Equipment Repairs 1,000 4,500
012000 Utilities 200
012100 FLC Equipment 5,000
012200 Non-Owned Equipment Rental 6,000
012220 Toilet Rental 1,190
This is how I want the result to look - SUMMARY SHEET
Cost Code CT Description Amount
010000 L Labor Summary 5,000
011700 O Burden 1,000
011750 O General Liability 500
011900 M Equipment Repairs 1.000
011900 S Equipment Repairs 4.500
012000 S Utilities 200
012100 O FLC Equipment 500
012200 O Non-Owned Equipment Rental 6,000
012220 M Toilet Rental 11,900
Basically it moves only lines with data (ie. 011775 - Data Processing
does not have an amount associated with it so it does not show on
summary sheet). But if line has entries in two columns it moves over
in two lines with the "CT" associated (equipment repairs). Hope I
have explained ok. I have looked at several posts and nothing quite
fits what I need. Any help would be greatly appreciated.