Dear Experts,
I have a macro which copies information from column (Number specified in cell A1) of sheet1 and pastes it in column D of a new sheet(Sheet2) then it copies information from column ABC of sheet1 and pastes it in the column ABC of Sheet2. Again it takes information from Column E of sheet1 and pastes it under the last used cell of the column D goes back to sheet 1 gets the information from columns ABC and pastes it in sheet2 starting from first blank cell of column ABC Sheet2. So far its fine.
Problem Starts when I have a value other than 4 (I want to use 5 and sometimes it can be 3 or 6 also) it picks up the correct information from specified column (2,3,4,5 or 6) and pastes it in the D column of the new sheet but for coping the constant columns it still picks up Column ABC and pastes it in sheet2 so when I use 5 in cell A1 information from column 4 is not copied and if I use 3 in cell a1 then again I have duplicate column D in sheet two
Modification help that I am looking for is kind of relative reference to cell a1 where it not only starts coping information from specified column number but also moves from D to E of sheet2 if cell A1 reads 5 and also copies 4 columns.
Attached, please find a sample sheet for which may give more clear picture.
Current Code is
Best Regards/VKS
Bookmarks