In the past I used to be able to caculate a cell reference on another worksheet in the same spreadsheet and get the value(contents) and use it in the worksheet that was referencing out, but this feature seems to have disappeared. At present I am using Excel 2003. Any suggestions?
Answer Question | February 18, 2008 6:18 AM
Excel 2003, Microsoft Excel
I am compiling a sales report that with all the sales figures of different branches in my region, these figures are then listed from the best performer to the worst performer in a separate spread sheet using the large function in excell my problem is how do I get the name of the stores to [...]
Answer Question | February 18, 2008 8:43 AM
hi i wanna to save crystal reports as excel form so can anyone help me
Answer Question | February 22, 2008 7:19 PM
Crystal Reports, Microsoft Excel
We have an Excel spreadsheet that volunteers use to document their time working. The time in an out is based on 12-hour time (am/pm). I would like a formula that would use the in and out time to compute number of hours worked. Anyone know how to do this?
Answer Question | February 2, 2011 12:51 AM
Have a summary sheet and want it to calculate information from a standard daily form (seperate workbook) that gets saved as the days date, daily. Want summary sheet cell to continuously calc what is inputed on daily form even after it is saved as something else.
Answer Question | February 13, 2008 6:10 PM
Microsoft Excel, Microsoft Office, Workbooks
Dear Sir Madame I am doing a function in Excel 2003 that takes three cells as range data-type. the function all it does is to see if two of the cells equal to the third one. if yes I want to color the background as green Can anyone reply to my request? Thanks in advance [...]
Answer Question | February 19, 2008 5:02 PM
Microsoft Excel, VBA
Hi, Is there an easy way to automatically “refresh” the data in an excel spreadsheet from an AS/400 DDS Described Data file? I’d like the data to be collected whenever someone opens the spreadsheet. I can already get the data using a transfer request, but I have to start the request manually. I’ve tried making [...]
Answer Question | January 27, 2010 1:54 PM
AS/400, Lotus, Microsoft Excel
Hi, I have a simple Data Flow with an Excel Source and an OLE DB Destination to upload data from an Excel file to an SQL table. The Excel file has 8155 rows. Once the package is finished running, the SQL table only shows 255 rows. The data access mode is Table or view – [...]
Answer Question | February 22, 2008 7:53 PM
Microsoft Excel, SSIS
Does anyone know of a site that exchanges calculation information for Pivot Tables???
Answer Question | April 4, 2008 3:23 PM
Microsoft Excel, PivotTable
I would like to know how can I draw borders on a cell in excel with lotusscript? I’ve goggled for sites that give excel exporting tutorial but none provides a detailed explanation. Any suggestions?
Answer Question | January 4, 2008 2:56 AM
Export, LotusScript, Microsoft Excel
I am using Lotus Notes 6.5 and I have an Excel spreadsheet that I have saved as a 123 (.wk4) file. In Lotus Notes I imported the file using File Import. I then used the following critera: Import as: Main Document Using form: To Do Defined by the WKS title: this is turned on WKS [...]
Answer Question | December 17, 2007 8:05 PM
Lotus Notes, Lotus Notes 6.x, Microsoft Excel
We have a customer upgrading their PCs with Vista and Office 2007. The host is an 820 at V5R3. iSeries access fix pack is SI28055. Does anyone have this mix and do you have issues to report? Thank you.
Answer Question | June 4, 2012 7:25 PM
AS/400, Microsoft Access, Microsoft Excel, Microsoft Office 2007
Hi when running a form i am getting an error and my output is not been created and when i debug i gives me a clause that excel is running in the back end but there was no excel running
Answer Question | June 4, 2012 5:12 PM
Microsoft Excel, Microsoft Office
I have a script in Lotus Notes that imports data from a excel spreadsheet. I want to be able to always activate a specfic sheet every time the script runs. Currently I am using this method and it directs to the last saved(active) sheet. Set xlsSheet = xlsWorkBook.ActiveSheet I tired this method but got a [...]
Answer Question | November 19, 2007 5:08 PM
Lotus Notes, Microsoft Excel, OLE objects
How to create NUnit tests that will test Excel-AddIn.
Answer Question | October 25, 2007 1:58 PM
C, Microsoft Excel, NUnit
I have a alv report and i need to run on my excel sheet ,How do I go about?
Answer Question | April 27, 2011 6:49 PM
ALV, Microsoft Excel, SAP