I need a quick Excel Macro / script to normalise a spreadsheet that I have. ## Deliverables Quite simply it needs to step through each identically formatted row and create a second spreadsheet with the same data but rearranged slightly. The sheet looks like this: | **Postcode** | **Area** | **Postcode** | **Area** | **Postcode** | **Area**
The project scope involves some grapical ploting with eigther Excel macro or any VB coding. deatils outlined in attachement ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature
...output the report to a file then used my own complied DOS program to output correctly but have decided to move on to Windows. I would like a programmer to be able to develop a macro in Word which takes the headers of each para and translates it into plain English for my clients. I have about five different reports which would need this. I need as ASAP and
Very basic project. User opens Open Office spread sheet and selects column #1 Macro: 1)copies contents of column #1 2)macro posts column #1's stuff in column #3 (column 2 has numbers) with the phrases from #1 all in brackets. result = column #3 has #1's stuff surrounded by brackets eg what was: cooking 18 baking 99 sleeping 288 is now: cooking
...most of which are basic ??" however all steps need to be completed for full credit. Partial steps will not work. I would like this all contain in one macro I could run from the tool bar I have an excel file with 5 tabs labeled (Cover, Map, Table, Keystone LG & Pricing) The pricing tab is the one I will focus on as the rest remain static for the most
...aren't too bad. On this page you'll find many numbers: [log masuk untuk melihat URL] I need to find out what words exist inside of them. This could be done either by someone entering in the numbers on a website (see links below) or a programmer could create a program that would accept the numbers as inputs, query (gently!!) the site and return
I have several files in Excel, all done the same format. Need to retrieve data in an summary file extracting data from a file whose name is dependant from the input done in a cell. Need a macro or formula trick to do that. I know it's not a huge work, but it's a necessity for me now.
...in to the software the software is unlocked for the user, and the unlock number then becomes unusable â so that it cannot be used again. In other words I have a list of numbers for the different software products. When a software product is purchased I find the corresponding product list, email the customer a number off it, and then cross that number
Hi - I want an internet macro written for myself. As an overview - I have a number of domains that I want subdomains created on, and have a wordpress blog installed. The internet macro is to create blogs on my domains and subdomains using the cpanel. There are a couple of ways that this can be done - and I am looking for the easiest and
Last Year, I had a MS ACCESS & MS Excel Macro created for my company. Its basic function was to query a database sheet, and transfer data from it to another excel database sheet to keep our inventory updated. It also figured out pricing for our inventory based on fees and MSRP. We have tried to contact the coder for 3 months with no luck, so we are
...submit. Also, in your code, tell me where i can change my username and password. One more thing, on your code, can you make the login window "invisible" similar to a VB macro with internet explorer where you can set "[log masuk untuk melihat URL] = True" or "[log masuk untuk melihat URL] = False". I would like the login window set to false if you c...
...item on the top menu to export all mobile numbers from an specified mailing list category into a CSV file. So in the above admin demo a user would do the following by clicking on 1) Manage Subscribers 2) Choose the list I want to export eg Marketing 3) Add new button saying export mobile numbers to CSV file 4) Be able to save a .CSV file
Required an Excel Macro that can perform an "If Then Else" function in an Excel spreadsheet. The Macro needs to read a range of cells & make a choice based on the contents. The results of the decision tree should be delivered to another range of cells. The data needs to be set up in cells within the same sheet or referenced from another
I need a macro developed which will 1)convert Hindi unicode characters in a Word file into their entity references , &300A, for example. 2)replace spaces with "" 3)Leave English characters and numbers as-is. I have developed some code for doing this but it cannot handle conjuncts. The single page code is in the attached zip. I am also attaching a sampe
...and quantity traded for all listed companies. I currently maintain a historical sheet where I copy these values every working day from the daily reports. I want a VBA Macro that does the following automatically: -Open all "DailyReport*.xls" files in a chosen directory. Where * is the date. Example: [log masuk untuk melihat URL] -If the data for
I have an Excel Template where the data is populated from an Access database. I need a macro or code that automically sets the print area for worksheets that contain a real value. Some worksheets contain a formula, which is not a real value. One of the worksheets "Department Process Description", has two rules: 1. Print set print area if
I need a macro developed which will : 1)replace all Hindi Unicode characters in a Word file with the unicode entity reference , &300A, for example. 2)replace spaces with "" 3)Leave English characters and numbers as-is. That's all ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code
Need the code for an outlook macro which will take all the incoming e-mails from the hotmail folder and move it to the general inbox. The code should search the header for two different e-mail addresses in the TO field: (address1 at hotmail) and (address2 at hotmail) if the addresses match it will move that message to the regular inbox. ##
I need an Excel Macro which will arrange multiple individuals data on a row, by birthdate and gender. Also it will delete duplicate data. I can provide sample spreadsheet. I need the data for the persons with the two earliest birthdays compared and if they ar within 16 years of one another they should be considered spouses. If so the male data should
I have an MS Project 2003 file that contains VBA macros. Its purpose is to automatically install all required macros, forms, views, tables, filters, groups, fields, toolbars, reports etc into the MS Project 2003 [log masuk untuk melihat URL] template file. I run it, but it doesn't install anything. I need a developer to fix it so that it works. Once it works, I may have some additional w...
I need a macro (written in VBA) for Outlook 2003 that will: #1. While in a "Contact" copy the Name and phone number to "variable1". #2. Copy the mobile phone number to "variable2". #3. Create a new "Task". #4. Paste "variable2" into the large description section of the Task. #5. Pase "variable1"
I have included detailed specifications in the attached zip file in the file named Specifications.doc. I need a C# class/method that can crop the numbers out of bitmap images. I have provided 37 example images in the folder Example Images, if your code will work with all of these images then it is perfect. ## Deliverables 1) Complete and fully-functional
This projects is to make a application like CourseGenie with some extra features. It wil include: Macros for MS Word XML Unicode Autogeneration of html-files , zip-file and a wrapper for SCORM, so that a LMS can track the user. IF YOU DONT HAVE HIGH EXPIRIENCE WITH THESE SUBJETS: DONT BID ON THIS PROJECT!!!!!!!!!!!!!!!!!! Inspiration can be found at [log masuk untuk melihat URL] before ...
I need help implimenting a macro I have designed. I need a VBA excel macro that, when a button is pressed in a mater file ([log masuk untuk melihat URL]), it copies data from an (open) excel data file. These data files will be opened separately, and the macro button pressed each time. There are 50 different data files I need copied into [log masuk untuk melihat U...
...segments will vary according to what analysis is required. The least number of segments will be four and the maximum will be probably be 30. 7. The data is generally held on Excel spreadsheets. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables
I'm wanting an Excel macro to print a spread sheet a certain number of times, and for it monitor and act based on the status of a windows print queue. When the macro is actived I want a form to pop up. Basic functionality looks like this: 1. Ask user for number of copies (print outs) 2. Check the print queue of the target printer. If a
...of another (there is never more information than this). I was thinking maybe a macro that copies all the days in the week to one sheet, removes blank lines, and resizes the whole thing so it can be printed on 2 to 4 pages... I would like this done as an openoffice macro ([log masuk untuk melihat URL]) ## Deliverables 1) Complete and fully-functional working
I need an excel macro that will go cell by cell through a very large excel sheet. for each cel it would 1) check to see if there are any "dependants' or 'precidents'..if not it would 2) highlight the cell fill color to light yellow 3) and write the cell row name and coordinates to another sheet called "log" (the sheet will be in the same f...
We make a request to a web page that contains several numbers with a length of 10 digits each. We need to get them extracted using RegEx and put into a dataset. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition
Hello Coders: Create an Excel macro to perform the following task: Copy values from a user defined excel range and paste them to another user defined excel range at a specified interval. Here is how I imagine it the code - although will rely on you for best implementation Frequency: S string (s,m,h,d =seconds, minutes, hours, days)
I need a program that will solve linear equations that include complex numbers. And example of such equations is written below. 2x + j3y = 5 j9x + 4y = 6 ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition
Macro parser for email processor We have a working PHP-based system which receives emails from an SMTP server, authenticates them (using GPG keys), and allows users to upload files and messages to a web site. We seek to extend this system to be able to process macros. The following description will be a little confusing since you have not seen
I have a small project I urgently need completed tonight. It should take an experienced VB programmer a couple hours. It's an Excel spreadsheet with a VB coded macro. ODBC connection. The data is just one recordset about 35000 rows with 11 columns. The values in the first 3 columns represent a unique key. There are about 65 rows for each unique key
I need a desktop macro. It works like this. 1) User double clicks your macro on the desktop. you can use VB or WSH. 2) Macro grabs users computer name, MAC address, domain, and machine name. 3) After it grabs it, it will open a pop up window in IE passing the computer name, MAC address, domain and machine name. On this pop up page it will
PROGRAM NAME: "UPDATE-QUANTITY" DESCRIPTION: Use an EXCEL MACRO to create a new excel file from 2 existing excel files. File1: Generated on the fly via user interface. Has 2 fields called CODE1 and QUANITY1 File2: Existing file named [log masuk untuk melihat URL] Consists of many fields, however we are only using ITEMNO and EQ_CODE File3: This is the New file ...
...database crawler This software creates a database of ICQ numbers so it can be used in ICQ advertisement mailing lists by your options. For example you input city or any interesting you criteria and the program performs search on site in look for the available (online/offline) ICQ users and generates Excel report with the found results. Best for advertising
I require an excel macro to insert a few formatted rows when a button is clicked. See attachment for more detail. ## Deliverables 1) Complete and fully-functional working macro that does not impair other areas od worksheet 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web
Excel VBA macro, extracts data from html pages. ## Deliverables Rent A Coder requirements notice: As originally posted, this bid request does not have complete details. Should a dispute arise and this project go into arbitration "as is", the contract's vagueness might cause it to be interpreted against you, even though you were acting in good-faith
I have a list of websites bei...have a list of websites being compiled into an xls spreadsheet which will have hyperlinks off to the respective websites. I need for someone to visit each website, find the phone number and add it to the spreadsheet. Simple! I will supply in batches of 1000 so please quote the price for one batch along with timescales.
...exisiting Microsoft Excel macros into a series of MS Excel files that do not contain it. Ideally the application should be able to either read the macro from an existing excel worksheet or be able to read it as a text file. The application then should be able to multiple select any number of MS Excel files that do not contain the macro, and import ...
We'd like an excel macro that can import files from a notepad file then perform various analysis. The notepad files are from a school administration software that captures basic data about students i.e register, exam, school fees etc. The macro should be a stand alone that data can entered instead of just importing. See the attached. ## Deliverables
I need a macro that automatically matches to excel documents. Its basically a spread sheet for men and women who are looking for matches. I want a macro that can automate that by comparing the two documents and then giving results of who has been matched. Attached is a sample of the two files men and women. ## Deliverables 1) Complete and fully-functional
This is a simple project for a programmer who knows what he is doing. I need a very simple text replacement macro software, similar to the most basic function of ShortKeys ([log masuk untuk melihat URL]) Features: - The user can define text replacement macros. (For example, whenever I type .eml, it's instantly replaced with my full email address.) - The
...and replay tool. This application will record user actions in applications deployed on Windows platforms. The actions will be recorded into some kind of editable script or macro, and will then be compiled into executables that can be called from a command line. The tool should identify and control objects, rather than using a coordinate or bitmap system
I’m looking for a coder who can start on (and finish) this immediately. I have an Excel spreadsheet that has a custom header. I want the custom header to print only on page 1 of a 2 page spreadsheet. When I run the macro I have, it wipes out the custom header. Also, I want page 2 to start printing at 1/2?? down from the top of the paper. Currently
...somebody who can make an excel macro... See the atachement file... So, the button "update" must multiply all the price columns with the rate and save 3 html files, one for every exchange rate (BUT ONLY THE FIRST 4 SHEETS, WITHOUT "EX"). The new price (excel_price x exchange rate) must be visible only on the html files, not in excel file. Also, the sa...
..."first email". I want the task to be automatically scheduled when the email is sent (without any security warnings). The task should ideally contain the name and phone number of the contact which was selected to send the email (not sure how easy this is to do) and be scheduled to be done at 9 am 2 BUSINESS DAYS after the email was sent.
I need a list of all valid U.S. and Canadian phone numbers. These will be used for keywords on Google Adwords. If you don't have a list of all the valid ones, what I need is a list of all the possible permutations, minus any that have 411, 911, 555, or any other protected numbers in them.
i have a macro using internet explorer. i just need a version of his using Opera browser. you can download from <[log masuk untuk melihat URL]> the macro works for internet explorer already, so this is just a conversion. in general, all it does it it grabs the login and password from the one page. and logs in to another page. and then clicks on a pop up