[RESOLVED] Using Offset in VBA

Hi this is probably quite simple but I can't get anything to work!
Basically I have two sheets.
In Sheet 1 a list of data with columns A and B the important ones.
In sheet 2 a summary of the data
I want to look in sheet 1 at column B and see if the variable is the letter "A"
If so I want it to look back at column A on that row which contains a number
I want to paste that number into sheet 2 at a specified cell
There are several rows of data and the letter "A" can occur more than once.
Everytime it does, it should repeat the number look up and paste it in sheet 2 below the previous one.
I know its offset but it will not loop round
Thanks in advance

you can try like

vb Code:

targetrow = 2
targetcol = 4
for each c in sheet("sheet1").range("b1:b99")   ' change to suit
  if c.value = "A" then sheets("sheet2").cells(targetrow, targetcol) = c.offset(, -1) : targetrow = targetrow + 1
next

change target and ranges to suit,
dim c as range

Brilliant
Thanks very much it works a treat