I have Excel 2000 and 2007 installed on my PC... how can I associate csv, xls, and xla files to the Excel 2000 version?
Since I installed Excel 2007, it is used as the default and I HATE th...
I am creating a tube chart, which I can do, but it shows only the cells with values in them. I want it to also show blank cells as having the same value but I do not know how to do this. In ...
Hi there,
In excel 2007 there is a column called - NAME which has these values:-
Zoe Lengyel - SSPA
John Francisco - SSPA
David Trotter - SSPA
I need to create 2 more columns from t...
I have a datasheet in excel that is a download of all transactions including and "account number" field. I have another datasheet in excel that has two fields - account number and the name o...
I have a spreadsheet that uses a UserForm to fill out information, some of the text boxes are dates that need to be entered. What i would like is rather than typing the date is for a claender ...
Does anyone know of a freeware tool that will repair corrupt excel spreadsheets?
How can I toggle from a command button to apply a Autofilter?
Ive been trying to make a command button change the caption as it applies a filter.
What I need is a button with caption Filt...
Hi All,
Using Excel from the Office 2007 suite.
When I open a local or networked excel file it will seem to hang like nothing is happening.
Excel opens, but the document does not.
...
I am using Excel 2007. I have an Excel file with multiple sheets. The first sheet is where some data is entered that is then carried through to the other sheets. I would like to be able to ent...
Hi,
I was hoping someone could write a quick macro for Excel 2007 to perform the following function; 'Copy the first whole word from the data values in column A and paste it into column B'....
Hello Experts
How can I sum the last 12 columns of data only if the fields have values.
For example I have columns starting from January 2007 to December 2010 - I have data till June 2008...
I have a Vista laptop with Excel 2003 that is slow making modifications. After I select bold or sort its is slow to respond then the bold and sort is fast again next time. Printing is slow at ...
Hi,
Can we sort sheet names according to the alphabits.
I have lots of sheets in an excel.Is there a way to sort them. I want to move sheets accroding to names.
Regards
Sharath
I have the following table:
1 a
1 b
2 a
2 b
I want to consolidate the data as such:
1 a,b
2 a,b
That is, for each distinct value in column 1, I want the values in column 2 to a...
I have the following code and cannot get the databar to show up. I am not getting any errors however. I am new and got this code from a book, and it seems to be good except for the databar t...
I'm having trouble using Excel spreadsheet on my computer. The spreadsheets are large with mulitple sheets. When I open them or make any changes the system freezes up for several minutes befor...
Hi,
I need to use vlookup. Please give me the syntax. If possible mention the example data in worksheet.
I would also like to add macros, please mention me the steps in Excel with one or...
Hi All,
Im struck at this as not able to think how to get it...See here is the case lets say i have a folder over my desktop where i have 100 multiple PDF files..Now i want to get the names...
What is the command to hide a particular sheet from VB.NET code please?
I'm calling an XL document from a VB.NET application and would like for example to hide a sheet called [Sheet1]
I...
Hi,
In previous versions of excel, I replaced a crxf_xls.dll and I did not get uneven columns in the excel report. I tried doing this once we migrated to office 2007 but my columns from a ...
I have 3 columns like below in one worksheet
Node Date Amount
NODE1 2008-04-01 0.00
NODE2 2008-04-01 0.00
NODE3 2008-04-01 -41,138,166.68
NODE4 2008-04-01 0.00
NODE5 2008-04-01 0.00
...
How would I do the following:
If cell A1 DOES NOT contain a formula, highlight it yellow.
Hello,
One of my admins has created an Excel .XLS file where she has the page break customized to print properly. When she sends the file to other people in the office or outside the orga...
The following code snippet is called from another sub.
When the "If" statement is "True", the code runs only
through the Dim statement. Then control returns to the
calling sub, bypassing ...
I have an Excel workbook with a Userform with a Calendar. The workbook also has a Userform with a Multipage tab with textboxes on several of the pages. I have set up the textboxes so that wh...
