Automate extract External data from several excel files to Excel main file VBA Macro mapping
$10-30 USD
Teslim sırasında ödenir
INSTRUMENTS
I have a [login to view URL] (attach)where I do have:
- 4 sheet tabs in RED that have code (please dont touch)
- 10 sheet tabs for products providers (PR_).
The providers are identified in sheet tabs in the Main_file with "PR_" following the providers name: PR_GLOBOMATIK; PR_ASEUROPA; PR_INFORTISA.....
MANUAL PROCESS THAT I USE
1 - I download to my laptop, from my suppliers, each CSV/XLS file that they provide me, with products and all the data, like prices, stock description and so on.
Look for example these 2 supplier files:
PR_GLOBOMATIK
PR_INFORTISA
2- I then open each file PR_GLOBOMATIK/PR_INFORTISA csv/xls file from suppliers and I manually copy the data that I will paste in the sheet tab of the "Main_File" (Example EAN/PRICE/STOCK).
For example(image_1) you open the PR_GLOBOMATIK file and select all the EAN column values (including empty spaces); PRICE; STOCK... and
3- Paste the data in PR_GLOBOMATIK, sheet tab of Main_File (Image_2)
4- I repeat this task for all the 10 suppliers before run processes and put the products in the market.
MAYBE PROBLEMS:
MAPPING
THE HEATHER TITLES IN THE "MAIN_FILE" ARE THE SAME FROM PROVIDER TO PROVIDER (PR_) BUT FILES FROM SUPPLIERS THEY ALL HAVE THE DATA THAT I NEED TO COPY, BUT THOSE CSV FILES ARE DIFFERENT IN STRUCTURE BECAUSE THEY USE DIFFERENT HEATHER TITLES
PROJECT
I dont need to automatically extract to the "Main_file" all the columns from PR_ providers CSV files but only this fields:
EAN
PRICE
STOCK_Quantity
PRODUCT_NAME_post_title
SHORT_DESCRIPTION_post_excerpt
LONG_DESCRIPTION_post_content
PRODUCT_FAMMILY
CATEGORY
MANUFACTURER
URL_IMG_1
URL_IMG_2
URL_IMG_3
URL_IMG_4
SOLUTION
I can try to map the "Main_File" PR_ providers heather titles to each supplier csv, by name and/or column...
QUESTION
I assume that you will code a button in the "Main_file" so, when I want, the data will be extracted to the right PR_ from the right csv/xls file. This code should be compatible with the existing code in "Main_file, right?
If we go ahead, where do I put the 10 suppliers csv/xls so when I click the button the code will know where to search and how to search?
Thanks
Proje NO: #24481202
Proje hakkında
Seçilen:
Hi Vitor, I will make Visual Basic code to import data from different file in master file as per your requirement with good and professional quality without any error. I have completed more then 100 project within 8 mo Daha Fazla
Bu iş için 14 freelancer ortalamada $26 teklif veriyor
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 260 projects successfully completed here. I can write a macro that "imports" the .csv / .xls files Daha Fazla
Hi, how are you ?? please check my profiles?? I have understand the project requirement & interested to work for this project. I will start right now and I will do it before your time . Please send a message so we can Daha Fazla
Hello! I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko? Daha Fazla
$29 only ------ In just 12 Hours ------ I can make VBA Macro Module for you to pull data from PR_s and place it to right PR_s absolutely as you want by maintaining 100% accuracy of your data ------- Excel VBA Macro Co Daha Fazla
Hi I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VBA. I'm professional Ms Access/Excel/vba coder. I'm coding in vba since Ms Office 97 released. I've viewed your xlsm with mo Daha Fazla
Given enough explanation. Yes I understood. I can do. I'll finish by today... please chat directly.. siva.,.....
Hello there, I am an senior automation developer with years experience and specialist in Python and VBA Excel. I have solution for your requirement. The current issue is that you have to collect data from different fo Daha Fazla
Hello, this is Yazan, I’m a university student, striving towards showcasing my skills and obtain data entry experience. Hence, I will be available to work with a flexible schedule. Moreover, I’m a self-motivated indivi Daha Fazla
Hello, I have a background of 4 years of experience in Microsoft Word, Excel, PowerPoint and Research I have read the job description and specifications carefully understood the job and are ready to work immediately. Daha Fazla
I am a Data Analyst with over 13 years of experience. I have worked in similar kind of project and can assure you the best solution. I will ensure you that your data will be accurate and on time as per your requirement Daha Fazla
Hello! I'd like to express my interest in your project. I am a Public Relations graduate with over 2 years experience in marketing, advertising, account management and customer acquisition. I am well acquainted with Daha Fazla