I am hoping there is a VBA solution for this, but I am open to other solutions if VBA cant help me. I have been tasked with creating a bunch of stacked bar charts to track different business ...
I've tried using AllowFiltering:=True in my protection statement, but that doesn't seem to work. What will?
I have 2 colums on an excel spreadsheet. The fist column is total budget and the second column is amount spent. I need to represent the amount spend in dollars as a percentage of the total b...
I'm setting up a SIMPLE validation that will keep the average honest excel user honest.
On the attached workbook I want to create simple Validation each year. I want (in the this workbook ...
Hello Experts!
I have a query in SQL that I am pulling into Excel. In Excel, I have give then user the ability to to enter criteria into cells and the data will refresh to give the selected...
I am writing an Excel macro to save a file as *.txt. I need to keep the SaveAs path relative because my clients may store these files anywhere on a shared drive or web server. I am not sure of...
Dear EE members,
I would like to minus two number in Cell A and B with formula like what we do in Sum(A2:A3).
Is there a formula to minus number from A2 to A3?
Or other alternative?
Than...
Hi,
I have a number of shapes and command buttons on a sheet and I need to change the captions of them depending on a number generated when clicking a command button. I have tried the attache...
I need a formula to calculate the summarize all the $ values in column A multiplied by the % values in column B, when the value in column C = "x"
For input and presentation purposes, a pivo...
My question involves two workbooks. I have a workbook I download each week containing student information. Each sheet in the workbook contains a students grades. When I download the gradebook...
Hello Experts,
I using the following formula: =IF(B6="",A6,TEXT(A6,"mmm-yy")&" n="&B6&"/"&C6) and in some of my cells I am getting Feb-07 n= 9.0002/12. How do I have the result: Feb-07 n=...
Is there anyway I can find out what is going on with my Excel sheet when it is starting up? For some reason when the spreadsheet opens up it does something cause I can see it flickering on the...
Hi,
I am using the code below to successfully send an email from Excel using the user's Outlook application. However, the UNC path (vPath in the code) is not being recognised as a hyperlin...
Hi,
Create a flash file quering the excel data in a flash player
I have a excel that has stats of many things.
Like
Total employers 10,090
Regigners today - 3
Joiners today - 10
So th...
How do I calculate the NUMBER OF WEEKS between 2 date cells...???
Mike
Using Pivot Table in Excel 2003 against a SQL Server 2000 external datasource. This database has a field: Interest Rate with is decimal and when placing it on the pivot grid it sorts as thoug...
I'm using vlookup to get descriptive information into an order template. The lookup file is on a shared folder in our network. The one file has around 15000 records. Some of the records co...
I need to run excel from VS2008 VB.NET. I was going to use Shell, but I can't find the location of Excel.exe. I tried Program Files (x86)/Microsoft Office/OFFICE11/excel.exe, but there's only ...
I've got an issue with excel I have to run several excel sheets and other programs on my computer. I run dual screens one is a CTR plugged into the back of my laptop the other is my laptop scr...
I recorded a macro to transfer the data (in ms excel)from the one row and splited(each row) into separate columns by creating a recorded macro as follows:
Sub transfer()
'
' transfer Macro
...
I have a spreadsheet where the users select a Product on tab "input file" from a data validation drop down list. This cell "A16" has a named range of "Product". On another tab "ProductPivot"...
Hello,
I have an Excel Sheet that whenever a cell value changes a macro is run to verify the cells contents. My problem is that if you copy a cell then paste it, it runs the macro and dese...
Hi,
I need to get the username of the processes running in Task Manager in an Excel macro. I am using the following code snippet to get the process name. It would be great if I was able to ...
hi - id like to have a button that puts a worksheet into design mode without going to Control tool box and clicking on the blue triangle. ive put a line of code below that brings up the tool b...
Can you nest CHOOSE in SUMPRODUCT to return a named range as a critera
SUMPRODUCT=((A1:A10>=5)*(CHOOSE(D1,B1:B10>5,C1:C10>5))
D1 can be output row of a FORM COMBOBOX ( 1 , 2 )
The above ...
