2 Excel VBA tasks
₹1500-12500 INR
货到付款
Task 1: Improvement existing Makro in Rollei Orderformular, tab WE Overview
Source File: Rolleo Orderformular, tab WE Overview
Target File Rollei WE data base
- I have changed some input in the file. Therefore, some changes are needed.
- The new source file columns AA to AD are currently not exported to the target file. Please revise the macro. Any newly added columns (which are not hidden) must be also exported. This should work generic also in future without changing the macro every single time.
- The new columns AA to AD are hidden in the target file. The upload must still take place once the export macro is initiated.
- if columns are hidden in the source file no export shall take place.
- If columns are hidden in the target file export shall take place
- In the target file I have protected the columns R to X to avoid formulas can be overwritten manually. Even these columns are hidden in the source file, this is causing a failure message. Can this be solved?
- General information: All sheet protection can be removed without password.
Task 2:New Export macro USD planning to Rollei WE data base
Source File: USD_Planung_Rollei_ab 04.06.2022, tab "Allocation USD"
Target file: Rollei WE data base, tab WE Overview
• Large macro button in the source file, named "Export to WE Overview" in cells I1:K4
• From the source file the exchange rate from column X (hidden, "Exchange rate for WE Overview") shall be exported via macro into the target file, column P ("Kurs")
• The exported data must be allocated to the matching line in the target file. Identification is "Datenbank already in USD planning check & for export in WE Overview" (hidden column W in the source file) and "Order No." (column D in the target file). These both cells must match to initiate the export.
• Only update lines in the target file, if in the line of the target file B=""
• General information: All sheet protection can be removed without password.
Attention: In both files (source and target) these identification order numbers can be found often more than once (they are not unique). However, the exchange rate for each duplicated order number is always identical. This makes the export matching function workable.
项目ID: #33970847
关于项目
有24名威客正在参与此工作的竞标,均价₹6961/小时
"Sir, I am Excel VBA Macro Advance Level Expert Having Experience of over 10 Years. This is a basic work for me. i can complete this project with added quality. About me I am Chartered Accountant with more than 6 year 更多
Hi there myself yesu I am vba developer I can do this you can contact me on this for further discussion thanks.
--------I CAN DO IT RIGHT AWAY-------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VB, building an excel file, excel dashboard, pivot tables, charts, v 更多
Hi, I will do this and ready to start now. I will do this in the least possible budget. Thanks
I'm an Excel VBA expert. I'm creating these types of macro in my organisation where large number of excel files are handled. So I can do the job with good understanding.
Hi, Its Sushen here. I have read your project description and found you are facing trouble during trying to export data using macro. As I had that skill needs to improve your macro that can perfectly export the data. 更多
Hi there! I have vast experience in Excel VBA, Excel and Excel Macros, and I am confident that I can produce quality content for you that will be of interest to your readers. I am available for a full-time writing pos 更多
Hi, I am a honest dedicated developer. I read your requirements carefully and understood very well about the project scope and start working accordingly in stages. I am having more then 7+ years of experienced in prog 更多
i can do justice to this work and complete it on time given by you , i hope you will give chance to me
Hello, i can work for you in this project and i need a job very urgent in this pandamic. thank you
I done this project for free of cost if I done this project on time. Please give the chances to complete my first project. My skills are good for your project.
Thanks for your job posting . I just checked your project carefully it is an ideal match my skill and experience
plese hire me i am good in typing + good in exel plese hire me i need work i wiil give my best ,,,, ,,,,,
Hi, I like automating manual boring tasks on Excel, preferably using a VBA macro, or templates if needed. I have done multiple optimization work, both in my office, and as a freelancer in other platforms. The price I q 更多
I have experience to make a good business plan i have seen your project description I have master qualifications with 2 year experience
I best known this field. Your project very easy. And i complete this project in 7 days. I experience this work.
yes , I am ready for the job ,I had done excellent work on excel from last 3 works and I have good typing speed ,as mentioned your client will be very happy from you and work. Since 2019 i am working on excel and did l 更多