En cours

build the macro vb codes and formulas for my excel file.

I have existing Excel file, i have created the formulas on some cells, but there are some functions that I need help with:

INPUT sheet

1. Autofilter the rows on value changes.

2. Autorefresh the Pivot when values on the screen changes.

3. Formula in STOCK WARNING (cell F4), If Part Number (Cell H3) includes "Recheck", then criteria is: N5<J5;"STOCK NOT ENOUGH";)

Formula in STOCK WARNING (cell F4), If Part Number (Cell H3) has other values, then criteria is: K5<J5;"STOCK NOT ENOUGH";)

4. Make an Export Button that will copy the active values in another sheet. on its format and export that sheet to a new xls file.

Print Sheet

5. Make a sheet that will act like a form, it will show data from the Input sheet.

Compétences : Excel, VB.NET, Visual Basic

Voir plus : convert excel file formulas pdf file formulas, excel file icd codes, excel file search 2010 macro, email excel file php formulas, vb codes excel work easily, import text file excel vb script, importing excel file multiple sheets vb net, import file excel vb net, import excel file power point macro, exporting text file excel vb script, convert excel file pdf ms access vb, automatically build graph text file excel, macro post data excel file, macro import multiple text files excel file automatically, macro copy excel file, macro copying conten excel file, copy data paste anther excel file macro, list cities county zip codes usa excel file, excel file macro asp excelapplication, macro copy paste excel file, solidworks macro excel file, macro convert dat file excel file, converting dat file excel, attched word file excel, convert dat database file excel

Concernant l'employeur :
( 16 commentaires ) Kiel, Germany

N° du projet : #12627593

Décerné à :

draco77

Hey there, From the sounds of it, you need Excel expert who can write vba code, write optimized formulas and present data in a simple way. Is that sounds about right? I have an extensive knowledge of Excel included Plus

10 € EUR en 1 jour
(2 Commentaires)
1.2

29 freelance font une offre moyenne de €25 pour ce travail

someka

Hi there. Regarding your needs on your excel file, as being one of the highest rated Excel & VBA expert in this platform, I can work on your job. I am mostly online. Lets discuss more on chat.

43 € EUR en 2 jours
(120 Commentaires)
6.8
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Plus

40 € EUR en 4 jours
(163 Commentaires)
6.6
SBITServices

Hello jeitaro, I have read your project description clearly and understood you requirement and agree that can complete task with high quality and [url removed, login to view] our reviews to confirm our work quality(100%completi Plus

15 € EUR en 1 jour
(122 Commentaires)
6.5
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

30 € EUR en 1 jour
(121 Commentaires)
6.4
dpune

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 300 projects. Plea Plus

30 € EUR en 1 jour
(111 Commentaires)
6.2
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach y Plus

30 € EUR en 1 jour
(101 Commentaires)
6.1
nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details Plus

19 € EUR en 1 jour
(59 Commentaires)
5.7
23 € EUR en 1 jour
(17 Commentaires)
5.3
vsprybhanu

Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating Data from Multiple Sheets, Advanced Formulas, Critical Progr Plus

30 € EUR en 3 jours
(44 Commentaires)
4.8
sandroshubladze

Hello, I am excel expert and VBA programmer I have done very similar project to yours recently (client wanted using few criterias to fitler huge data copy in new file and print - handled in 2 hour) I can help you o Plus

34 € EUR en 1 jour
(15 Commentaires)
4.1
sajibdigital

Hi, I am interested to work with you. Please contact me on chat, I am waiting for your response. Thanks Sajib.............................

24 € EUR en 1 jour
(14 Commentaires)
3.8
12 € EUR en 1 jour
(11 Commentaires)
3.8
royalcalif

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec Plus

30 € EUR en 1 jour
(15 Commentaires)
4.0
johnosullivan

hey - I've a lot of experience with VBA and Excel and I've also worked as a developer in the financial services industry for over a decade - happy to discuss your project in the chat window if you like my profile. than Plus

24 € EUR en 1 jour
(7 Commentaires)
3.8
ksinghrajeev

Hello There, Here are some examples of my work. Project Report Automation - [url removed, login to view] Log Report Automation - [url removed, login to view] Plus

40 € EUR en 3 jours
(7 Commentaires)
3.7
23 € EUR en 1 jour
(5 Commentaires)
2.6
8 € EUR en 1 jour
(8 Commentaires)
2.6
tandonshailendra

Evidently you need auto operative type macro. This box has limited space and no provision for attachments. I am Mechanical Engineer, proficient in MS Access, Excel Macro, Pivot Table/charts with slicer, dashboar Plus

30 € EUR en 2 jours
(7 Commentaires)
3.1
InnocentSathish

Hi, Thanks for showing your interest to read my bid. About your project: I guess this task can be done in hour. if you could send me the sample file i will make changes as per your requirements and send it back to Plus

11 € EUR en 0 jours
(5 Commentaires)
2.2
scientificstuffs

Hi, I can do it. I can either give you refresh buttons or let the system do it by its own. The second program will be longer though and would take 3 days.

35 € EUR en 2 jours
(1 Commentaire)
1.7