I have to clean datas thanks to a VBA Macro. Here are the specifications :
Sheet 1 : Datas
Sheet 2 : Transform attributes
Sheet 3 : Transform attributes Values
Sheet 4 : Transform Datas
I will put Datas in the sheet 1
On sheet 2 : I want a button here : this button will take the attributes (on Line 1, Sheet 1) and paste in Column A. I will put Datas in column B & C. Note that the datas in Column C, i don’t want transform this attributes in sheet 3.
On Sheet 3 : I want a button here : this button will transform the Values in sheet 1 thanks to the Values in column B, sheet 2 and it have to be like the sample file. The values in column A are the attributes transformed in sheet 2. The values in column B are the « Attributes values » (No duplicate content). In Column C i want put values corresponding to
I want another button to get the result in sheet 4 with the attributes TTM and Attributes values TTM.
On Sheet 4 : I want the result here. it looks like to Sheet 1 but transformed with the datas TTM from the others sheets.
6 freelancere byder i gennemsnit €36 på dette job
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself for this project. please contact with me. Thanks.