Moving data from one worksheet to another

T

tjvols

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving data from one worksheet to another 1
Moving data from one worksheet to another 2
Adding data from multiple cell and linking to a new worksheet 3
Formula to count data in a column that falls between a range 3
Linking data from one worksheet to another using ookup functions 2
Particulars data Filter from sheet 1 to sheet 2 automatically 4
How do I copy cells from one worksheet to another based on values 2
bringing data in from one worksheet to another 0

Top