Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving data from one worksheet to another
I am trying to move data from one worksheet to another - Data Sheet
CC Description M S O L 010000 Labor Summary 5,000 011700 Burden 1000 020000 Site Work 2000 3000 030000 Concrete 5000 500 040000 Masonry 160000 Electrical 10000 This is how I want the result to look - Summary Sheet Cost Code CT Description Amount 010000 L Labor Summary 5000 011700 O Burden 1000 020000 M Site Work 2000 020000 S Site Work 3000 030000 M Concrete 5000 030000 O Concrete 500 160000 S Electrical 10000 Basically it moves only lines with data (040000 Masonry does not have an amount on the data sheet so it does not move to the summary sheet). If a cost code (row) has multiple entries it moves to the summary sheet on two rows with the associated description (Site Work, Concrete). Hope I have explained my problem ok. This is my first post, I have looked at several posts and nothing quite fits what I need. Any help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving data from one worksheet to another | New Users to Excel | |||
Moving data from one worksheet to another via a Macro! | Links and Linking in Excel | |||
Moving chart data to the same worksheet | Charts and Charting in Excel | |||
Moving data from from one worksheet to another | Excel Worksheet Functions | |||
Moving Data to Another Worksheet | Excel Discussion (Misc queries) |