Following points in this macro are running well except points no. 5. & 9. Very small project. 1. Search tool to be placed in a folder along with multiple data excel workbooks. - DONE. 2. Tool should look for a keyword in all the existing workbooks in the folder only and copy paste the entire row in the search tool. - DONE 3. It should paste the workbook
The problem: we converted a .pdf list to an excel file, but the data didn't come out quite right. the list is 6386 rows and 4 columns wide. it should be 8 columns wide, but half of the data for each record is on the second row of the spreadsheet. so there are really about 3,000 records but their data is on two rows. it is not consistent as to whether
...User interface for the program will be fairly simple with rows+colums and settings such as save, insert row/column and which data categories they would like displayed. Only 2 cells in each row will be editable - the 4 Letter code and a Notes Column. I have a concept design showing an example layout and identifying parts of the webpages I would like data
I am having a hard time creating a macro to ‘call’ a SharePoint. I am needing a VBA Excel macro code to ‘call’ a SharePoint so I can chose a file within the SP and have it automatically populate to a tab within the Excel spreadsheet.
...bonus on offer will vary every quarter. Ensure that this is considered when designing the spreadsheet by positioning the bonus amount and the % commission target in separate cells at the top of the worksheet data. You will need to think of using absolute referencing in your formula as well. • Calculate the total sales for each month. • Save the workbook
...i'm wanting to build a budget based app that helps me track my practise,the information and produce built must remain Intellectual Property (IP) Agreement ,i have built a excel macro as a prototype their are a number of macros ,but would like some help CC+ Software or program into a live app ,or iPhone, Mobile App Development, iPad, Objective C, Android
...to Google Sheet and add links to documentation. Part of macro in Solidworks is allready done, missing component to send the data to Google Sheet and store files in Google Drive. I would like to have work done in two steps: 1. Populate new row in Google Sheet with data sent from Solidworks Macro (VBA, C#) 2. Save files to Google Drive and make link to
Create a tool (eg. Webapp or Excel-macro) that can load a list of URLs and return number of hits on 5-10 Keywords pr site. Purpose: The tool should help qualify which websites are communicating about a specific topic. Eg. Return hits on the keywords "Events, Conferences, Seminars, Expos, Calendar" on the loaded list of keywords. Design: Not important
Process daily store sale summary report from text file format into excel database. Based on the excel database stored data, able to search data to analyze sales data by each category by day, by week, by month and generate report and charts. Report need to be intelligent to show where the sales are good and weak. Need report for ordering item based
I need an Android app. I would like it designed and built. I have an excel app and I want it to use it as an app e.g. taking several inputs from app to cells and output of another cell to the app. Excel sheet will be provided after the the bidding process. Regards
...can easily be imported to a MySQL database table. I have sample .SIM files, an Excel spreadsheet with a macro that currently parses the .SIM file to populate cells in itself, and a macro to pull just the data needed that was started that doesn't work. I need an Excel macro expert to get this working. The attached .zip file has the sample data - a...
...header staying fixed. It needs to be constructed from divs as I am going to have JS drag and drop actions on the cells. The Div's should also be fixed so I can put anything in them without them changing shape / size and knocking other "cells" out of alignment How long would this take you? And how much? There only needs to be 4 rows in the table. as examples