You should have kept track of the newsgroups you posted to - if you
multi-post then your answers get fragmented, and most respondents look
at many newsgroups so there is no need to do it.

Pete

On Jan 8, 6:43*pm, TStirling wrote:
On Jan 8, 11:43*am, "Pete_UK" wrote:





I think I've already replied to this somewhere else - please don't
multi-post.

Pete

"TStirling" wrote in message

...

I am using Microsoft Excel 2007. I have an account number in C:2.
Associated with this account number is a set (in a column) of 3 digit
numbers in W:2, W:3, W:4, W:5. When there are multiple 3 digit numbers
in Column W, there are blank spaces under C:2. When the next account
number appears (C:6), it has it's own set of 3 digit numbers. I need
to take each 3 digit number associated with the account number and
move them into adjacent columns on the same line as the account
number. So, W:3 would move to X:2, W:4 would move to Y:2, W:5 would
move to Z:2 and so on. I assume I need a VB solution. Can anyone help
me with this? Thank you very much in advance.- Hide quoted text -

- Show quoted text -

Sorry, I thought I had to multi-post. Do you know where you replied to
this topic?- Hide quoted text -

- Show quoted text -