Closed

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.

Skills: Excel, Excel VBA, Excel Macros

About the Client:
( 0 reviews ) Ahmedabad, India

Project ID: #33970847

24 freelancers are bidding on average ₹6961 for this job

(481 Reviews)
8.3
(185 Reviews)
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 More

₹9000 INR in 1 day
(174 Reviews)
6.6
(110 Reviews)
6.4
(18 Reviews)
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 in 3 days
(28 Reviews)
4.4
(14 Reviews)
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 More

₹7000 INR in 2 days
(16 Reviews)
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 in 2 days
(10 Reviews)
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 in 7 days
(1 Review)
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 More

₹5500 INR in 5 days
(17 Reviews)
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. More

₹5000 INR in 2 days
(2 Reviews)
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 More

₹7770 INR in 2 days
(0 Reviews)
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 More

₹7000 INR in 7 days
(0 Reviews)
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 in 7 days
(0 Reviews)
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 More

₹5000 INR in 7 days
(0 Reviews)
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 in 7 days
(0 Reviews)
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 in 7 days
(0 Reviews)
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 in 5 days
(0 Reviews)
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 in 1 day
(0 Reviews)
0.0