In Progress

Make Makro for finding empty categories in an exel worksheet and export file for importing

I need to find empty categories in an Epages Webshop.

I provide an Excel Worksheet with the tabs. On tab is a Shop CSV Export.

-Category List

-Product List

-Matching List Products to Categories.

At the end i need a Makro for the worksheet, which marks empty categories as invisible, categories with content visible and make a csv file in the right style for direct import in the shop. Every tab has the csv export, so you know the right style.

Also it shoud be flexible. When in the worksheets are coming new tabs in the same style, you makro should also work properly.

The user should also be able to choose

- make empty categories invisible

- make categories which are not empty, visible

and the makro should work with it.

Skills: Data Entry, Data Processing, Excel, Visual Basic

See more: excel create new sheet from data, transfer specific data from one worksheet to another for reports, excel vba copy cells based on criteria, how to transfer data from one sheet to another in excel using macros, excel vba write to cell in another sheet, transfer data from one excel worksheet to another automatically, macro to copy data from one sheet to another based on criteria, macro to copy specific columns from one worksheet to another worksheet, vba worksheet names file, create export file within ups world ship, excel oleobject export file, sql export file sql, chrome render excel export file correct, oscommerce order export file format, read worksheet extract file, export file excel vb6 save print, vbnet export file database, simply accounting export file structure, outlook macro export file, prostores sample export file

About the Employer:
( 12 reviews ) Düsseldorf, Germany

Project ID: #18771392

18 freelancers are bidding on average €103 for this job

prameswara

Hello Sir Im excel VBA macro and formula Expert I can do make macro for find empty data in your excel worksheet Sir please ping me now and im free now Thank you Galih

€100 EUR in 3 days
(357 Reviews)
7.1
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

€150 EUR in 5 days
(222 Reviews)
6.9
mrbrave

Hi, Reading descriptions, this seems to be couple of hours work for Experience macro developer. In 7 years of professional Excel developer career, I have developed hundred's of Excel macro. Using my experience, More

€70 EUR in 1 day
(254 Reviews)
6.7
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. ok, we can discuss further on the requirement for confirmation. Wi More

€155 EUR in 3 days
(94 Reviews)
6.1
macroPOL

Hello, I am Excel and VBA expert. Could you provide the file? Please note that I have 100% completion rate and 5-star feedback on over 80 projects. Jan

€100 EUR in 3 days
(95 Reviews)
6.0
mateenbhatti94

Dear sir I have read the requirements and completely understand the project.I will make a macro that will find the catedories that are empty and then will make them invisible. I have been in this industry for 1 yea More

€150 EUR in 1 day
(68 Reviews)
6.0
sloker18

With respect to this project I would like to present myself as a candidate for your consideration. I am proficient with Microsoft Excel and marco/VBA development. I read your project descriptions carefully, I can write More

€100 EUR in 3 days
(73 Reviews)
5.6
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

€80 EUR in 2 days
(86 Reviews)
5.5
dalsaniyasonu123

Hello, I am ready to discuss project with you. Being experienced in working on several excel projects related to macro/formula/vba/functions/charts etc. Based on that i can quickly help you in getting your project More

€100 EUR in 3 days
(25 Reviews)
4.5
RushService

Feel fee to contact me for making [login to view URL] me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [login to view URL] payment only after the work More

€150 EUR in 3 days
(10 Reviews)
4.4
Ahmed818

Hello, i am expert in this kind of jobs samples of my excel VBA jobs https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-run- More

€50 EUR in 1 day
(40 Reviews)
4.3
KozlouAlex

Hello. Below are examples of my recently completed project similar to your requirements: Smart VBA Excel Sheet - https://www.freelancer.com.ru/projects/data-entry/vba-excel-compare-count-sort/?w=f Flexible VBA cust More

€130 EUR in 2 days
(10 Reviews)
3.6
shahinrahimi

I can help you. I have rich experience in excel and VB, and I do my best to save your time and pocket. contact me. MySkills: • Data Management ..............................{Excel, Matlab} • Programming ........ More

€100 EUR in 3 days
(13 Reviews)
3.5
Monirulop

Hi Nevatia, I am Monir and it will be my pleasure to assist you with this project. I have read your project description and I am available and ready to work on it. I am working as a freelancer and as a Virtual Assist More

€55 EUR in 1 day
(3 Reviews)
2.5
mohitktilwani

Greetings, I am an advance excel user with +8 years of experience data analytics. I have designed multiple custom data collation files using VBA & Macros. I can create the file and provide the necessary flexibility. More

€66 EUR in 2 days
(1 Review)
0.4
ChineseJin

Hello Dear! I read your project proposal carefully and understood clearly what you want. I am high skilled and rich experienced for your project.. I can do your project in a hour. I hope to discuss about your proje More

€111 EUR in 3 days
(0 Reviews)
0.0
imashicham

I will copy writing and data entry so, I can help your works and I think I can prefect finish with project return you.

€34 EUR in 2 days
(0 Reviews)
0.0
royamrita53

I won't disappoint ...and will complete task in time

€155 EUR in 3 days
(0 Reviews)
0.0