Microsoft Excel Macros

Microsoft Excel macro to access other applications

Hi, Could you please help me to get informations from other applications to excel using macros?

Picking values in the intersection of row and column values

In row 1(column 2-column11) i have location"<NAMES>"(all different) and in cloumn1 i have customer codes, and the values at an intersection of particular customer code & location are hard coded. I m giving the picking values for customer codes and locations from user defined data. The problem...

ComboBox in Microsoft Excel VBA

HOW TO RUN A MACRO WHEN SAME VALUE IS SELECTED IN THE COMBO BOX IN EXCEL VB?

Paste values over a formula on condition of a column in same sheet

Hi, I need to create a macro for my spreadsheet. I will try to attach a sample of it if required and if someone can tell me how to do it. This may aid my description of what I want to do. Basically I need to run a check which does the following: If J2 = “X” – then select F2 and paste...

Excel Macro to extract substrings from a comma-separated string.

How can I write an Excel macro to exctract substrings from a comma separated string located in a single cell and put each substring in a cell of a certain column.

How do I write this Microsoft Excel macro?

Hi, I'm trying to create a macro that will move rows in my spread sheet. I am working with orders that are keyed into excel, once the orders ship or are canceled; the rows are highlighted green or red. I want these shipped/canceled (green/red) rows to cut from the first page and paste into...

Help with a macro for linking a data entry form spreadsheet to the results spreadsheet

I am entering seminar selection data for 600 students and i have a spreadsheet with names and id numbers. there are 20 seminars that they may attend and they have "ranked" them 1-20. I would i have a data entry sheet with a VLOOKUP that will find the student (on the second sheet) and display the...

How to send a mail to multiple recipients from Microsoft Excel sheet?

I have an excel sheet . This excel sheet has data for many receipnts. every row has an email address(lotus/outlook) and then the next four cell in the saem row has the data for the same recipant. I want a macro to be created so that when i run this marco a new mail is drafted for each receipant...

Macro to select a range in Microsoft Excel and paste in Lotus Notes

HI ALL, I have created and Macro which sends a mail to many in that i need to upgrade as mentioned below Recipients Email Address STUDENT # GRADE COUNTRY 123@dd.com 000123 1ST GRADE United Kingdom 321@dd.com 000321 2D GRADE United Kingdom 213@dd.com 000213 3RD GRADE United Kingdom For each...