Please find attached 2 excel sheets.
Data Workbook and Final workbook
I want a macro to be run on data workbook and then the following functions to happen.
- delete the first seven rows from data excel
- creates a new workbook
-use the following formula from dataworkbook.
- use right(B1,7) in A2 of Final workbook
- use =C1 in B2 of Final workbook
- use =I1 in C2 of Final workbook
compile data in the format provided from the data excel workbook and save it in a folder.
I know the formula to get the data to the Final workbook. The place I'm stuck is I want the macro to check the total no. of rows in the data excel and copy the formula ONLY in those many rows in the final excel.
Hi I have 10+ years of experience in VBA programming and database management. Worked several project in VBA and as an expert I can complete the task most efficiently . if interested , we can connect via chat and g Daha Fazla
Bu iş için 9 freelancer ortalamada ₹1084 teklif veriyor
I can type 100 words per minute and I can type in hindi too. I have more then 3 years of experience. I am interested in doing this work. I am an expert in data enrty work. I have good typing speed too. Looking forward Daha Fazla
I am working as a risk professional in bank. I have done many projects in VBA. I can assure you delivery before 1 day. I can handle this project within some hours if you give me chance to work on. I will ensure quali Daha Fazla
Hello sir I understand that you are looking for data entry expert. I can do that project. I can do this project with any difficulties. I will also provide unlimited revisions of the excel sheets till you are 100% sati Daha Fazla