Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy cell data from one worksheet to another-TJ
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy cell data from one worksheet to another-TJ
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? "ambushsinger" wrote: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy cell data from one worksheet to another-TJ
See Ron de Bruin's site for code examples and a downloadable workbook.
http://www.rondebruin.nl/copy5.htm Gord Dibben MS Excel MVP On Tue, 12 May 2009 09:45:01 -0700, ambushsinger wrote: 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? "ambushsinger" wrote: 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy cell data from one worksheet to another-TJ
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. "ambushsinger" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data copy locks cell in worksheet | Excel Discussion (Misc queries) | |||
Copy data in multiple worksheet tabs into one worksheet | Excel Programming | |||
copy column cell data onto another worksheet | Excel Programming | |||
copy data in a cell from worksheet A to worksheet B | Excel Discussion (Misc queries) | |||
Copy Cell Data from one Worksheet to Another | Excel Programming |