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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy data from 1 sheet to multiple worksheets 2
Copy Row From One Worksheet To Another 2
Using a formula to copy data from one worksheet to another 1
Auto Copy Data from one worksheet to another 1
MS Excel VBA Copy and Paste from external workbook data to central worksheet 1
Copy row to worksheet IF 1
Lookup data from another excel files 1

Top