Hi,
this is probably pretty basic to a lot of veteran VBA user but I couldnt find the answer after few hours trying to "google" it.
I would like to use this in a more complicated VBA procedure that have a loop.
I want to copy a range (A1:B1000) from sheet1 into sheet2.
I want this to be copied in sheet2 in the first row where value in column B is the same value of B1 (from sheet 1).
I cannot figure out how to select the cell in sheet 2 that represent the exact value of Cell(B1) in sheet 1.
thanks for the help
this is probably pretty basic to a lot of veteran VBA user but I couldnt find the answer after few hours trying to "google" it.
I would like to use this in a more complicated VBA procedure that have a loop.
I want to copy a range (A1:B1000) from sheet1 into sheet2.
I want this to be copied in sheet2 in the first row where value in column B is the same value of B1 (from sheet 1).
I cannot figure out how to select the cell in sheet 2 that represent the exact value of Cell(B1) in sheet 1.
thanks for the help