Excel - automated data collection from multiple workbooks with multiple worksheets with different headers
€18-36 EUR / hour
Terminado
Publicado hace alrededor de 3 años
€18-36 EUR / hour
We are a Swiss (Zurich) building materials trader with a VAT registration in France.
Every month we have to report purchases/sales to the FR authorities and work with a partner in France.
All transactions are recorded manually in Excel and the completed Excel sheets are sent to our partner for further processing. In order to obtain an overview of all transactions (1 transaction = 1 line), the data should be merged into one large list.
This is to be done retrospectively for the historically existing data and in addition an automation is to be achieved that pulls together all future data from newly generated workbooks.
Data:
-12 Workbooks / year
-1 Workbook / month
-14 worksheets / workbook of which 1 sheet = summary (pivot, of 11 worksheets), 2 worksheets with data input by our partner (no pivot, no influence on summary)
-Historically, 46 workbooks have already been created (since February 2017)
-400-500 transactions have been generated.
Data, or transactions, are entered into the corresponding worksheet according to the appropriate category.
The worksheets are all formatted as tables, but have different headers.
The columns have different formatting (date, currency, numeric, text) and in a few columns the data (VAT) is calculated with a formula.
Why we cannot solve the problem ourselves / challenges:
-Tables in worksheets have different headers (should stay that way).
-Automation, linking and storage of new worksheets unclear
Attached are screenshots and an example of a worksheet with some sample data.
If we award you this contract, we will require you to sign a Non Disclosure Agreement because it is confidential information.
If you feel up to this challenge, we look forward to hearing from you.
Kind regards,
Yanick
Dear Employer,
I am an Excel expert and have delivered over 1000 projects since over a decade now. I have checked your project details and will ensure highly professional delivery.
Kindly check my previous reviews here for your kind consideration: https://www.freelancer.com/u/asin1987
Hope to connect soon!!
Thanks,
Ashish
Hi,
I am ready to start right now.
I can help you with your project according to your requirements. I am interested in your project.
I ensure I will complete the task successfully and within the specified time.
I love the perfection of work. You can see an example of one of those project in my portfolio here: https://www.freelancer.com/u/Monirulop
If you are interested to work with me message me, waiting for your message.
Thanks! and be safe,
Monirul
Good day,
I am Paul, professional web research and excel sheet data expert. I am ready to START work now on your project.
I have read your order details. And really understand the data and information you want. I have helped other clients with similar tasks to get information on a specific company, marketing, industry data as yours.
I am an excellent researcher. I don't just find the information I research to ensure what I get is useful factual and marketable information. I hold a master degree in management and very competent in what I do.
I can adequately handle this task for you within your stipulated deadline. I am an expert in internet search and can get the most hidden and minute information from the web.
See links to previous similar tasks done .
https://www.freelancer.com/projects/virtual-assistant/FIND-Payout-provider-for-Ukraine/reviews
https://www.freelancer.com/projects/data-entry/online-data-research-multiple-industry/?w=f
https://www.freelancer.com/projects/Marketing-Data-Mining/Market-Research-for-Niche-Chocolate/reviews
https://www.freelancer.com/projects/research/managed-medicaid-market-research/?w=f
https://www.freelancer.com/projects/research/internet-research-filter-needle-market/
https://www.freelancer.com/projects/data-entry/find-footwear-retailers-distributors/
https://www.freelancer.com/projects/internet-marketing/need-sports-betting-email-list-10946809/
Hello,
I have been an Excel expert for many years.
I can automate your Excel files thanks to macros and to an organization of archiving of a file (name, directory).
In order to study your expectations more precisely, could you give me the characteristics of the desired list.
Best regards.
Jerome in France