dears,
im accessing excel through access by creating excel object and copyd some
access query to sheet1 columns A and B
now i want is like this WAY
COPY all the cell values of sheet1!columnB where sheet1!columnA.value =
sheet2!cellA1 next COPY all the cell values of sheet1!columnB where
sheet1!columnA.value = sheet2!cellA2 and so on until sheet2!columnA having
values
(2) then copyd cell values of the ranges from sheet1 will be transposed on
to sheet2 columnB rows
can any one help me please