I've got code which transfers:
a. all formulas and formats to another location.
b. specific desired formulas but not cell formats to another location.

The s/s is over 330,000 rows deep which makes manual changes
impossible.

I attach small s/s containing both codes.

What I want to do is copy+paste both formulas and formats from only
those cells which have a number in the cell below to cells 4 columns
along and two rows down. The s/s illustrates this.

Can anyone help please?
Big thanks.
Colwyn.


+-------------------------------------------------------------------+
|Filename: example.xls |
|Download: http://www.thecodecage.com/attachment.php?attachmentid=13|
+-------------------------------------------------------------------+

--
colwyn
------------------------------------------------------------------------
colwyn's Profile: http://www.thecodecage.com/forumz/member.php?userid=34
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30569