Automatically update column - Autofill
 

Hi Tom

The modification almonst ;) works fine. Except that I need to ski
some columns. I did not explain my previous question properly.
Below is a sample situation of what I'm facing. I tried adding a Fo
statement with steps, but it did not work.

Code
-------------------
January February March
Product Qty Price % Qty Price % Qty Price %
Hake 0 0.00 0% 0 0.00 0% 0 0.00 0%
Eel 0 0.00 0% 5 5,808.04 2% 6 5,858.30 2%
Prawn 38 34,743.11 12% 21 25,062.54 7% 33 27,155.81 8%
Oyster 48 46,851.35 16% 50 44,111.01 13% 91 75,190.67 22%
Roe 6 3,639.60 1% 29 24,925.57 7% 17 11,950.47 3%
Sturgen 9 3,512.37 1% 3 1,307.31 0% 6 2,213.02 1%
Mussels 9 11,160.00 4% 12 14,765.00 4% 12 17,713.94 5%
Calamari 0 0.00 0% 6 2,758.50 1% 2 1,771.00 1%
Lobster 304 202,205.30 67% 365 233,717.65 66% 335 206,794.14 59%


Jan Feb Mar
Lobster 304 365 335
Other 110 126 167

-------------------


Kind Regard

--
popp
-----------------------------------------------------------------------
poppy's Profile: http://www.excelforum.com/member.php...fo&userid=1145
View this thread: http://www.excelforum.com/showthread.php?threadid=26642