Macro: ORDERMENTUM_IMPORT Purpose: To open a file exported from the ordering website and populate the the excel order spreadsheet with quantities matched to the product codes for matching customers. Pre-processing: Prior to populating the spreadsheet, a number of checks should be performed on the exported data. Any negative results of the checks should
...of activities with a category. User id, Category, and a percentage value(positive or negative) will be given as parameters for rewards the activities according to the user. activities should be rewarded specific to user. User id, Category will be provied as the parameters for activity suggestion function. Based on the reward which activities have
...graphs (line charts, spatial maps) created. Below are the metrics I need created and attached is the excel worksheet with the data. I'm looking for someone already using a BI tool like Tableau, Qlik, I'm NOT looking for someone to create graphs using Excel. Requirements Below [login to view URL] Timeline by Month - Line Chart. [login to view URL] Timeline by Mon...
Please see attached input spreadsheet and output spreadsheet. - Create new WS "Aggregate" & "Volume" - For each worksheet matching "Data-*" - Copy and Transpose cells area matching "Host Name:" to "Aggregate" WS - Copy and Paste cells area matching "Aggregate Name" to "Aggregate" WS - Forward fill cells area matchin...
Hi i need data visualisation using power BI. I have a small dataset, and would like to provide a sample of what power bi can do to communicate the data visually to man...small dataset, and would like to provide a sample of what power bi can do to communicate the data visually to managers. A few graphs and 3-4 filters. The data is on a single worksheet
I have created a blank table in the a worksheet -FSHT labelled GRV. Now i need a code written that will read GRV June 2018 file. There is a tab in the GRv June 2018 file called Weekly Floats. This contains around 4 different tests conducted on different dates. I need the code to copy the data from each test to the appropriate columns in the FSHT. This
I have a finished Excel worksheet, but it has a problem. I need to be able to sort Row 2. But it does not respond to sorting command (Ribbon-->Data-->Sort). Also needed, one small line format issue, as shown in enclosed folder.
Adding search functions (regular and dynamic) to a worksheet, plus 2 other small functions, and fix sorting issue. See enclosed image. Price of >$55 US.
When we copy a worksheet we receive an error the name already exists and when we click no it prompts for a new name. We would like to be able to copy the worksheet without this error. The 2 worksheets in question are 2526 and 2527.
I have already completed the initial analysis worksheet t I need help with creating pivot table with both class of cars, the total revenue for both locations and the row and column calculations (sum) are required. Also the grand total must represents the sum of all of the revenue
I have an excel document which had an input form created in VBA to enable data to be input via 2 works sheets. I've added more columns and altered the structure of the worksheet so now need a re-write of the form. I have attached an example input form (from the orginal document) and created a an image of the new input form and labelled/cross-referenced
I am ophthalmologist and I need to build a software to keep medical records (EHR). It has to be fully customisable. I worksheet that I can add new patients and keep records every time I examine them. Ready software which is previous tested and working is preferable. The software has to work offline and backup online to the cloud. Possibilities:
There are a series of timesheet for multiple employees in a packet in pdf form. The times need to be data entered into an excel sheet that is attached. Each individual employee must be entered into their own worksheet. Add more rows as necessary.
I am looking to translate some worksheet titles and instructions from English into French and Spanish. I've attached the full document that needs to be translated into both languages. You will see that the general instruction stays the same for a number of the worksheet sections but one or two words are changed.
Requirements attached. This project is already taked by Filip
I need to copy the data from another worksheet. So first vba should prompt me to select the file and then list the names of worksheet in that file. Once the worksheet is selected (multiple selection) second vba to import the data in this sheet keeping the formatting and the values (no formula should be copied) one below the another. May be a 30 min