Đã Đóng

2 Excel VBA tasks

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.

Kĩ năng: Excel, Excel VBA, Excel Macros

Về khách hàng:
( 0 nhận xét ) Ahmedabad, India

ID dự án: #33970847

24 freelancer chào giá trung bình₹6961 cho công việc này

(481 Nhận xét)
8.3
(185 Nhận xét)
7.0
AccountantArman

"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 Thêm

₹9000 INR trong 1 ngày
(174 Nhận xét)
6.6
(110 Nhận xét)
6.4
(18 Nhận xét)
4.3
yesubabu10203

Hi there myself yesu I am vba developer I can do this you can contact me on this for further discussion thanks.

₹7000 INR trong 3 ngày
(28 Nhận xét)
4.4
(14 Nhận xét)
4.3
rahulg5466

--------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 Thêm

₹7000 INR trong 2 ngày
(16 Nhận xét)
3.7
Ahsan2526

Hi, I will do this and ready to start now. I will do this in the least possible budget. Thanks

₹3000 INR trong 2 ngày
(10 Nhận xét)
3.5
kaly25

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.

₹10000 INR trong 7 ngày
(1 Nhận xét)
2.6
vnegi2016

Hi, I am vikram, read the project description. I can help you to Fix/Modify/Create VBA Script as per conditions that will give the required output I am expertise and experienced of Excel Automation/Macro's and have Thêm

₹5500 INR trong 5 ngày
(17 Nhận xét)
2.4
sushenranjandas

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. Thêm

₹5000 INR trong 2 ngày
(2 Nhận xét)
1.6
wilfrednjorog

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 Thêm

₹7770 INR trong 2 ngày
(0 Nhận xét)
0.0
andriikhylko

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 Thêm

₹7000 INR trong 7 ngày
(0 Nhận xét)
0.0
doshiviral98

i can do justice to this work and complete it on time given by you , i hope you will give chance to me

₹7000 INR trong 7 ngày
(0 Nhận xét)
0.0
kundan840

I am an expert Data Entry operator. I have an excellent speed and I believe in innovation and value addition in the client’s work. WHY HIRE ME:- I go beyond the brief from clients, and try to improve upon the assigned Thêm

₹5000 INR trong 7 ngày
(0 Nhận xét)
0.0
premdas1111

Hello, i can work for you in this project and i need a job very urgent in this pandamic. thank you

₹7000 INR trong 7 ngày
(0 Nhận xét)
0.0
dravi078

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.

₹7000 INR trong 7 ngày
(0 Nhận xét)
0.0
kanorathod7481

Thanks for your job posting . I just checked your project carefully it is an ideal match my skill and experience

₹6000 INR trong 5 ngày
(0 Nhận xét)
0.0
samsunghindu12

plese hire me i am good in typing + good in exel plese hire me i need work i wiil give my best ,,,, ,,,,,

₹1500 INR trong 1 ngày
(0 Nhận xét)
0.0