Fermé

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.

Compétences : Excel, Excel VBA, Excel Macros

Concernant le client :
( 0 commentaires ) Ahmedabad, India

Nº du projet : #33970847

24 freelances font une offre moyenne de 6961 ₹ pour ce travail

(481 Commentaires)
8.3
(185 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(174 Commentaires)
6.6
(110 Commentaires)
6.4
(18 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 3 jours
(28 Commentaires)
4.4
(14 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 2 jours
(16 Commentaires)
3.7
Ahsan2526

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 2 jours
(10 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(1 Évaluation)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 5 jours
(17 Commentaires)
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. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 2 jours
(2 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 2 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
0.0
premdas1111

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
0.0
kanorathod7481

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 5 jours
(0 Commentaires)
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 ,,,, ,,,,,

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0