Hi,
Always get confused with VBA copying to new sheet, sample file is not fully working as in buttons/macros might not work but...
What I'm looking for is code that I can use in a macro Call Function to copy data from sheet 'Closed Adjustments' Columns B, I & L, row 6 into sheet 'Investigation' columns B, C & D row 2.
But only if column L in sheet 'Closed Adjustments' contains a reference numbers starting with A and has 10 digits, e.g. A1234567890
As you can see in sample file column L 'Closed Adjustments' can include many different reasons in 'L', just looking up that specific string where the number is always different but always one letter A and then 10 digits.
Hope that makes sense.
Tez
Bookmarks