copy and transpose basing on cell values

B

balu

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

transpose loop 1
transpose horizantal basing on cellvalue 1
Macro to copy top 3 value in column 1
Copy unformatted value of cell via macro 0
Transpose between sheets 4
Macro to copy data X number of times into a column 0
HELP: Match values from different sheets and populate a column 3
Duplicating cell values from one sheet to another 3

Top