Su...require a script the can pull specific columns from specific worksheets in Excel and import them to a new workbook as CSV format. I can do this via a Macro but i want to be able to run the script outside of Excel, Ideally I would be prompted by the script to specify the source Excel file to pull from and specify the output file location and name.
Create a VBA for Excel subroutine that will loop thru a single column of data column A, extract 4 pieces of data from the HTML Data and create new worksheet with that data in a column. One column for each set of data. See attached file for sample data in the input tab and what I would like in the output tab.
I'm looking to hire a part time (10 - 15 hours/week)resource, who will be able to write codes in Excel VBA and MySQL and will have in depth knowledge of developing a SQL database. There is no specific project. This person will be given the projects on the go and will be expected to meet deadlines and suggest improvement to the current company processes
i have a excel 2010 workbook with worksheets sheet1 to sheet10. it is on server and any user in domain can open the file and enter data [url removed, login to view] sheet1 i require a vba code to do the following column A has name column b has size column c has username(windows username) column d is date time(dd/mm/yyyy hh:mm) if a user enters/modifies in a cell in column
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)
I am working on excel workbook that we can look at certain account data on a graph and immediately see where there are problems. My problem is I have the graphs were they automatically scale as the data changes but for some data it doesn't scale and doesn't recognize when data is %'s.
I want a VBA script which will do the following: 1. Open a csv file, 2. Read in the file contents containing the following columns: Date, Time, Latitude (in degrees decimal), Longitude (in degrees decimal, Heading (in degrees decimal), Course over Ground (in degrees decimal) and Speed over Ground (number) into a 2-D array 3 Calculate the differences
...some work, in an Excel spreadsheet. Looking for the 200 most asked questions (non basic questions) about Excel or VBA and fill the questions and make an answer in a document (excel, word, html). The answer should be original and come from the expert and not a copy or plagiarised from a web site. It should include screenshots of excel or copy of formulas
Hi So we need a set of workbooks to be done, which are in total about 65 questions. These are simple management questions, which are to be answered using your experience and internet research can be used. The plagiarism should not be above 10% . This work is a regular and long term work.
I am looking for a guy who can develop the following VBA macro: In an excel file column D, I have some URLs. For those URLs, I need to get the host name of the URLs printed without subdomain, http// and www in column E. This step needs to be repited for all lines in the xls file.
...Qualifications: Hands-on experience administering [url removed, login to view] Expertise in working with large sets of data in systems and spreadsheets Strong MS Excel, Access, SQL skills Moderate to advanced VBA for Excel Ability to work with data import toolsets (training available on specifics) Experience with Customer Relationship Management software, including