Package replacement of text in Excel documents with VBA tools
11 USD There are conditionally 200 files in which you need to replace the RAL code with your number, change the number of lines (from and before), replace the item and in the full name of the position to change the word according to the color of the rally.Nomenclature is the same everywhere.Only the number of the rally, the item relating to the rally and the word of full name are changed at its end.These columns to be replaced in each file are conditionally 4rd.Files 200+The algorithm of package processing if possible is:
Select the folder where the files will be processed in the "Have text" field in the files (required line 1, 2 or 4 as an example) the "Change text" field in the files as an option with the name of the file itself indicated (in which you need to change) and the window to enter a specific value to which to change in a specific column of a particular file.Well as an option in one file ("example") there are already forgotten data of one rally.You just need to make other files with the replacement of specific data in them.If possible, do not replace one word, but several (or several columns)
The example:
In these files you need to change the word "RAL 1000" to "RAL 1001, RAL 1002, RAL 1003 etc", Articles: -0014, -0016, -0020 etc.Or the word "smart" with another rally code changes to red and so on.If there is a ready solution or preparation ready to consider.Thank you all in advance for the possible help.Financial proposals are also welcomed.If there is real time savings.by P.S. A very hard replacement process.There may be a solution of familiar people that will accelerate the replacement process.
Client's review of cooperation with Ivan Moroz
Package replacement of text in Excel documents with VBA toolsSuper performance . Saving time for me.
The man explained and showed everything. I strongly recommend it to anyone who chooses similar performers.
Quality is worth your money.
10 of 10m.
Freelancer's review of cooperation with Yaroslav Sam
Package replacement of text in Excel documents with VBA toolsIt’s a pleasure to work with Jaroslav.
Clear task setting and friendly feedback in case of questions.
I definitely recommend!
-
Winning proposal6 days11 USD
744 99 0 Winning proposal6 days11 USD
Hello to you,
I do it quality and quickly.
Experience in Excel VBA over 5 years. You can see in the reviews.
I will be happy to help!
Current freelance projects in the category Desktop Apps
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 5 days 16 hours back ∙ 10 proposals |
Creation of software for generating cutting files for wooden puzzlesWe are looking for a developer to create software that automates the process of building cutting files for wooden jigsaw puzzles. Current Process Currently, each file is created manually by a designer in Adobe Illustrator. The file contains: the outer contour of the puzzle in… Desktop Apps ∙ 5 days 20 hours back ∙ 14 proposals |
Small edit on the website
16 USD
Need to update the offer agreement in the footer to a new one, the company has changed its regulations Task will take 20 minutes Web Programming, Desktop Apps ∙ 6 days 22 hours back ∙ 113 proposals |
Account reconciliation tool with the bank, cards, and accountantTechnical Assignment: Tool for Reconciling Accounts with Bank, Cards, and AccountantGeneral Goal A local tool (script/small application in Python) is needed, which is manually run once every 1-2 months on my computer and performs reconciliation between: Invoices I issued to… Python, Desktop Apps ∙ 9 days 5 hours back ∙ 44 proposals |
Kyiv