I have a large list of part numbers and descriptions. I need to see if each part number listed in a column is also listed in another column. If the part is listed i need to know a certain result.
We are a Design and Construction company and currently use an excel sheet to monitor particular projects. This sheet holds data on projects we are currently delivering including, who project manager is, level of focus required, possible savings & possible variations etc. We now require this to be able to automatically generate a single page pdf report
I need a basic VBA program to analyze the data from each group of the files provided. Refer to the instructions for further details. This project should not take more than an hour or two to complete, especially if you are familiar with VBA (Excel).
i have xls generated by program, i wanted it open in excel file with group, sub totals and with nice design
...supported by documentation automation and automated processes. We are looking for a programmer to support and extend this automation. The role is a contract position, with regular contract work of approximately 7 to 10 hours a week, with extended hours during project periods. The role primarily involves Python and SQL scripting within the firm’s...
Need a VBA reconciliation script to compare 2 spreadsheets. Look for 4 key fields (contained within each sheet) , compare between them and on a 3rd sheet return the (entire)rows where there are key field differences, highlighting those differences. Plus any rows that are missing between sheet1 and sheet2.
...dashboard every month with a list of projects done by 4 centers that affect 16 different locations. In excel the data is manipulated using pivot tables to generate graphs and tables for 10 different slides. The goal is to automate the process with macros and/or VisualBasic so we extract the data and with a macro, we create th...
Attached is my excel sheet some of the code I have modified and some I have added. I want to add a date picker in D5 and D6 on the Sheet titled Input. I also want the Calendar to function on Calendar tab. I cant get it to let me select a new date. not sure what I am doing Wrong. I actually think that the form needs to be reworked. So I need the calendar
I have all the data and formulae. I need a guy who can keep all this data in excel sheet and run the VBA program. Its like writing functions of formulas in VBA and calling them in excel sheet.
I need a code in VBA that will copy streaming data from open website in chrome/explorer every 1(this website is refreshed automatically) minute and save it in historic format.
Make a simple program by VBA Excel to send excel data from spesific files, sheet to google sheet file. Attached example of data need to transfer.
...Thank you for your understanding== An MS Access project went much different from what was intended. In a nutshell, the project is a customized stock management system with 5 different user levels. Each level has different permission for functionality and data accessibility (see [url removed, login to view]). Authority level: Level 1 > 2 > 3 > ( 4 == 5). Le...
I need a quick VBA routine written into a spreadsheet. Functionality as follows: 1. Read a certain column cell by cell downwards till the end of the data and copy all the values into a variable as a single string. (This is a SQL statement per screen shot) 2. Execute the SQL statement against an Oracle database (connection string to be hardcoded) 3
Set up a shared database that imports data from a number of Excel documents, runs some predetermined macros on the data and stores it all in a database that can be queried by external scripts. Also needs the ability to store arbitrary data files (JPG, PDF etc) along with the data.
I've got an assignment with a few tasks. I have a excel file with some data that should be corrected with VBA. For example: "create sub/function that changes the date in the field to the “correct” format" and "you should create a sub/function that, at the click of a button, generates fitting graphs for the...
- Your project consists of developing an Customer Relationship Management software for airline company that allows business owners to check the performance of the business using graphical interface and representation of the data of their business, includes but not limited to the following: o Customer database o Services database o Service price database