Käynnissä

Erstellen Sie ein Excel Macro

Build an Excel Macro that generates from file “trinkreif Bestandsliste NEU DD-MM-YYYY” the File “trinkreif Gesamtpreisliste DD-MM-YYYY” and saves it in the same directory as excel file. The file “trinkreif Bestandsliste NEU DD-MM-YYYY” is the existing. There we want to start the macro.

The file “trinkreif Bestandsliste NEU DD-MM-YYYY” uses only positive values in column R.

The marcro should start with the filtered fields of “trinkreif Bestandsliste NEU DD-MM-YYYY”. So we can filter the rows first and then start the marco and from there we get the according list.

The header in “trinkreif Gesamtpreisliste DD-MM-YYYY” (rows 1 – 13) always stay the same. Except 5E – there should be the actual date.

Columns V, W , X are constant in “trinkreif Gesamtpreisliste DD-MM-YYYY”. They are the order form for our clients.

In total “trinkreif Gesamtpreisliste DD-MM-YYYY” is a version where not all rows of “trinkreif Bestandsliste NEU DD-MM-YYYY” are used.

Two actual files are attached. “trinkreif Bestandsliste NEU DD-MM-YYYY” is a sample file. With only 10 products. Please consider that normally this file has about 20.000 rows.

The other file is our actual price list.

Taidot: tietojenkäsittely, Excel, Visual Basic, Visual Basic for Apps

Näytä lisää: excel macro read file txt, excel macro reading file, dat file excel macro, excel + makro programmierung, excel makro sammlung, excel 2016 makro erstellen, excel 2013 makro erstellen, excel makro ausführen, excel makro erstellen beispiele, excel makro button, makro erstellen tastatur, data entry, data processing, excel, visual basic, microsoft, microsoft office, visual basic for apps, microsoft excel, excel macro export column text file

Tietoa työnantajasta:
( 3 arvostelua ) Wien, Austria

Projektin tunnus: #17537493

Myönnetty käyttäjälle:

seaanddream

Hi, my name is Selim. I read your "Erstellen Sie ein Excel Macro" project descriptions carefully before bidding. I checked the attached templates as well... I got what you need and ready to go ahead as soon as we can Lisää

€180 EUR 3 päivässä
(269 Arvostelua)
7.7

14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

Webxpert4u

Hello, I am ready to create macro to generate from first file and will save data in same directory. We need to discuss in details. Highly experienced in Excel Programming, Excel automation and Macros. I am good at V Lisää

€294 EUR 3 päivässä
(181 arvostelua)
7.4
paris2785

Hallo! My name is Paris Pallas and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel because this is my favorite field and MS Excel projects are among the tasks I wo Lisää

€200 EUR 1 päivässä
(148 arvostelua)
6.7
danielgpratidya

Hi, So after you filter some fields and run the macro, column A-K will be copied to file "trinkreif Gesamtpreisliste [login to view URL]". And it should take only rows where col. R > 0. Am I correct? I have some fur Lisää

€90 EUR 1 päivässä
(203 arvostelua)
6.6
dgled

Hi, I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout Lisää

€250 EUR 3 päivässä
(54 arvostelua)
6.5
fatimatuzzohura

Hi, I am experienced on Microsoft Access , Excel and VBA. I can start your job immediately also. Please contact me to discuss the project in details. Thanks

€294 EUR 3 päivässä
(132 arvostelua)
6.2
jkaranm

Hi, My name is Janis and I have been here in freelancer since 2014. One of the preferred freelancer because of the good standing and have good feedback from previous employers. I was asked by the freelancer staff Albe Lisää

€250 EUR 5 päivässä
(20 arvostelua)
6.2
shafaqat11

Hello Sir, Thank you for posting the project. First! Your satisfaction is my top priority. I am interested in it. If you give me chance then i can start right now and able to provide best results. In short, I cou Lisää

€141 EUR 3 päivässä
(94 arvostelua)
5.7
vaidyag

HI, I have excellent experience in C#, Excel and Access and other Microsoft related technologies. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. I Lisää

€105 EUR 3 päivässä
(15 arvostelua)
5.2
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Willing to take up your project. Thank you, Regards.

€164 EUR 3 päivässä
(42 arvostelua)
5.2
jasalaz100

Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizi Lisää

€180 EUR 3 päivässä
(22 arvostelua)
4.7
supergana

Hi - I had a look at the files, they look almost similar to me, except for some formatting required. To build a macro for this is no big deal, but we need to discuss the specifics. I am an IT professional with 2 de Lisää

€196 EUR 3 päivässä
(21 arvostelua)
4.2
Diliphero

Greetings, I am professionally qualified Business & Financial Consultant from Sri Lanka with a degree in Management & Finance. I am very proficient in VBA, Macros and Excel dashboards. My business and financial backg Lisää

€250 EUR 7 päivässä
(11 arvostelua)
3.9
rickygzz85

I am an experienced programmer, using Excel and coding in VBA Excel Macros for more than 20 years. I offer - Quality. Everything organized, excellent grammar, proper indentation comments on the code. - Availabili Lisää

€100 EUR 3 päivässä
(9 arvostelua)
3.1