Hi all,
Please can anyone help me making a line chart of the errors column on the secondary axis with the Checks column on the primary axis with both complimenting each other. Also please e...
When you open Word or Excel then try and open a file the application hangs and you have to end task. Once you have ended the task and restarted the program you can open up a file without inci...
How does the percentile function of excel work?
=PERCENTILE({7,8,9,20}, 0.35)
Please explain how it got the result of 8.05
I'm trying to import a large Excel into Access via their import wizard, but it fails to import. The file has 572 rows, and columns to EO. I've done a clean of the data to make sure there's n...
As per http://www.dbforums.com/archive/index.php/t-970380.html
the Length of cell contents (text) : 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.
...
Experts,
I've partially created a custom function whereby i'd like it to return a whole bunch of values (amount will change on input) but can't figure out how.
For example, s...
How can i modify my excel spreadsheet to display only columns A to T and rows 1 to 500.
I would like a sub that will go over cells a worksheet (or in a specified number of columns in a worksheet) and
1) check if there is a number in the cell
if there is then
2) add a consta...
Hi ... I currently have a VBA script that allows me to upload the contents of an Excel sheet into oracle (shown in code snippet). Also part of this, when a user makes a change to a row of dat...
I have a range of values in Excel that I am looking to sum. The problem is that when I do a VLOOKUP, there are no values matching exactly what is there. (i.e. 156000 is not there but 156100,...
I have an excel sheet called abc.xls. I want import it to sql server 2000 using Import/Export Wizard.
When I open the wizard, it ask me data source, I selected "Driver do microsoft Excel(*...
I would like to have a macro button that does 2 things, the first being export/print my "Quote_Complete" sheet to a .pdf file in a specific location using a cell value (T6) as the filename and...
In a spreadsheet i have the following
A B C D
- Absent until further notice
20005 0 Absent until further notice On Off
20005 1 ...
I have the following piece of code that I use in a loop that runs over 32 rows to insert the following
j = 1
For i = 10 To 23 Step 1
Cells(i, j + 1).Select
' Range("b10").Select
...
I have a application in excel which has vba code to connected sql dababase, this application is working very nice with old computer with xp, but it does not with new computer with xp with ms...
I have data appended every day in a table from product specific failures. The data is a table with headers describing the Issues and below are the year to date sum totals of each Issue (row ...
Hello,
I am in need of an excel formula to calculate the loss/gain of one number to another. I think the problem seems to be that the starting number and the ending number are both already...
I have tried to calculate the compounded annual growth from a pivot table using the formula =cagr(start date cell, end date cell, years). Everytime I receive the #NAME? error even though I ha...
I have a spreadsheet I created under Excel 2003. I have a VB script that generates data in a worksheet. Then I have a chart that graphs that data. Worked fine in Excel 2003. Just upgraded ...
I would like to print/create a page(s) of output from an Excel spreadsheet to Adobe using VBA. My goal is to use a cell's value in VBA that contains the name of the file I wish the printed ou...
I have created a custom list of coupon codes using hexadecimal numbers and saved them to a csv file.
When I open or import the csv file to Excel 2007 it takes the hexadecimal numbers which ...
I am getting a type mismatch error when dedugging my code. I am not sure what the problem is can someone look.
I have a Microsoft Excel 2003 workbook that has two dates entered seemingly the exact same way - as a date and formated *mm/dd/yyyy.
However, one date is returning the label type, the other i...
We're changing file servers in a couple of weeks, so our share names are going to change. We'll be keeping the logical name (J:), but will be changing from something like:
\\filesrv1\ABC$
to...
Hello experts,
I need to compare two columns in excel and count how often a specific value occurs in one column for each value in the other column. I think this will best be explained with an...
