Automate extract External data from several excel files to Excel main file VBA Macro mapping
$10-30 USD
Thanh toán khi bàn giao
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
ID dự án: #24481202
Về dự án
Được trao cho:
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 Thêm
14 freelancer chào giá trung bình$26 cho công việc này
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 Thêm
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 Thêm
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? Thêm
$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 Thêm
Given enough explanation. Yes I understood. I can do. I'll finish by today... please chat directly.. siva.,.....
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. Thêm
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 Thêm