How do I count the unique entries in a column A (20000 rows) based on a filter in column B?
A B
USA North America
GB ...
I need a simple Macro to to create a worksheet with in the active workbook named as the current date then copy the contents of the template worksheet and paste into the worksheet with the curr...
Dumb Q, but how do you insert a newline into a textstream in an excel cell? For example, user want's to type in something like "There's no place like <CR> home".
I've tried char(13), but...
Is it possible to have excel send and email when a cell = a certain value?
I have a worksheet accessed by our field engineer for spares, when his stock level reaches a certain value I would...
I have two worksheets:
worksheet2 (ColumnA) contains a list of social security numbers. Of course all Social security numbers in this column are unique. (ColumnB) contains Days absent
w...
I need some VBA code to copy worksheet rows of data from columns V to Z to another workbook to two different worksheets depending upon the criteria in column H. The values in the rows on col...
I have an Excel spreadsheet form that is filled out be various users. They will provide information in columns A and B. I would like to create a macro (or something) that will query an SQL dat...
Hi Experts.
I have an Array that I got from a Excel Sheet with several elements, some duplicates and many of them being blanks.
How can I delete all dulpicates and all blanks?
Thanks,
Hi,
I have an XLS file.
In column B I have a usernames. I need to be able to look for a word in column b and if it matches highlight the entire row
Also
If I open one of the XLS spread...
How to execute a sql server script in excel?
Thanks in advance
Martin
Hi,
I am storing an address value in variable 'ActCell' either from selection or 'A10:E9'
and using it in Chart's SetSourceData with fixed & Variable range.
Is this code error free f...
I am developing spreadsheets for pilots and need to calculate the distance and bearing from one gps coordinate to another.
Windows XP
Excel 2007 (saving files as 97-2003 compatible)
This persons laptop froze when an Excel file was open. Upon reboot Excel say that the file is corrupt. We only see "values". ...
Hi Experts
I have several sheets in a workbook. The number of sheets varies.
The format of each sheet is simple enough with the following:
A B ...
I am trying to create a global variable in VBA Excel so that I can keep a variable saved between two runnings of a module.
For example, I'd like to run a module and store a password. Then ...
SITUATION:
i use this set of macro to copy in clipboard many outlook links, or one only and i end up with the same problem as tlt28gvg121 (See code snipet, sry for the french comments)
i pas...
How do I convert a sql server 8 datetime value to excel format so that sorting and calculations can be done with this column on the spreadsheet?
We need an excel formula that will calculate a person's age in Days based on Date input in the spread sheet. For example, If we provide date of Birth (ex, may 1, 1934) and current date we wan...
Hi
In a cell if it has the value of 1, I want it to change the cell colour to red
If it has the value of 2 then the cell colour should be orange
can anyone advise how this is done?
MS Excel
I have two columns with text content in each cell.
One column is in one spreadsheet, and the other in another.
There is no associated row data, just a single cell per row.
I wan...
Hi All -
in Excel, I'm looking to add a zero to the left of a value when the number is < 10. I am parsing out a date value in this format MMYY. For the MM, I want it to be 01, 02, etc. ins...
I have a drop down list of sales teams within my company. I have two cells that I would like to auto-populate based on the team selected in the drop down list. Essentiallys if Team A is sele...
Hello experts,
I have the following data, and i would like to draw them in polar, could any one show me how to do this in excel?
angle distance
-80 5.72
-70 7.25
-60 7.21
-50 8.80
-40...
I have a user who has been working in an Excel 2007 file. It has data in it. Then one time when he trys op open the file it opens to a blank background screen, no cells and just the menu bar a...
I have an extremely simple code that will prevent pasting of any range that has been copied:
Sub preventCopy()
If Selection.Copy = True Then
Application.CutCopyMode = Fa...
