Office 365: Excel Online: Merge Data from Multiple Workbooks into a Summary Workbook
- or -
Post a project like this2236
$
- Posted:
- Proposals: 12
- Remote
- #1884775
- Awarded
MS Excel, SPSS, AMOS, R, STATA, Power BI, Tableau - Data Analyst, research and insights and Creative Writing
Islamabad
Data entry specialist, Graphic designer, photoshop, Excel,website design & development
Hyderabad
195642911141281119568138759415203741888689196367919681031977842205509120812852081384
Description
Experience Level: Entry
General information for the business: We sell furniture, kitchens, wardrobes, doors
Description of requirements/functionality: We sell furniture, kitchens, wardrobes, doors.
We are located in three different cities (City 1, City 2, City 3)
Each city is divided in two departments (Department 1, Department 2)
We issue all quotations and sales orders in OneDrive.
We save Quotations and Sales Orders in the following structure:
>Quotations and sales orders
>City 1
>Department 1 (Quotations and Sales Orders of department 1, located in city 1)
>Department 2 (Quotations and Sales Orders of department 2, located in city 1)
>City 2
>Department 1 (Quotations and Sales Orders of department 1, located in city 2)
>Department 2 (Quotations and Sales Orders of department 2, located in city 2)
>City 3
>Department 1 (Quotations and Sales Orders of department 1, located in city 3)
>Department 2 (Quotations and Sales Orders of department 2, located in city 3)
I need to collect in a single file all details of Quotations and Sales Orders from all above folders.
File names for each Quotation or Sales Order are unique:
e.g. for a Quotation the file name looks like:
YYMMDD 00001.0QUOTATION CITY DEPARTMENT SALESPERSON (CLIENT)
an actual name: 180204 00001.0QN NS CC CK (JOHN WEST)
e.g. for a Sales Order the file name looks like:
YYMMDD 00001.0SALESORDER CITY DEPARTMENT SALESPERSON (CLIENT)
an actual name: 180204 00001.0SL NS CC CK (JOHN WEST)
Extra notes:
Description of requirements/functionality: We sell furniture, kitchens, wardrobes, doors.
We are located in three different cities (City 1, City 2, City 3)
Each city is divided in two departments (Department 1, Department 2)
We issue all quotations and sales orders in OneDrive.
We save Quotations and Sales Orders in the following structure:
>Quotations and sales orders
>City 1
>Department 1 (Quotations and Sales Orders of department 1, located in city 1)
>Department 2 (Quotations and Sales Orders of department 2, located in city 1)
>City 2
>Department 1 (Quotations and Sales Orders of department 1, located in city 2)
>Department 2 (Quotations and Sales Orders of department 2, located in city 2)
>City 3
>Department 1 (Quotations and Sales Orders of department 1, located in city 3)
>Department 2 (Quotations and Sales Orders of department 2, located in city 3)
I need to collect in a single file all details of Quotations and Sales Orders from all above folders.
File names for each Quotation or Sales Order are unique:
e.g. for a Quotation the file name looks like:
YYMMDD 00001.0QUOTATION CITY DEPARTMENT SALESPERSON (CLIENT)
an actual name: 180204 00001.0QN NS CC CK (JOHN WEST)
e.g. for a Sales Order the file name looks like:
YYMMDD 00001.0SALESORDER CITY DEPARTMENT SALESPERSON (CLIENT)
an actual name: 180204 00001.0SL NS CC CK (JOHN WEST)
Extra notes:
Charis K.
100% (9)Projects Completed
10
Freelancers worked with
7
Projects awarded
92%
Last project
30 Dec 2023
Cyprus
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Sir, how many entries do we need to enter?
585428
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies