Fertiggestellt

Excel - automated data collection from multiple workbooks with multiple worksheets with different headers

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

Fähigkeiten: Excel, Datenerfassung, Datenverarbeitung, Excel Macros , Excel VBA

Mehr darüber excel workbooks sheets update, excel aus txt file, excel vba opening closing workbooks, compare vba code excel workbooks, excel vba workbooks close error, vba excel workbooks, software excel workbooks smaller, compare excel workbooks, excel scheduling workbooks, webshop mit import aus excel, excel workbooks projects examples, vba excel algebra workbooks, merging excel workbooks duplicates, open excel files workbooks visual, protecting excel workbooks expiry, excel chart data from different workbooks, trump excel vba to combine multiple workbooks into one workbook

Über den Arbeitgeber:
( 0 Bewertungen ) Zurich, Switzerland

Projekt-ID: #29874525

Vergeben an:

(342 Bewertungen)
7.9

26 Freelancer bieten im Durchschnitt €27/Stunde für diesen Job

asin1987

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 he Mehr

€30 EUR / Stunde
(245 Bewertungen)
8.1
(1019 Bewertungen)
8.2
(368 Bewertungen)
8.0
(438 Bewertungen)
7.8
P0L

(480 Bewertungen)
8.0
(422 Bewertungen)
7.6
(177 Bewertungen)
7.8
(131 Bewertungen)
7.2
(308 Bewertungen)
7.3
(211 Bewertungen)
6.9
(182 Bewertungen)
6.5
(42 Bewertungen)
6.3
(149 Bewertungen)
6.7
(33 Bewertungen)
5.6
(65 Bewertungen)
6.1
(41 Bewertungen)
5.2
(69 Bewertungen)
5.3
(73 Bewertungen)
5.5
(38 Bewertungen)
4.9
Monirulop

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 Mehr

€18 EUR / Stunde
(23 Bewertungen)
4.0