To write excel macro set for simple scheduler. User will enter tasks into input sheet and click 'generate calendar' to generate output sheet. There shall be option to print to pdf. Detailed Brief is attached (turn on comments for more information)
...methods have been the most successful to extract data from PDF to Excel spreadsheets. We have expertise in excel and also have great knowledge of excel shortcuts, macros, pivot table and other customized formulas. We can manage the entire data weather it is structured or non structured, simple or complex, large or small in excel sheets....
...Excel document that uses a lookup table to return specific values. The working formula I use has this general structure =INDEX(MATCH([ ]&[ ],[ ]&[ ],0)). This formula is quite long and Excel struggles to update values quickly. To speed up my spreadsheet I have started to convert the Excel formula over to PowerPivot using DAX formula, which I can see
...file needs implementation of a VBA data import process that would do the following: - Import Data from another Excel files into the main one In this Excel file I have a database, that serves as data for various Pivot tables. I would like to have a VBA process implemented that would do the following - Refresh all Pivot Tables after additional data
Looking to hire an expert data analyst for a quick 1-2 hour t...data analyst for a quick 1-2 hour task. Should be done in 3 hours from hiring. Work submitted after deadline will not be considered. Drawing conclusions by exploring data and pivot tables is mandatory. Analysis will be done in .xls file along with explanation too. More details in private.
We have an excel spreadsheet for bulk data entry by external parties with conditional formatting within the spreadsheet that indicates if correct values have ...spreadsheet to paste values. DO NOT PITCH: if you dont have ready access to the version attached. Spreadsheet attached with conditional formatting and current script in the VBA section.
i need a design for a table map with my logo and background related to science and to children. the colors of the background need to be blue and pink. I added a picture of my logo and a picture of table map as an example of a table map of another company.
I need some who is very skilled excel VBA to write code for user friendly search feature such as a text box, button, dropdown, and filter so we can search entries in specified worksheets or entire workbook. So end user can search quickly. Furthermore when a match is made I would like the entry highlighted or other entries hide so the match can
I have posted several excel projects for a data set. However due to the size of the project I have hired a few freelancers for VBA coding other pieces of the project. This another piece of the project which I am seeking to hire a freelancer. The description of the project and screen recording about what I am trying to accomplish is in the video link
Each day we receive a sales order file in excel format which contains multiple orders. In order to put each order into our system, we need to do the following: 1. For each order (i.e. each row), create a separate CSV File (e.g. for 10 orders, we will need 10 separate CSV Files; 2. The Headings for each column will need to be changed to a new Heading 3. A Button which automates the above proce...
I want a WP plugin that enables me to easily add review tables to my posts. I should be able to create tables and star ratings identical to what you see on this page - [url removed, login to view] [url removed, login to view] It's important that I'm able to create these tables from the text editor, not a separate page.