Does anyone know of a way to add an apostrohe to all cells that contain data.
I have been having an issue with missing data in my query.
Thanks as always,
I have a multiple worksheet Excel workbook. I need to lookup values from various other worksheets based on a primary key, and place them in the main worksheet.
For example, in each workshe...
Trying to copy all the chats from excel sheet and paste it to a word doc
I have about 40 charts on excel sheet and I want to paste 2 chart on each page how do I move to the next page
and ho...
We have a workbook that has been used for a couple of years now that has all of a sudden stopped calculating. The only way you can get a cell's formula to function correctly is to double-clic...
Hi EE
I want to write a code to display a Yes No dialog box and based on the chaoice user makes I should be able to execute relevant commands. Please guide me about how to display a Yes/No ...
Hi all,
I have an Excel 2007 document. Within that document i insert a hyperlink to a PDF document on my network. When click the hyperlink then, i get an error message: "No program is regis...
The attached spreadsheet attempts to graph the 'cumulative' hours for budgeted, actuals, and estimated to completion. I need a second pair of eyes, as one of my collegues insists that the the ...
i want to insert the four characters www.
at the beginning of each cell in a column of domain names.
Is there a find special character that signifies the beginning of the entry?
thanks
Hello...
I am trying to add a formula into a cell right at the end of a script running - however it does not seem to be working and i think it is the way in which i am entering the
Act...
I have a simple little macro that saves an excel file as text tab delimited with a specific filename requested by my client however they want the file to have a .TO extension and currently my ...
Hi,
I am having some problem using the VLOOKUP function. Could someone help me out. I have a lookup table having five(5) columns. In the main spreadsheet I have to compare one column from the...
I have the following code that creates a pivot table in my workbook. It has worked fine for workbooks with less records, now however, with a much larger file I am getting a type mismatch erro...
Dear expert,
I am new on VBA. Can someone help me on standard deviation calculation on VBA Excel programming?
Thanks!
I have the following range and want to assign the values to an array and then check to see of any of them are null. If so, I want to then assign a value of zero to the corresponding cell inste...
Hi,
I need to execute a PLSQL procedure from a excel macro. Here is the code I wrote but it abends with the following error.
'Syntax error or access violation'.
Any ideas??
Thanks,
Mo...
How can I split the data in the attached example into unique rows within a spreadsheet. I need, for each supplier / product code combination a new row containing the data from each column.
...
I want to insert the date of birth in one column and have the current age in years and months displayed in another column in Excel
I suspect that the Excel VBA syntax used for moving sheets has changed since year 2000 ?
I am using Agilent VEE PRO 6 (March 2000) to create Excel 2003 results files.
I have sucessfully used...
I dont seem to have the MS Date and Time Picker control on my machine with Excel - think its a VB 6 install. Any substitutes for this?
I have a shared workbook on a shared drive that reports, "This file is locked. Try the command again later." when a user attempts to save. It is stored on windows server 2003, the workstations...
I have a spreadsheet which has something like this in column C;;
AB2
AB3, AB4, AB5, AB6
C1
C2
C3, C4, C5
and so on....
What I need is to split the cells that have more than one va...
I have 2 worksheets: (wksheet1 and wksheet2)
wksheet1 has a list of Student SS#'s in ColumnA
wksheet2 has a random list of Student SS#'s (Which exist on wksheet1 but are jumbled) in ColumnA
...
I need assistance with an Excel formula that will display the results of a very simple calculation, is driving me up the wall working out how to remove weekends from the calculation. All cells...
I am looking for VBA code that will parse out the text located in cell A1 into separate rows. Row 2 contains an example of what I am looking to accomplish. Some info on this problem:
1. T...
I have an Access database which contains information I feed into an excel spreadsheet. I use Excel to present this information. However, some information needs to be fed back into Access. Quit...
