If condition for numbers

Hi Excel experts,

I was wondering how a condition can be added in VBA, so let me explain how this might work:

I have a lot of columns like the next ones and I need only when the text starts with "13000", I need the value in Column B in the same row gets copied/cut and paste to Column A, if that happens, I need to do the same with Column C, gets copied/cut to colunm B., if the number does not starts with "13000", continue with the next row.

Column A Column B Column C
1300008815 11132013 BPCS
100228074 WIR Unidentified deduction
921010061 PO-162


All these columns needs to be check until the last row with data.

Let me know if more details are need.

The following code looks at the first five digits in each cell in column A to see if it matches "13000". If so, it sets the values of columns A & B to those from columns B & C, then clears column C. Note that in your data it looks like you have some values starting with "13001". This code does not alter those rows, and would need to be adjusted if necessary. (Perhaps look at just the first four characters for "1300" instead?)

Please Login or Register  to view this content.

Another option...

Please Login or Register  to view this content.