Excel file has two sales reports on one sheet. I have 24 files to modify. Anywhere from 600 to 3000 records for each file. I need help writing a macro to sum the dynamic range of sales for Sales Report 1 and Sales Report 2, even though the total field/cell will always be in a different spot on each report. I've written some of the macro. ***
...[url removed, login to view] I will send as a seperate link the items to add This is a fixed priced job, You can bid above the range bid, I will consider all offers whether high or low. when you bid please PROVIDE ONE SAMPLE OF WORD WORK YOU HAVE DONE with checklist of VBA in the PAST ideal candidate
We need a freelancer to develop CMP (Construction Management Project) using Ms Access platform that include Forms, Reports, SQL and Vba to develop the application with the following specifications: - *) Database include main 4 tables as Contractors, Projects, Works and Archive. *) Freelancer should hold a Bachelor or Master degree in one of computer
...chrome extension for new table entries and then click on a link in that entry. The extension ended up updating and breaking functionality though. I can provide the now broken script and the outerHTML of the page for you to use. The problem with the current script is that it is just randomly clicking on links from any entry in the table, rather than just clicking
...including a text file with the clue numbers, clues and clue explanations. This text file is however not very readable. I had some software written six years ago to convert the text file into an html table that I can paste into a website. It works very well but very occasionally chokes and crashes on certain text files. I am unable to see what it is about
I need you to fill in a spreadsheet with data. To design VBA for invoices data input to excel worksheet, from the excel than create DO, Sales Order and save all in pdf file and print out Also save all invoices data in to xls for account use.
I am looking for a python script that will connect to a Ubuntu based MySQL database, copy everything from field_A to field_B in table_Z. The table is extremely large and is constantly changing and under load, so the database must remain active during the procedure. Current schema is attached for more context.
...done been able to do this for the reports described in the first paragraph but I have no idea how to write the VBA required to Loop through to generate the annual reports for every donor AND include this logic as well. Additionally, if the VBA could set the email to send via gmail instead of Outlook, that would be -amazing- but not 100% required.
This is a Angular 4/5 project with one component to be developed using PrimeNg TreeTable , this tree table component should display a static template data with dynamic values and a data table at the leaf of the tree. Project has to be shared privately in Github for development review also to make sure development meets the requirement. Note:
...Create an Excel user interface for the user to enter criteria data to generate a report(s) using the data in the spreadsheet. Results will be view-able using a user-friendly, easily understood display layout. Display will have an option to print the report. The report will have a user friendly, easy to read layout. Ability to convert results data
I write continuing education courses and need someone to update the table of contents and index for several courses. no other typing needed. Each course varies. there are about 8 courses.
There are 21 hostels on this website. [url removed, login to view] I need someone to help me build a VBA scrapping tool on Excel to extract data from these 21 hotels on [url removed, login to view] So there will be 21 sheets of Hotel on the excel file. Each sheet will have 365 days of prices for 1) twin rooms, 2) triple room, 4) quadruple rooms. If rooms
We have a project that is almost ready. But there is 1 small, problem to be solved. We have a table with over 5.000 records. We use the tool from [url removed, login to view] to sort the table and to add pagination and entries/page. The only problem is: the page always loads the entire database and at the end switches to the normal view with entries/page,.....So,