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

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

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.

Excel VB.NET Visual Basic

Project ID: #12627593

About the project

28 proposals Remote project Active 7 years ago

Awarded to:

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 More

€10 EUR in 1 day
(17 Reviews)
4.5

28 freelancers are bidding on average €25 for this job

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 More

€34 EUR in 1 day
(204 Reviews)
8.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 More

€30 EUR in 1 day
(242 Reviews)
7.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 in 1 day
(342 Reviews)
7.4
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 in 2 days
(142 Reviews)
7.2
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 More

€40 EUR in 4 days
(242 Reviews)
6.9
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 More

€30 EUR in 1 day
(126 Reviews)
6.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 More

€30 EUR in 3 days
(86 Reviews)
5.7
sajibdigital

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

€24 EUR in 1 day
(65 Reviews)
5.6
osmemon

I have been involved in excel for the past three years. Very well versed on macros and have done freelance jobs related to VBA and macros. Looking forward to your reply

€15 EUR in 1 day
(34 Reviews)
5.6
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 More

€19 EUR in 1 day
(63 Reviews)
5.7
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 More

€24 EUR in 1 day
(7 Reviews)
3.8
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 More

€30 EUR in 2 days
(9 Reviews)
3.5
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 More

€11 EUR in 0 days
(8 Reviews)
3.1
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 in 2 days
(1 Review)
1.7
stocktimemachine

Hello I am a programmer. It is available both Visual Basic and delphi. I have some work, in an Excel spreadsheet. We aim to serve you with quality and commitment to accuracy. i will use formulas of excel and i will don More

€8 EUR in 3 days
(1 Review)
1.5
mazoz

no need to pay me unliss all job is done I have more than 8 years experience in IT field, Microsoft servers, Exchange server, firewalls, networking, Symantec backup, system administration, DNS, DHCP

€10 EUR in 1 day
(0 Reviews)
0.0
insaninsan

Hi i am Insan Ramadhan, i am used to work with excel and macro VBA everyday. You can count on me to work on your report, i will try my best to deliver the task.

€25 EUR in 2 days
(0 Reviews)
0.0
Nimbus007

Hello Sir I can do this work please contact me here on freelancer website for further concern. I have really good experience as Data entry operator also have 3 people team working on freelancer, this is my new ID. More

€18 EUR in 1 day
(0 Reviews)
0.0
kiansiong

A proposal has not yet been provided

€29 EUR in 1 day
(0 Reviews)
0.0