a script/macro to copy a block of cells next to specified cells
-----Original Message-----
z. enthalpic,
My Excel knowledge is more disorganizaed than that... <GGG
1)
Range("B3").AutoFill Destination:=Range _
(Range("B3"), Range("A65536").End(xlUp)(1, 2))
2)
Not sure what you mean. Does the formula from step 1
return different values?
No, it's a TRUE/FALSE test. If TRUE, a value/character is
returned, if not, a "". Of course, it can be somthing
else.
Please take a look at my attempt at a better explanation
in response to Tom Ogilvy's reply.
I believe a simple macro can't do it,
A macro can do almost anything....
Yes, but not a simple one? <g
z.entropic
HTH,
Bernie
MS Excel MVP
"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
.
|