Færdiggjort

Excel File Combining Automation

Note: All related files and folders in the attached “ISP Excel Project Files” Zip folder.

Problem:

Each day we run a report that generates multiple Excel files (xlxs) in a folder. The file names always follow the same convention ([login to view URL], [login to view URL], [login to view URL]…) but the number of files is not consistent day-by-day.

In the Zip folder, please refer to the “01-Project Docs” folder for an example of the output files.

The content layouts of each Excel file are the same. There is a single sheet inside labeled “Sheet2”. A1 and A2 is always the header and B1 and B2 is always the data. The header is always the same (Account Name and Booking Number), but the data is unique.

In the “01-Project Docs” folder, please refer to the “[login to view URL]” file for an example.

In order for the data to be useful, we need all the data in one file, all on the same sheet.

In the Zip folder, please refer to the “02-Final” Folder and “[login to view URL]” for an example of our final result.

Action:

We want to combine all the files into a single file named [login to view URL] with all the data on a single sheet. The result needs to have the original header (A1 and A2) with the data listed sequentially below (A2 and B2, A3 and B3….).

Result Suggestions:

The more automatic the process, the better. Because these files are generated sequentially, the process should wait a brief period to ensure all the files have been completed.

Ideas we think could be a solution:

1. For the solution to be triggered by the creation of a specific-named folder in a specific location (ie: on the desktop) that triggers the process to run on the folder contents.

2. For the solution to monitor an existing folder that someone can drop and drag the files into to trigger the process.

3. A runnable app with a dialogue box that allows us to select the files to combine and a button to trigger the process.

Thank you!

Evner: Excel Macros, Excel, Databehandling, Process Automation

Se mere: creation excel file, convert excel file address book, program sort excel file, search excel file vbscript, save datagrid excel file, create excel file visual, contact excel file, excel file dog breeds, reading excel file text mining, decompile entire excel file full source code, price list excel file, open excel file automation, visual excel automation open excel file, indian customer all details list in excel file, listing all the folders subfolders and files in a directory using php, create multiple folders from excel file

Om arbejdsgiveren:
( 0 bedømmelser ) Wading River, United States

Projekt ID: #31595040

Tildelt til:

(221 bedømmelser)
7.0

29 freelancere byder i gennemsnit $371 timen for dette job

(828 bedømmelser)
8.9
(263 bedømmelser)
8.0
(257 bedømmelser)
8.2
(442 bedømmelser)
8.3
P0L

(486 bedømmelser)
8.0
(373 bedømmelser)
8.1
(311 bedømmelser)
7.4
(217 bedømmelser)
6.7
(93 bedømmelser)
6.3
(15 bedømmelser)
5.8
(53 bedømmelser)
5.9
(67 bedømmelser)
5.5
hayteekeys

Hello. From your job description I have learned that the requirements you have asked for are possessed by me very well. I am a graduate of computer science. Also, I have several good records in this field as I have be Flere

$250 USD på 1 dag
(15 bedømmelser)
4.5
(31 bedømmelser)
4.2
(6 bedømmelser)
4.1
maurineted5

A Data Scientist with experience in SPSS, Python, R programming, R studio and anything related to data science and EXCEL guru, who is dynamic, reliable, resourceful, committed and organized with enthusiastic approach t Flere

$500 USD in 7 dage
(11 bedømmelser)
4.0
(3 bedømmelser)
3.1
jinhui12

Hi Sir, This is Lan and I am a UiPath automated process expert, and I can use UiPath to create an automated process to complete this process. Any one of solution1-3 can be realized. Can we discuss more details about th Flere

$250 USD på 1 dag
(10 bedømmelser)
2.9
(3 bedømmelser)
1.8
(2 bedømmelser)
1.4