İptal Edildi

Automated Excel Processing & comparision of excel files

This project requires a custom macro to be written.

Every day we ftp into some of our data servers and get some files from there by using get command. Once they are downloaded on the workststion, I open them with excel and format them to get them in required recognisable form. Operations on excel to do this are - select all, sort ascending, deleting rows with redundent data in top of worksheet, text to column for entire sheet, deleting not required colums, renaming required colums,selecting amount colums & rmoving non numeric characters in it by replace option, formating to currency, subtotal, deleting again rows at end with redundant data, totaling amounts by groups; and finally saving the file.

Based on the classification information for the sub-total amounts in excel; the sub-total amounts are added again to 4 different categories. The totals in 4 categories are then compared against manually entered numbers in another excell file to find the deviation in numbers.I want to automate this job on daily


Beceriler: .NET, Veri İşleme

Daha fazlasını gör: we excell, we excel, top sort, excell job, excel &, n excel, sort excel, rows, renaming, renaming i, numeric, macro excel, macro + excel, it operations, format excel, file renaming, excel\ , excel, excel job, excel form, excel c#, excel based, excel automate, do excel, deleting

İşveren Hakkında:
( 0 değerlendirme ) Hicksville, United States

Proje NO: #76288

Bu iş için 4 freelancer ortalamada $60 teklif veriyor


Technically, this is a very challenging project (particularily, if you want the application to also automate the FTP download.. which is doable). Hello, my name is Bill.. I am a VB / VBA / SQl and MsExcel programmin Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)

$7/ hour to develop a custom script for you. Have more than 3 year experience in this. PL open PM if you are interested. Thank you.

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

Hi, I am very much interested in this job. I am from Hyderabad, India. Request you to please check ur PM now and get back to me ASAP. Thanks and Regards, Sai Kiran

in %bids___i_period_sub_35% gün içinde60%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Sir, I am interested in doing this job. I have done implementing formulas in the excel sheets earlier. If I am given opportunity, I assure that I will work sincerely. Thanks, Chamu.

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)