Завершено

Excel VBA Macro: Collecting data in external files – Experts only.

Please read this carefully. The task is to locate Excel files having a specific filename (ie. starting with I 19, I 20 etc.) in a specific folder (incl. all subfolders) on a company drive (around 50 to 200 files).

Then, a worksheet should be extracted (it has always the same name) and copied to a new Excel File in the original folder. During the process, the extracted worksheets should be renamed with the filename from the original file. It should be checked, whether there are any changes from the last import to reduce runtimes, (unchanged files should be ignored). The original files should not be altered.

Then, in the newly created Excel file, certain cells (around 20, always the same structure in each worksheet) should be extracted to a new worksheet (eg cells E:8, G:8 and F:12 etc.) and written in one line in this new data worksheet (eg. “results”). While processing, the expected data structure per cell (text, date or number) should be checked, errors should be shown to the users (and the respective cells ignored).

We provide sample sheets of the original document and the target document with some test data (10 to 15 filled out excel files). In the target document, the cell references and the cell target format can be seen. Output is a smoothly running VBA macro generating the “results” worksheet in a flat data structure. The macro should be compatible to Excel 2013 to 2016ff and compatible to German syntax and formats (eg "1.000.000,00") and “20.11.2019”. Comments can be in English, we provide the translations for the error messages. Max. Budget is 80 USD.

Please add “understood” to your bid to show you have actually read this brief.

Квалификация: Excel, Visual Basic, Excel VBA, Excel Macros

Показать больше excel vba macro paste adjacent column, excel vba access sheet data, paste excel vba macro, excel vba macro databases, excel vba return xml data type, excel vba macro programming bids, excel vba macro calculate business days, excel vba macro find text morld, generate report excel vba macro, vba macro show data, vba macro cut data spreadsheet spreadsheet, excel vba update imported data, excel vba macro optimization, excel vba speed filling data, excel vba macro protect cell, download historical stock data excel vba macro, excel vba macro copy columns data, excel vba macro download yahoo stock data, read webpage data excel vba macro, write excel macro read data pdf files

О работодателе:
( 9 отзыв(-а, -ов) ) Leopoldsdorf, Austria

ID проекта: #22681039

Поручен:

MartinDudumi

Understood your project. I have done similar job on my previous project when i had to rename all of the files and transport the data to a new created file. 10 years working with data especially with macros will definit Больше

$77 USD за 1 день
(4 отзывов(-а))
1.1

6 фрилансеров(-а) в среднем готовы выполнить эту работу за $82

datakillers

Hi "We have good Microsoft Excel skills with years of experience as well as We have complete number of projects for Excel to manage data and [login to view URL] have Alison certified Employees for Microsoft Office and Microso Больше

$80 USD за 1 день
(209 отзывов(-а))
7.0
ineedWorkJob

Greetings sir,

$100 USD за 2 дней(-я)
(115 отзывов(-а))
6.4
vsprybhanu

“understood” Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating and Exchanging Data in M Больше

$120 USD за 3 дней(-я)
(84 отзывов(-а))
5.6
tusharvv76

“understood” Excellent description! All a programmer needs is precise information like yours. Are you a programmer yourself? I have FULL CONFIDENCE of completing this project using Excel VBA PRECISELY as you have sta Больше

$66 USD за 3 дней(-я)
(12 отзывов(-а))
3.7
engelnady

understood Hi, would you like to go with SCIENCE AND EXPERIENCE. I'm a Master holder in computer science and a developer expert for 10+ years. I'm an expert who pays attention to details and time as you could see in m Больше

$50 USD за 1 день
(6 отзывов(-а))
3.1