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 Proceeds. [...]
Answer Question
| April 17, 2008 10:18 PM
ComboBox, Microsoft Excel, VBA, Visual Basic for Applications
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 Proceeds. [...]
Answer Question
| April 17, 2008 10:18 PM
ComboBox, Microsoft Excel, VBA, Visual Basic for Applications
Add to Excel spreadsheet from System i
I want to add data from a DB2 file to an Excel template that has a header row and totals certain columns without overwriting the header row or the totals.
Answer Question
| April 16, 2008 2:41 PM
DB2 Everyplace, Microsoft Excel, System i
I want to add data from a DB2 file to an Excel template that has a header row and totals certain columns without overwriting the header row or the totals.
Answer Question
| April 16, 2008 2:41 PM
DB2 Everyplace, Microsoft Excel, System i
Excel-Macro Help
I’m creating a spreadsheet for a business (for my uni work) and i need to create a booking form and from that be able to save the customers information. I’ve created the booking form, and created a button to save the customer information, using a macro for it to save. The problem is when the [...]
Answer Question
| April 7, 2008 3:02 PM
Excel macros, Microsoft Excel, VBA
I’m creating a spreadsheet for a business (for my uni work) and i need to create a booking form and from that be able to save the customers information. I’ve created the booking form, and created a button to save the customer information, using a macro for it to save. The problem is when the [...]
Answer Question
| April 7, 2008 3:02 PM
Excel macros, Microsoft 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 [...]
Answer Question
| June 2, 2008 3:01 PM
Excel macros, Microsoft Excel, Microsoft Word, VBA, Visual Basic for Applications
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 [...]
Answer Question
| June 2, 2008 3:01 PM
Excel macros, Microsoft Excel, Microsoft Word, VBA, Visual Basic for Applications
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
Answer Question
| April 2, 2008 3:34 PM
COUNTA, Microsoft Excel, Spreadsheets, TEXT
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
Answer Question
| April 2, 2008 3:34 PM
COUNTA, Microsoft Excel, Spreadsheets, TEXT
specify the read only attribute in my Perl code so i don’t have to click on read only
I have created a perl script that read from an excel file that is located on our windows server, the goal is to automate the perl script to run once a week and read the first 5 columns of the row that matches the current date and then write the data to a .txt file. [...]
Answer Question
| April 1, 2008 8:38 PM
Microsoft Excel, Perl, Win32::OLE
I have created a perl script that read from an excel file that is located on our windows server, the goal is to automate the perl script to run once a week and read the first 5 columns of the row that matches the current date and then write the data to a .txt file. [...]
Answer Question
| April 1, 2008 8:38 PM
Microsoft Excel, Perl, Win32::OLE
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
Answer Question
| April 1, 2008 7:11 PM
iSeries database, Microsoft Excel
How do I deactivate the Transfer data To iseries link in EXCEL but still the Transfer Data From iSeries ACTIVE in Excel
Answer Question
| April 1, 2008 7:11 PM
iSeries database, Microsoft 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
| November 25, 2008 6:23 PM
Exchange 2003, Microsoft Excel, Public folders
I need to export public folder calendar data into excel and them into a personal folder.
Answer Question
| November 25, 2008 6:23 PM
Exchange 2003, Microsoft 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.
Answer Question
| May 17, 2008 4:15 PM
Excel 2003, free type, Microsoft Excel, Validation
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.
Answer Question
| May 17, 2008 4:15 PM
Excel 2003, free type, Microsoft Excel, Validation
Switching custom views in Excel when filtering
I have a very large spreadsheet that I navigate using custom views. I change views using macros because I have a couple of other commands that I want executed as well. I also commonly filter the rows of the spreadsheet. However, when I switch views, the filter is turned off, and I would like it [...]
Answer Question
| March 29, 2008 3:13 PM
Excel 2003, Excel macros, Microsoft Excel, VBA
I have a very large spreadsheet that I navigate using custom views. I change views using macros because I have a couple of other commands that I want executed as well. I also commonly filter the rows of the spreadsheet. However, when I switch views, the filter is turned off, and I would like it [...]
Answer Question
| March 29, 2008 3:13 PM
Excel 2003, Excel macros, Microsoft Excel, VBA
How to change config to download all fields to Excel than Inbox
Using menu path Plant AnalysisExportTransfer to XXL in MCBA to download all switch drill down fields but currently am brought to SBWP. How do I change it to allow down load to Excel?
Answer Question
| March 26, 2008 9:27 AM
MCBA, Microsoft Excel, SAP MM, SAP Transaction Codes
Using menu path Plant AnalysisExportTransfer to XXL in MCBA to download all switch drill down fields but currently am brought to SBWP. How do I change it to allow down load to Excel?
Answer Question
| March 26, 2008 9:27 AM
MCBA, Microsoft Excel, SAP MM, SAP Transaction Codes
How to add another row header to Excel Report using Visual Basic
HI, I want to add another row and column header to a Excel Report using Visual Basic..
Answer Question
| March 11, 2008 11:07 AM
Microsoft Excel, Visual Basic
HI, I want to add another row and column header to a Excel Report using Visual Basic..
Answer Question
| March 11, 2008 11:07 AM
Microsoft Excel, Visual Basic
How to search particular data in range of data and everytime save it in a cell
How to search particular data in range of data and everytime save it in a cell in Excel using VB code
Answer Question
| March 29, 2008 8:45 AM
Microsoft Excel, VBA, Visual Basic
How to search particular data in range of data and everytime save it in a cell in Excel using VB code
Answer Question
| March 29, 2008 8:45 AM
Microsoft Excel, VBA, Visual Basic
Shading on Click and Drag
When I click and drag to paint a range of cells, the shading doesn’t show up. Is there a way to change my preferences and darken the shading?
Answer Question
| March 5, 2008 10:48 PM
Microsoft Excel
When I click and drag to paint a range of cells, the shading doesn’t show up. Is there a way to change my preferences and darken the shading?
Answer Question
| March 5, 2008 10:48 PM
Microsoft Excel
Change date format
I have a date field stored in the i5 as yymmdd that I would like to change to mmddyy when exported to Excel. If I just re-format the cell, Excel treats the number as a Julian date and mis-corrects the date. The other issue is that Excel drops the leading 0 so everything in this [...]
Answer Question
| April 7, 2010 2:26 PM
AS/400, i5, Microsoft Excel
I have a date field stored in the i5 as yymmdd that I would like to change to mmddyy when exported to Excel. If I just re-format the cell, Excel treats the number as a Julian date and mis-corrects the date. The other issue is that Excel drops the leading 0 so everything in this [...]
Answer Question
| April 7, 2010 2:26 PM
AS/400, i5, Microsoft Excel
Shift Differential
How can I write a formula for shift differential if 06:00-14:00 is normal working, 14:00-22:00 is $1.00 more an hour and 22:00-06:00 is .90 more an hour? (A5 Work Hours ) (B5-Sunday start) (C5- Sunday End) (D5- Monday Start) (E5- Monday End) etc. Thanks you to any one that can help.
Answer Question
| February 22, 2008 2:11 AM
Excel 2003, Microsoft Excel
How can I write a formula for shift differential if 06:00-14:00 is normal working, 14:00-22:00 is $1.00 more an hour and 22:00-06:00 is .90 more an hour? (A5 Work Hours ) (B5-Sunday start) (C5- Sunday End) (D5- Monday Start) (E5- Monday End) etc. Thanks you to any one that can help.
Answer Question
| February 22, 2008 2:11 AM
Excel 2003, Microsoft Excel
Trouble with pf transfer to excel
I want to transfer an externally defined data file from the as400 directly into an excel file format, then send the file via email. I have email already set up. My problem is getting the file translated correctly for excel. I do not have client access. I have used cpytopcd for spool files, but don’t [...]
Answer Question
| February 23, 2008 5:30 PM
AS/400, data tranfer, iSeries, Microsoft Excel
I want to transfer an externally defined data file from the as400 directly into an excel file format, then send the file via email. I have email already set up. My problem is getting the file translated correctly for excel. I do not have client access. I have used cpytopcd for spool files, but don’t [...]
Answer Question
| February 23, 2008 5:30 PM
AS/400, data tranfer, iSeries, Microsoft Excel
I am a student trying to convert a excel spreadsheet to a Access database.
My questions: How do I convert data from an excel spreadsheet to a Access Database. How do I convert a access form to excel – Using the form as a front for data capturing. How do I link multiple users to a access database – making allowance for data to flow simultanously into the database.
Answer Question
| February 21, 2008 7:56 AM
Microsoft Access, Microsoft Excel
My questions: How do I convert data from an excel spreadsheet to a Access Database. How do I convert a access form to excel – Using the form as a front for data capturing. How do I link multiple users to a access database – making allowance for data to flow simultanously into the database.
Answer Question
| February 21, 2008 7:56 AM
Microsoft Access, Microsoft Excel
iSeries to excel Order of PF changes
when I use a DTF to download directly to excel the order of my data changes. The PF is NOT keyed and I am NOT selecting any order on the DTF. It is intermitten. any suggestions?
Answer Question
| March 12, 2010 6:31 PM
iSeries Access, Microsoft Excel
when I use a DTF to download directly to excel the order of my data changes. The PF is NOT keyed and I am NOT selecting any order on the DTF. It is intermitten. any suggestions?
Answer Question
| March 12, 2010 6:31 PM
iSeries Access, Microsoft Excel
Excel question
Is there a way to rename the cell in Excel? For example…Cell A…Change the name from Cell A to Apple….
Answer Question
| February 19, 2008 1:36 PM
Excel functions, Microsoft Excel
Is there a way to rename the cell in Excel? For example…Cell A…Change the name from Cell A to Apple….
Answer Question
| February 19, 2008 1:36 PM
Excel functions, Microsoft Excel
