cut and paste using absolute references in vba
 

A B C D
1 start time

2 5 2 X

3 3 4 Y

3 6 3 Z


The cursor is at D2.
What is the code to cut and paste values in
column C - X to I2:J2, Y to G3:J3 and Z to J4:J6?
Hope this is understandable.

cut and paste using absolute references in vba
 

Sub BuiltData()
for each cell in Range("C2:C4")
cell.Offset(0,cell.offset(0,-2).Value+1). _
Resize(1,cell.offset(0,-1).Value).Value =
cell.Value
cell.ClearContents
Next
End Sub

Assume

Z to J4:J6
should say
Z to J4:K4

--
Regards,
Tom Ogilvy



"Stewart" wrote in message
...
A B C D
1 start time

2 5 2 X

3 3 4 Y

3 6 3 Z


The cursor is at D2.
What is the code to cut and paste values in
column C - X to I2:J2, Y to G3:J3 and Z to J4:J6?
Hope this is understandable.