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

en 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é à:


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

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% EUR en 1 jour
(2 Commentaires)

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


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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(120 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 4 jours
(163 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(122 Commentaires)

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(121 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(111 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(101 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(59 Commentaires)
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(17 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(44 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(15 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(14 Commentaires)
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(11 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(15 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(7 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(7 Commentaires)
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(5 Commentaires)
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(8 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(7 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 0 jours
(5 Commentaires)

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(1 Évaluation)