I am using Excel 2003. A sample Excel file is attached. Below is the Macro I have created but I can't seem to get it to go on to the next customer and repeat the process until all customers ...
I have the following to display the cell value, the value is in time format 12:20 however when run the code returns it in I think text format "0.513888888888889".
How can I get just the val...
i use excel 2007 vba/macro and i have countrie's names for the list of countries. i want to add a new country name that will be an aggrigation of some other countries, and will "sit" in the co...
<ORIGINAL>I have an excel worksheet with 9 columns (AK:AT)that I have grouped, file attached. I would like to have these grouped columns, closed and not visible to the user until certain poin...
Excel 2003
On Sheet2
I have a range that will vary from project to project
The numbers of rows in the range will vary also from project to project.
However, The range will consist of thr...
I had this working with set columns and and rows but this macro will used in different files so the rows won't be the same.
I have been piecing the code together for what I've found on the i...
I posted the following values in my Excel spreadsheet (cells A1 to B7)
X Y
11 33,100
12 47,300
13 69,000
14 102,000
15 150,000
16 220,000
Then I entered the following formula in A9...
How would I do the following using VB?
Search row 1 for a cell that contains: "Students" Create a variable called "refernce" that equals the column name "Students" exists. Then reference t...
Hi All
I have two Excel 2000 workbooks open, I'll call them "wbA" and "wbB".
I need to write code in wbA that connects to wbB, reads the ranges A24:A100 and I24:I200 off of wbB. {tab} "fo...
Is there anyway to export the quick access toolbar from excel 2007 so I can give it to another user?
We are just starting to use pivot tables and have come across a grouping quesiton. In Access we are able to group on prefix characters in a report.
Is there a way to do this in pivot table...
I have a spreadhseet that contains several pivot tables, as in the example below.
If the data in Table1 expands so that there are now 4 rows, excel asks "Do you want to replace the contents...
I am trying to write some code in VBA for Excel 2003 which will allow for me to change the formatting of a cell based on a cell in a different worksheet. This is all executed by a command but...
i am trying to create a function called "val()"
this function will change the number in text format into number format.
can anyone help me to build this?
please also show all the steps...
hi
i have a series of cells imported into an excel 2007 spreadsheet which are formatted as Time cells but are actually exported from my SQL DB as DateTime fields
so a cell displayed as 0...
I have this situation
2 Rows, Say Row 1 with budget values for the 12 months accross (Columns A to L)
and Row 2 with actual values (not really filled to the end of the row range say upt...
Hi,
I have a SQL query that runs from VBA and selects data from two tables, the query does not return any data. If I cut and paste the query from the immediate window into RapidSQL, I get d...
I have a macro that I found here on EE below. What I want to do is have this macro fire when the list box selection is changed.
The data validation list occurs in cell C3, so the below should...
Experts,
Here is an Excel question. How do we sum over a flexible range of cells in Excel. For example, if we need to sum over the numbers appeared from cell D2 to cell E7, we can just use ...
I have a fairly large excel spreadsheet (28mg). It says calculate in the bottom left all the time, even after I F9 to calculate. Even if I put auto calc on, it still says calculate.
Hello
I have just basic knowledge when it comes to excel so what I need to do is probably easy for most of you. I would like to set up a spreadsheet for athlete evaluation (soccer). I would...
I'm currently working on a calculation that uses salary and years of service. The calculation is:
Weekly Salary * Total years of Service
I'm using the the following formula to calculate ...
I'm inserting data to an excel sheet from a sql server query.
The question is:
Is there a way to insert long text data to column.
It appears that varchar(255) is the max allowed.
Is there ...
I want to put a time and date in my excel spreadsheet what do i put in to display this?
Hey guys,
I have an excel sheet with a lot going on. There are two dates, and I would like to build a countdown timer that will count down the days, hours, minutes, and seconds between the t...
