Copy cell data from one worksheet to another-TJ

A

ambushsinger

I have data separated in groups. The last column is the qualifier, call it
column G.
Each time the value of column G changes I need to copy that group of data to
another worksheet and then go back to the original worksheet to do it again
until it's finished.
any ideas?
 
A

ambushsinger

Maybe I didn't word this right...
column G is the 7th column in my data. it's value is 211, for the first
group, 212,..etc.
Each group has an undetermined number of records.
I need to copy columns D, E, and F to another worksheet into specific cells.
I hope this clears up my question.
again...any ideas?
 
A

ambushsinger

Not exactly what I'm looking to do...I need to select and copy the values of
columns "D, E, F" as long as the value of column "G" remains the same.
When the value of column "G" changes I need to paste the selected records
into a range on the next sheet. Each time the range on the next sheet will be
different.
 

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

Dealing with the error: unable to filter on excel hc home school 0
Auto Copy Data from one worksheet to another 1
Excel 2013 Merge Data 2
Create if partial match then copy and paste data from one cell to another 1
setting one worksheet cell range reference to another worksheet 1
Copy Row From One Worksheet To Another 2
Using VBA to copy data into another worksheet ??? 2
MS Excel VBA Copy and Paste from external workbook data to central worksheet 1

Top