En curso

Build an excel macro from two different files

We would like to deduct our physical stock after we sold our products. Actually we need the following things automated.

We have the file A-that contains all our stock. From there we would like to start the macro. The macro should let us select the invoice file from our computer - The invoice is also an Excel file.

- Unfold the hidden columns

- Search for the ID in columns. The ID is in both files.

- Values in the stock filed should be deducted by the number of sold goods in the invoice. One invoice has many product rows.

- Do this with all rows in the invoice

- When done select a filter in file A over the deducted positions.

- Copy these files at the end of a list in another tab of file A

- Copy specific data from two more different rows of the invoice to file A.

- Put the amount of stock of the invoice from one column in file A to another column.

The file Bestandsliste is file A. The attached has only 50 rows. Our normal file hast about 3000 rows. I would like to copy the macro then in the "real file".

Habilidades: Entrada de datos, Procesamiento de datos, Excel, Arquitectura de software, Visual Basic

Ver más: excel macro open files, excel macro open files directory, combine text files using excel macro, excel macro export text files, macro open files time excel, reading text files directory excel macro, import multiple text files excel macro, excel macro import project files, build sorting macro excel, import multiple csv files excel macro, list files directory excel macro, excel mkdir macro directory files, excel macro create files, excel macro compare files, build excel macro find replace, excel plot different files, excel macro merge files folder, excel macro merge files, build excel macro, build excel macro and perhaps code excel

Información del empleador:
( 4 comentarios ) Wien, Austria

Nº del proyecto: #17653330

Adjudicado a:

seaanddream

Hi Marcus, This is Selim. I have already started the analysis, I think I can deliver till Sunday. Thank you,

€150 EUR en 3 días
(303 comentarios)
7.8

43 freelancers están ofertando el promedio de €140 para este trabajo

Webxpert4u

Hello, I am ready to create macro to automate the process to deduct your physical stock after solding products.. I want to discuss in detail before starting... Send me a message so we an chat. Highly experienced in Más

€155 EUR en 1 día
(269 comentarios)
7.7
deepbluetech

Hi, I am an Excel macro expert and have experience in handling projects similar to yours. Let me know and we can discuss. Regards, Arul

€150 EUR en 3 días
(253 comentarios)
7.4
liangjongai

I'm interested in your project very well. I've got an experience in jobs with skills of MS Excel and VBA. Please ping me to discuss about this project.

€155 EUR en 3 días
(218 comentarios)
7.4
schoudhary1553

Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 390 + projects with 100% client satisfaction. I can help you Más

€250 EUR en 4 días
(302 comentarios)
7.7
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please send me a message so that we can discuss more.

€200 EUR en 3 días
(282 comentarios)
7.2
zekovicm

Hi there,I am Miljan,Excel VBA/Macro expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it wit Más

€177 EUR en 3 días
(106 comentarios)
7.0
sumon355

Hello, As an experienced application developer, i am very much interested to do this job. I can create the required MACRO or a windows application by .Net if you like. Let's discuss more. Thanks

€160 EUR en 5 días
(194 comentarios)
7.0
asin1987

Dear Employer, I understand your job quite a bit and I will do the job for you. Please try me once. Do check my previous reviews. Thanks and Regards, Ash

€250 EUR en 3 días
(119 comentarios)
7.1
paris2785

Hello! My name's Paris and I was glad to see that you're looking for an Excel developer. You mention that you need somebody to develop the necessary code to deduct your physical stoick. I read tyour requirements and t Más

€200 EUR en 7 días
(166 comentarios)
6.8
dgled

I have considerable experience with energy modules in Excel and VBA. I prepare dynamic financial modules for renewable energy platforms, upon demand; the financial modules include a driver’s tab, debt/grand repaymen Más

€250 EUR en 3 días
(57 comentarios)
6.6
Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m Más

€120 EUR en 3 días
(158 comentarios)
6.5
archanaoswal

I can write a macro to deduct the stocks and generate the output as per the conditions specified I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Built a de Más

€150 EUR en 3 días
(87 comentarios)
5.9
satishtl

- Have done similar invoicing and Purchase orders, Inventory. - Went through both the files. Re 2018-0888 [login to view URL] trinkreif Bestandsliste NEU [login to view URL] - Will provide an option to select the invoic Más

€120 EUR en 2 días
(52 comentarios)
6.1
royalcalif

I wish to discuss little bit more about the project to calculate appropriate duration and cost as well. please pm me. Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100 Más

€30 EUR en 1 día
(83 comentarios)
5.5
mail2vimalarora

Hi, Being experienced in working on several excel/vba/macro related projects of various complexities, i can take up the task to complete as mentioned in the description requirement. I assure you of quick and efficie Más

€66 EUR en 3 días
(99 comentarios)
5.9
axiomswb

I have expertise in excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients. Please communicate to discuss in details. Thank you..

€80 EUR en 3 días
(49 comentarios)
5.8
sonarkaushik

Sir, I am very able to create a excel macro and can do your project as per requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to hear from you. Más

€138 EUR en 3 días
(111 comentarios)
6.3
abhinovpankaj

Hello, I have been working as freelancer since last ~ 6 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Más

€155 EUR en 3 días
(66 comentarios)
5.5
AlexandrUKR

i can send first version for your test within 3-4 days (and adjust if it will be needed within next 3-4 days) could you send the excel files?

€250 EUR en 7 días
(20 comentarios)
5.2
supper5guy

Hello there, as an excel and VBA expert, i can write such a macro to accomplish your described tasks. Please contact me and let us talk more about your project. Thanks

€100 EUR en 3 días
(61 comentarios)
5.1