Hi All, I am so noob with excel, so I would be glad if somebody could help me. And I hope that you understand my English L I need a macro to clean my excel sheet and reorder it: First, I need to take off all rows what do not have in column D project number (the project number is 100001-999999999. Second, I need to merge all the project number together (there could be several project number in different rows so it need to be calculate all hours together (the hours is in column K). Thirdly, I need to add two new column (columns A and B) which add personal number (column A) and personal name (column B) in all rows which have a project number. Thank you a lot

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Clean the sheet by rows

Thread starter Wannabeexcelguru
Start date Nov 9, 2015
Tags

clean macro project number

Wannabeexcelguru

New Member

Nov 9, 2015

Hi All,
I am so noob with excel, so I would be glad if somebody could help me. And I hope that you understand my English L
I need a macro to clean my excel sheet and reorder it:

First, I need to take off all rows what do not have in column D project number (the project number is 100001-999999999.
Second, I need to merge all the project number together (there could be several project number in different rows so it need to be calculate all hours together (the hours is in column K).
Thirdly, I need to add two new column (columns A and B) which add personal number (column A) and personal name (column B) in all rows which have a project number.

Thank you a lot