Tamamlanmış

Excel Macro

Hi,

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.

Beceriler: Excel, Veri İşleme, Excel Macros, Excel VBA

Daha fazlasını gör: excel macro data cell, data net web application excel macro, excel macro move data existing cell, excel macro copy data column, excel macro enter data database, data web excel macro, excel macro data online, excel macro data base entry, excel macro next chart data, excel macro copy paste data application, excel macro copy data windows application, excel macro paste data, excel macro sort data existing sheets, hi, please see attached excel document showing the 11 pages i , excel macro to find copy and paste data, excel macro to append data from multiple sheets, excel macro autofill to last row with data, excel macro go to last row with data, excel macro to copy data from multiple sheets into one sheet

İşveren Hakkında:
( 3 değerlendirme ) Mumbai, India

Proje NO: #30110423

Seçilen:

ShivaniGoyalsai

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

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% INR
(21 Değerlendirme)
3.9

Bu iş için 9 freelancer ortalamada ₹1084 teklif veriyor

(274 Değerlendirme)
6.4
(1 Yorum)
0.4
gopa96l22

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
0.0
tandelkrunal995

Dear Sir/Madam Your extremely urgent project has caught eye and I strongly believe am the right candidate to deliver. Am a fast typist and accurate as well. My work experience spans five years. Lets talk over it and Daha Fazla

₹610 INR in 24 gün içinde
(0 Değerlendirme)
0.0
meetforu800

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
0.0
santoshkumar3838

I'm Santosh Kumar, from Chennai now I live in Coimbatore. I'm doing my UG degree in Business Management. My dad is a Banker, My mom is a Housewife and My short term goal is to get a job in reputed company like yours a Daha Fazla

₹900 INR in 7 gün içinde
(0 Değerlendirme)
0.0
Arushibajpai1994

Hi, I am from Finance background and know how to handle excel and word with short cuts.I will deliver your work on time. Thankyou,

₹1250 INR in 2 gün içinde
(0 Değerlendirme)
0.0
sureshsanjel

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
0.0