Help with copying if value = cell +2 or -2

**alphecca** · 03-01-2011, 09:05 PM

Hi all,

(read last post first)

Please find attached a sample document,

Thanks to MarvinP's help, the first part of code has be worked out.

I need code now that:

Remembers which number(the left hand number of table) on the "first set" table, shown in yellow and red that the first loop stopped at.

Then takes the heading related to that number in the "first set" table and compaires it to the "second set" table.
When the heading is matched +or - 2 it then begins the copy again, again, copying the cells B to E to the "Display table" on the end of what ever data is already their, with no row gaps between the data already in place and the new data being copyed.

The "copy to" possition/row can change depending on the point in the code already in the sample reaches the end of its loop. It could only copy 2 entrees if it finds a figure bellow 0.01 is on the 2nd labled row.

Then whilst moving down the "second set" table when the heading = cell H24 +or-2 the copying stops.

This is fairly complex, can anyone help?

Thank you

**alphecca** · 03-02-2011, 08:47 AM

Can someone please tell me how to use the find function correctly

Please Login or Register  to view this content.

where active cell is the cell i wish to find in the range and is already defined.
I dont know what to put for the other parts though

**alphecca** · 03-02-2011, 10:09 AM

I am trying to ge it to find the activecell value +or- 2... how should it be writen?

Please find attached another change 14:40 02/03/2011 copy of the document and the process so far... i am also having trouble, its saying loop without do when i have a do!

**alphecca** · 03-02-2011, 11:54 AM

Ok now the code all works, can someone help me work out how to DO cellvalue +or - 2????

The bits needing a shown in the code as +or-2 after the cell itself in the code.

Please Help.

Thank you