a script/macro to copy a block of cells next to specified cells
set rng = Range(Range("B3"),Cells(rows.count,1).End(xlup).of fset(0,1))
rng.Filldown
Don't understand you question 2.
--
Regards,
Tom Ogilvy
"z.entropic" wrote in message
...
Here's what I'd like to do:
1. copy cell b3 all the way down to b(n), where n is the
number of data in column a; this produces some cells in
column b with a numerical value or character;
2. copy a block of cells, e.g., b1-c2, where cell b1
would be placed in column c next to every occurrence of
the previous numerical value.
I believe a simple macro can't do it, only a VBA scipt
could, but am no expert at it...
Help would be much appreciated.
z.entropic
|