S
stephenc
Hi, Can you please help
My spreadsheet looks like this
Column A, Column B, Column C
Blank 600 8172540
Blank 18/12/2008
Blank 19/12/2008
Blank 19/12/2008
Blank 600 8172559
Blank 18/12/2008
Blank 21/12/2008
Result required
Column A, Column B, Column C
Blank 600 8172540
8172540 18/12/2008
8172540 19/12/2008
8172540 19/12/2008
Blank 600 8172559
8172559 18/12/2008
8172559 21/12/2008
I am trying to create a loop in a macro that will look at column B, identify
the value of 600 and copy the value in column c into column A until the value
of 600 in column B re-occurs at which point it then copies Column C into
Column A until 600 occurs in Column B etc etc,
My spreadsheet looks like this
Column A, Column B, Column C
Blank 600 8172540
Blank 18/12/2008
Blank 19/12/2008
Blank 19/12/2008
Blank 600 8172559
Blank 18/12/2008
Blank 21/12/2008
Result required
Column A, Column B, Column C
Blank 600 8172540
8172540 18/12/2008
8172540 19/12/2008
8172540 19/12/2008
Blank 600 8172559
8172559 18/12/2008
8172559 21/12/2008
I am trying to create a loop in a macro that will look at column B, identify
the value of 600 and copy the value in column c into column A until the value
of 600 in column B re-occurs at which point it then copies Column C into
Column A until 600 occurs in Column B etc etc,