coloring rows “if” true
I have a profit & loss spreadsheet that I use to input expected expenses and then log the invoices when they are paid and I always highlight the row when I input the invoice number and invoice amount. Is there a way I can use conditional formatting or a function to automatically color the row if...
Answer Question
| May 16 2008 8:17 PM GMT
| asked by
Tstychalski
Excel 2003, Conditional expressions, Microsoft Excel
Overwrite previous record with VBA code
I am doing a training exercise. All works OK as per the notes with a new record being added when the OK button is clicked. Now I want a script that overwrites the previous record and not to add a new record / row on pressing OK. Pls help with code
Answer Question
| May 13 2008 1:28 PM GMT
| asked by
Battler
Excel, VBA, Excel macros
Search for duplicates in a collumn and delete the row on which it occurs
Hi,I have a spreadsheet with list of identifiers in collumn 1, this is auto generated and due to the source info some of them duplicated, what I want to do is find the duplicates and remove the entire row they appear on.I know this is possible using clipboard and filters but I would rather avoid...
View Answer
| May 6 2008 1:47 PM GMT
| asked by
Harleq
Excel, Excel formula, Excel function
uploading an excel spreadsheet to the as/400
I've seen a developer with an Excel spreadsheet on the iseries server, how do I upload an Excel spreadsheet to the iseries and populate it with data so I can then download the finished product to my PC?
View Answer
| May 5 2008 9:23 PM GMT
| asked by
Chuck310
Microsoft Excel, AS/400, Data analysis
Printing the contents property of an EXCEL file
I have an Excel spreadsheet that has 92 macros and many queries with a Data Connection to Access.I can view the contents of the Excel file in a narrow window. Does anyone know how to print the contents so I can read the full contents?
Answer Question
| May 5 2008 6:21 PM GMT
| asked by
SharieL
Microsoft Excel, Microsoft Access, Excel macros
how can i limit the data size while entering to the database ?
how can i limit the data size while entering to the database from Excel sheet using vb6?
View Answer
| May 2 2008 10:43 AM GMT
| asked by
Shwetha
VB6, Visual Basic, Microsoft Excel
Retreiving data from within square brackets, there may be more than one in each cell (spreadsheet owner refuses to change it grrrr)
I have a spreadsheet with a column containing data in the following format Column GRow 1 [1T40131A] [GB50131A] [GB50131B] [GB50131C] [1T50131D]Row 2 [1T400133]Row 3 [303640]*VFRow 4 [240700]*RNI would like to create a UDF that will retrieve the data within the...
View Answer
| May 2 2008 8:51 AM GMT
| asked by
Harleq
Excel, Excel formula, Excel function
Problems oprning Excel File
I have been working with an Excel 2003 workbook since January 2008 and from last week began having difficulty opening the file. Whenever I attempt to open it, I get an error window with the following messages shown in bold below:[Excel found unreadable content in 'filename.xls'. Do you want to...
View Answer
| May 1 2008 8:53 PM GMT
| asked by
EB
Excel, Excel 2003, Microsoft Office
Saving form calculations to tables
I have a simple calculation on the input form a-b. It is calculated on the form but I cannot figure how to save it to the table
View Answer
| Apr 28 2008 11:48 PM GMT
| asked by
Rv4949
Microsoft Excel, Visual Basic for Applications, VBA
Working with Excel in ActiveX DLL
I have a OCX file that is registered on client's PC and called from ASP to perform the Excel manipulation (copy charts and paste into PPT). I tried to register the OCX on server and called using <Object> tag, did not work, still looking for the OCX on the client. Created a new DLL file...
Answer Question
| Apr 25 2008 5:59 PM GMT
| asked by
Dfree
DLL, OCX, VB
Lotus Notes External Table Look Up
My company uses LN 6.5 and I am trying to design a database with multiple tables. I have been told that there is a function that allows you to look to an external table, such as in Excel, to view data. The data modifications take place in Excel, but are viewed in the database. How would I...
Answer Question
| Apr 24 2008 3:16 PM GMT
| asked by
Kj7100
Lotus Notes 6.x, Lotus Notes database, Microsoft Excel
How to save a document as current date ?
I'm using VBA in excel 2000 to create a macro that saves out a spreadsheet with today's current date. I cannot figure out the code that will achieve this function. Help Please
View Answer
| Apr 22 2008 7:15 PM GMT
| asked by
Data Mgt
Microsoft Excel, VBA, Excel
Is it possible to find out the name of an excel worksheet
I need to import details from Excel but the worksheet names are not always what is expected. Is there a way to determine the worksheet name using sql?Query used to import where sheet name = dataSELECT * INTO tmp_test2 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel...
View Answer
| Apr 17 2008 3:52 PM GMT
| asked by
Smf
Excel, SQL, Microsoft Excel
import the data from iseries to excel sheet
i read some instruction of Thierry Schmitz using timestamp. i am very much interested on this.please provide me any example of this.i am posting the process also.I prefer the following solution, working on request from the user :1) the main excel sheet shows Timestamp of both Available DB from I5...
View Answer
| Apr 17 2008 6:32 AM GMT
| asked by
Mup1234
AS/400, iSeries, Microsoft Excel
Combo box and VBA
The two possible selections in an Excel combobox: Debt & Common Stock. Let's say that the combobox resides in cell B3.If Debt is selected from the box- I want the following fields to show up two rows below the combobox, all in the same column: Issue Date, Maturity Date, Interest, Seniority, Use of...
Answer Question
| Apr 16 2008 10:18 PM GMT
| asked by
Nkd
ComboBox, Excel, VBA
easy way to automate uploading data from a word document to a spreadsheet?
I have a spreadsheet to verify datafields for. This needs to test for example state all the valid entries. I do not want to save off a spreadsheet form of the template i am testing one for each data value I need to test. Is there an easy way to create many spreadsheets off of a data file I create...
View Answer
| Apr 4 2008 3:01 PM GMT
| asked by
Juls
Microsoft Word, Microsoft Excel, Excel macros
adding text to function results
I am using a count function to create a total number (COUNTA(A1-A400) I want to add some test to display with the results so it reads 350 units. I have tried to nest the TEXT command but get an error
View Answer
| Apr 2 2008 3:34 PM GMT
| asked by
Carourke
TEXT, COUNTA, Microsoft Excel
Deactivate Transfer Data To iSeries in EXCEL
How do I deactivate the Transfer data To iseries link in EXCEL but still the Transfer Data From iSeries ACTIVE in Excel
View Answer
| Mar 27 2008 7:11 PM GMT
| asked by
ESands
iSeries database, Microsoft Excel, Excel
Exporting Exchange 2003 public folder calendar into Excel and then into a personel calendar.
I need to export public folder calendar data into excel and them into a personal folder.
Answer Question
| Mar 27 2008 6:23 PM GMT
| asked by
Dre
Exchange 2003, Excel, Public folders
Validation in Excel
Can a cell have a validation rule from a list and also have the ability to free type in that cell? This is in Excel 2003.
View Answer
| Mar 27 2008 4:15 PM GMT
| asked by
Mart802
Excel, Validation, free type
