...transforming BOM (Bill of Material) data of multiple items in one sheet to separate sheets. E.g. - A Fan is made from 3 Nos blades, 1 Nos motor and 10 Nos screws. 1 motor in turn is made from 3 m wires and 2 Nos plates. [Nos and m are Unit of measurement - Number and Metre respectively] So our master excel sheet contains data as - Fan | .1 | Blades
For this sheet [url removed, login to view] [url removed, login to view] I would like you to go through all tabs as long as the name is not macro and copy all and then paste the values over it so it is no longer a formula
About Macro (XBA file attached) We have an excel macro which adds a menu to excel(we use libreoffice4.4 in Linux). In this menu when you click one of the option in a menu a dialog box opens(image attached). It takes all the inputs from the dialog box and pass them as arguments to a Perl script and execute the script. Required modification: 1)
we want to build Mobile application in Oracle Application Express (apex) for our sales team. Our team will use this app for the feeding of sales order , daily visits plan , and tracking of stock at our customers end ( which will be recorded manually at daily basis)
...management process for companies (mid size and corporates). The project is key for achieving the business in the SME segment. The system is inhouse developed, using Oracle APEX technology (Apex 5, Oracle DB 12c). The bank has internal team, still developing it, but it is busy with the integration program of the banks, and does not have enough capacity for the
...(sometimes hyperlink can be broken) of a PDF document. I need a macro that can open that hyperlink and save PDF document with specific name as per email subject (i.e. [url removed, login to view]). Once download is completed macro should mark that email as read. Macro should work within excel as I want to keep track of all files downloaded in a single
This project is for two Excel Macros: This will be run daily/weekly The first Macro will convert a web scrape .csv file to another .csv file. It will always remain the same, format/template, however, the data in the file will always be different. The output of this Macro will be used in the next macro project.
Hi, I would like someone to write me a responsive webapp with Oracle JET that includes a definite number of multiple choice quizzes or short answer question. The quizzes will be timed per question that can be set in the app settings. The app has a version for multi quiz taker. The system or the users select a quiz, and each answer the quiz. The
I have excel sheet which contains some data points and I need Freelancer to create a VBA Macro code to transfer required details into PDF Files as per the Conditions given, so basically write a Macro which can take details from excel and write it down to PDF as per instructions. Do not bid if you can't do it, lowest bid will be accepted!
I have an Oracle APEX application that uses APEX Accounts authentication. I need a way to allow login only if the user logins from a known computer, from a known location. Most users log in from the offices which have shared IP address, so IPs are not sufficient to validate an individual user
I have a spreadsheet with a lot of data which will be shared with many users. I would like the sheet to automatically hide rows based off of a constraint. For example, all rows with cells in column A that have contents "hide", will be automatically hidden. It is critical that the macro works for excel users in both Mac and PC. Is this possible
*** DO NOT APPLY IF YOU ARE NOT IN SYDNEY *** A client needs to get a Excel Macro writer to modify a current Excel Spreadsheet or possible create and customise it to the clients requirement. This will require an initial onsite meeting with the client in Brookvale - Sydney This could lead to more regular work Please do not apply if you cannot
Technical Experts: Expert level knowledge in one (or more) of several Oracle areas Performance Tuning Backups/Restore DB Security DR/Replication (Data Guard/Golden Gate) Oracle Engineered Platforms (Exadata/ODA) Bonus experience in automation tools such as Ansible, Chef, Puppet etc, Communication Experts: The ability to directly communicate effectively