How can I use a formuale to extract all cells containing only one character?
When you open up Excel 2007 ---> Go to Developer Tab --> Click Insert
You have the option between Form Controls and ActivX controls. What is the difference between the two?
Are the objec...
I have a workbook used for tracking calls. I need to make sure that if any one of the fields in a row are populated that all the other fields in that same row are also populated. Is there a ...
I have a CommandButton that I do not want normal/standard users to use or get at. It contains special admin functions and I want to make the button transparent to user or hide it in a graphic...
I need a macro for an excel spreadsheet that will determine what company to contact based on a dollar amount in the total field. The company with the highest dollar amount gets contacted firs...
In XL 2003, I have data on a worksheet that encompasses cells A1 through D43. I want to email just this part of just this sheet to someone, but when I click on the email icon in the Standard t...
I have an Excel 2007 worksheet that started opening with numbers at the top instead of letters. Now all my new Excel documents open with numbers instead of letters. How do I change this?
I have asked before to no answer, but there must be a way to set excel to NOT format fields to exponential format.
I know I can do it by hand everytime I load a file but that is ridiculous ...
every time that I turn on mi PC a process EXCEL.EXE appear between the process running, note that I didn't open de MS Excel application. Could this be a virus?
Hi.
I've attached a very simple spreadsheet to illustrate my problem.
The transaction lists are dynamic should be considered dynamic. I don't know before hand who the people are, how man...
how i can write code in excel vbeditor for open two files and merge the files
I have an Excel Area chart with 8 SeriesCollection's in it. When I change the last SeriesCollection to xlLineMarkers using ApplyCustomType, the legend item for this collection drops from the ...
I have a user form search_data that when you enter the customer name and press OK all the information present in the table on the worksheet.
The problem I have is that the customer will app...
Hello
I have a simple question but it is very urgent.
I have a spreadsheet in wich I do some calculations (using if-sentences) these calculations then return me some numbers in cells J9 an...
Using Excel 2007 and VB.NET I'd like to know what the code would be in the Sheet change event to change to color of only certain columns in a row based on an input of a field in that row. In t...
I have an excel spreadsheet that has a list combo box for each column at the top. whenever we sort on any of the columns using the list feature, some of the formulas references change while o...
Hi - I am tracking the meetings held by many committees in one spreadsheet.
Committee names are in Row 1 and the date of each meeting in Row 2. I calculated the recurring meeting dates f...
I have hundreds of data sets showing change (y) over time (t) at different locations. I am attempting to plot the (y,t) data for each location and fit a second order polynomial line of regres...
Hi Guys,
I need to set up a progress Bar for this Macro. I am a newbie to VBA. Could someone please help me getting it done..
Cheers
Costa
A related question: is there a way to format entire rows of a spreadsheet such that if the value or text of a cell is different than the cell above (simple example: if a2=a1, then the row is t...
I would like to create a pivot table from an ODC connection that references a report on a Microsoft Dynamics CRM 4 server. I've been able to create an ODC that connects to other resources on ...
I need to make a list that will allow the user to select from the list of options, but if their option is not available they can then type in the box the option they need. I cannot figure thi...
I have a column which is nested between 2 columns. The middle column contains the =EXACT() statement and show either TRUE or FALSE comparing the cells on either side.
How do I have the cel...
I have an Excel 2003 Spreadsheet that contains about 50 variables/columns. The variables are repeated for each row; each row just has different values for the variables.
I need to loop th...
