Končano

434547 Excel Macro to select copy and paste.

I have a column of either numbers or letters, (sheet1 column D) these could be as many as 4000 and could be anywhere in the sheet. My task is: 1) Look at the last two numbers, go on top of the column and search for where those two numbers first appear, then copy the whole column from there till down and paste it two columns to the right. Thus column G 2) You move further down the column searching for those two last numbers, when you find them you copy the column till down and paste it next the one you pasted before. Thus column H. You do this until you reach the last two digits. Sheet2 We check the last 3 numbers, and sheet3 we check the last 4 numbers! Thank you in advance.

Znanja: Vse velja, Excel

Več: advance excel+, excel advance, copy right, copy pasted, advance excel, excel find select, excel check check, excel column copy, excel check, macro find copy paste, searching excel, excel numbers, search macro, excel macro sheet, excel search macro, macro copy excel paste, excel column column, excel macro columns, search macro excel, copy paste macro

O delodajalcu:
( 6 mnenja ) London, Uganda

ID projekta: #2180420

Dodeljeno:

oliverg

Hi, I can type this macro right now. Please accept my bid and ill have the sheet back to you asap. Best regards Oliver

$25 USD v 0 dneh
(8 mnenj)
4.3