Copy paste

**Sudheerp** · 10-24-2008, 12:03 PM

Hi I have a very strange copy and paste macro that I need to make.
Basically I have a file which is like this:

Fruits Basket 1

Apples

Table of Apple Stats

Pears

Table of Pear Stats

Fruits Basket 2

Oranges

Table of Orange Stats

Apples

Table of Apple Stats

etc. etc.

I'd like to search the file and Copy the title of Fruits Basket 2 then Copy the Subtitle of Apples and then copy the table of Apple Stats using range selection Xldown and Xlright. Oh and then paste into a new sheet. I'm a little hesitant on whether I should be using some sort of For loop or If loop? Also note there is always a 2 cell gap between Apples and the Table of Stats. However the gap between the Title Fruits Basket and the next Fruit is either two or three cells.

Is there any way I can do this? It's so ridiculously annoying to have to search for apples every morning amongst all this fruit.

**davesexcel** · 10-25-2008, 11:40 AM

Please provide a sample workbook with the original layout and the desired layout

**Sudheerp** · 10-27-2008, 12:57 PM

Hi Dave,

How do I post a sample workbook?

Thanks!

**arthurbr** · 10-27-2008, 01:03 PM

Click on "Post reply" and scroll down to "manage attachments"The rest is quite straightforward. Please add your file as XLS rather than a picture or even xlsx

**Sudheerp** · 10-29-2008, 12:00 PM

I've uploaded the file that I'm working with. It's exactly in this format and I want to copy the apples part of the excel sheet. Including the title and the table of apple information.