Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy a group to a new worksheet
Hi, Sorry if this is an stupid question and a bit long to explain but have tried to find the answer for two days now. I have a worksheet with for example the A1 oranges A2 oranges A3 apples A4 apples A5 apples A6 grapes what I need is a the group of oranges to be copied into its ow worksheet and the same for the group of apples. I have the data grouped but have no way of telling how many orange will be in a group or apples etc. I'm looking for somthing that wil look at A1 and create a worksheet called oranges then copy all th cells containing oranges into the new worksheet, when the macro detect a change to apples or grapes create a new worksheet called apples o grapes and copy the cells again until it finds an empty cell and end the routine -- dazi ----------------------------------------------------------------------- dazil's Profile: http://www.excelforum.com/member.php...fo&userid=3723 View this thread: http://www.excelforum.com/showthread.php?threadid=56954 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy a group to a new worksheet
See
http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "dazil" wrote in message ... Hi, Sorry if this is an stupid question and a bit long to explain but I have tried to find the answer for two days now. I have a worksheet with for example the A1 oranges A2 oranges A3 apples A4 apples A5 apples A6 grapes what I need is a the group of oranges to be copied into its own worksheet and the same for the group of apples. I have the data grouped but have no way of telling how many oranges will be in a group or apples etc. I'm looking for somthing that will look at A1 and create a worksheet called oranges then copy all the cells containing oranges into the new worksheet, when the macro detects a change to apples or grapes create a new worksheet called apples or grapes and copy the cells again until it finds an empty cell and ends the routine. -- dazil ------------------------------------------------------------------------ dazil's Profile: http://www.excelforum.com/member.php...o&userid=37237 View this thread: http://www.excelforum.com/showthread...hreadid=569548 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy a group to a new worksheet
Thanks, Ron de Bruin. I got your code working straight out of the box. I cant ask for any more help than that. -- dazil ------------------------------------------------------------------------ dazil's Profile: http://www.excelforum.com/member.php...o&userid=37237 View this thread: http://www.excelforum.com/showthread...hreadid=569548 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy a group of Chart tabs | Charts and Charting in Excel | |||
Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
How can i copy a group of cells in a row to a column? | Excel Discussion (Misc queries) | |||
Copy only first row of each group. | Excel Programming | |||
MOVE/COPY GROUP OF RECORDS TO OTHER WORKSHEET | Excel Programming |