Greetings Experts,
I need some help with a formula I can use to determine whether an adjacent cell displays Y or N. The formula cannot use hard coded cell values. It needs to take the cur...
Hi All
Im using Excel 2007. What I have is a workbook with two sheets ListOfItems and Annexure1. The ListOfItems sheet contains about 3500 rows and has columns A to AE. Some of the columns n...
Hi,
I am unable to copy or move the work sheet in a excel file. It says "Command in not available in shared workbook".
Please help.
Thanking You,
i have a vb macro macro that creates a chart in excel. it has the primary axis but i need to add the secondary axis with the same scale as the first axis. I have attached the VB macro and an i...
Hi there,
I have an excel chart which has 4 series. Which refers to its respective rows in columns A to D. What I was wondering is if there is a way via vba/macro where I can add 1 to the fr...
I recently worked a problem where some of my users began experiencing difficulties opening .xlsx files while using the Office 2003 Suite with the Compatibility pack installed on their machines...
I'm creating a spreadsheet with Excel 2007 and using VBA to acomplish some advanced techniques. I am trying to cycle through the cells in a column looking for a blank one. So I would start, ...
Attached is a small data set. I need to show a stacked bar chart for Paid Search broken down by Client vs. Prospect (hence the stack) alongside one for Organic Search. Shouldn't be that diff...
I would like to convert an Excel table (Column 1 are Product codes, Column 2 Sizes, Column 3 Quantities) to a Matrix (Column 1 product codes, then 1 column for each Size and the quantities bel...
Hi,
I have a spreadsheet tab with approximately 10 pivot tables, all based on the same external data set.
For the first pivot table, I have the 'Year' as a page field - the user will sel...
Try to call Excel sheet from PHP file. Fails always.
System error: 10016: The machine-default permission settings do not grant Local Activation permission for the COM Server application with...
Hi,
I ahve written code in excel 2000 which copies a module from 1 workbook to another.
But when I want to execute this code in Excel 2007, then I get an error that this is not trusted.
I...
Hello,
I have a bar chart in Excel. Currently each bar has a data label over it (number). Is it possible to have these data labels converted to a percentage - by the chart itself - rather ...
Using Excel Macro, I would like to push a button a determine the maximum value in one column based on a given start date and time and end date and time. Also I would like to sum all the values...
Hello,
Pardon the lack of proper verbiage in my description of this problem.
I am attempting to have a cascading set of drop down lists, one of which contains Unique values. I have briefly ...
I everyone-
I have the following code that works great (see below). I just need it to also bring in the column headers (Field names) as well. Can some help me with how and where to insert...
Hi
I have a DTPicker control that holds the exact time to the second. I tried to assign this value to a variable
by saying oTime = DTPicker1.Value, but got a date value. OIn further inspec...
I have accidentally overwritten an excel file and I tried to recover it using "DiskInternals Excel Recovery 1.8"-free trial. It found a lot of files but only one related to the one I need. The...
Using Excel VBA, I need to replace the capital letter at the beginning of a cell to the lower case of this letter.
I used to be able to copy text\tables from excel into powerpoint as paste special as black and white but now only paste in colour. how can i fix this to how to set this back on?
thanks
Hello Excel VBA Gurus,
I have 10 different stock symbols from cell A1 to cell A10. Cells B1 = Frequency (monthly, Daily) B2 = Start date, B3 = End date.
So here is what the macro is su...
I loaded Excell 2000 on one of my users PCs and when I hit the "File" drop down to use the "Send to" option it is not there.
i have multiple worksheets in excel. how do i convert all off them at the same time to pdf?
I have an application that opens Excel, places data from an Access database, then saves the workbook to our server. I need to create a Command button on the worksheet and then run a macro that...
I want to change the background color of a row in Excel based on the value of a cell. E.g is B5 = "Critical" then entire row colorindex = 3.
