Automatic transfer of Data from AS/400 DDS Described file to Excel spreadsheet
I have a critical problem in AS400 data fetch query in MS Excel (Petch SP2 loaded). I have created several Excel Sheets (in MS Office 2003) for fetching the data from AS400 using MSOffice Query option under Data-->> Refresh Menu. Those excel sheets are using by so many different users on...
I have a critical problem in AS400 data fetch query in MS Excel (Petch SP2 loaded). I have created several Excel Sheets (in MS Office 2003) for fetching the data from AS400 using MSOffice Query option under Data-->> Refresh Menu. Those excel sheets are using by so many different users on...
20 pts.
Excel 2003 linking text format in two workbooks
I have 8 different workbooks that are linked to one master workbook. In each of the 8 workbooks people need to select certain names and change the text format to bold. however when the master workbook is open and updated the BOLD format is not there. Each of the 8 workbooks are changed monthly...
I have 8 different workbooks that are linked to one master workbook. In each of the 8 workbooks people need to select certain names and change the text format to bold. however when the master workbook is open and updated the BOLD format is not there. Each of the 8 workbooks are changed monthly...
Excel 2007 freeze pane problem
Dear Sir, Is there any method in Excel 2007 to enabling freeze pane option in protected Sheet of Excel 2003. Regards Furqan Ahmed
Dear Sir, Is there any method in Excel 2007 to enabling freeze pane option in protected Sheet of Excel 2003. Regards Furqan Ahmed
Return zero when there's no data
I am trying to write a query that I can use to generate an Excel chart to show activity in our database. I have it returning rows for each minute over the previous two hours (no problem). The problem comes when I plot a line chart. If there's no activity in a given minute, there's no row...
I am trying to write a query that I can use to generate an Excel chart to show activity in our database. I have it returning rows for each minute over the previous two hours (no problem). The problem comes when I plot a line chart. If there's no activity in a given minute, there's no row...
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...
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...
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...
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...
Saving chart colors in excel 2003
When I set chart colors in an Excel 2003 spreadsheet, save and reopen the spreadsheet, the color reverts to previous colors. I have tried creating a macro but this do not work. Can someone please advise me how to do this task?
When I set chart colors in an Excel 2003 spreadsheet, save and reopen the spreadsheet, the color reverts to previous colors. I have tried creating a macro but this do not work. Can someone please advise me how to do this task?
Excel 2003 - How to sum up a chart with percentage
I have created a worksheet to track when letters are sent out. I have a column (1) for the name of the recipient and a column (2) for the date the letter was sent. How do I track what percentage of the letters have been sent? I would like a graph/chart, either bar or pie, that will tell me how...
I have created a worksheet to track when letters are sent out. I have a column (1) for the name of the recipient and a column (2) for the date the letter was sent. How do I track what percentage of the letters have been sent? I would like a graph/chart, either bar or pie, that will tell me how...
Convert spreadsheet into a flat file
I need to convert a spreadsheet into a flatfile using the mid function. I only want to use a couple fields out of the spreadsheet, can someone help me?
I need to convert a spreadsheet into a flatfile using the mid function. I only want to use a couple fields out of the spreadsheet, can someone help me?
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.
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.
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...
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...
Switching views in Excel when filtered
I have several macros that switch views for a very large spreadsheet. I also have filtering available for the various columns. However, whenever the view is switched, the filtering is turned off. If filtering is on, I would like the filtered view to not change. Is there a way to keep the filtering...
I have several macros that switch views for a very large spreadsheet. I also have filtering available for the various columns. However, whenever the view is switched, the filtering is turned off. If filtering is on, I would like the filtered view to not change. Is there a way to keep the filtering...
While Loop in Excel VBA
I have the basic loop and can not figure out what to write in the middle. I need to have row 9 column D populate a value from another sheet depending on the value in cell A9. Here is what I have so far: Private Sub Loop1() Dim myLoopCtr As Integer myLoopCtr = 0 While myLoopCtr <= 15 ...
I have the basic loop and can not figure out what to write in the middle. I need to have row 9 column D populate a value from another sheet depending on the value in cell A9. Here is what I have so far: Private Sub Loop1() Dim myLoopCtr As Integer myLoopCtr = 0 While myLoopCtr <= 15 ...
Excel Date format () dd-mmm-yyyy error from exported crystal report
I am exporting a crystal report file to excel and date field TRADE_DATE is coming out strange. i.e PARTY_ID TRADE_DATE CX () 16-Jul-2003 CX 29-Jul-2003 CX 09-Dec-2003 Some trade_date fields are in Custom Type "dd-mmm-yyyy" format ( which is the correct format) but some are in Custom Type "()...
I am exporting a crystal report file to excel and date field TRADE_DATE is coming out strange. i.e PARTY_ID TRADE_DATE CX () 16-Jul-2003 CX 29-Jul-2003 CX 09-Dec-2003 Some trade_date fields are in Custom Type "dd-mmm-yyyy" format ( which is the correct format) but some are in Custom Type "()...
Excel RTD and userform
I need to read data from the spreadsheet into userform anyone can explain it to me? whenever i call the userform the cell stop from being updated/
I need to read data from the spreadsheet into userform anyone can explain it to me? whenever i call the userform the cell stop from being updated/
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.
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.
Excel 2003 Cell has formula but empty Value or text
Hya I have a formula into Excel worksheet cell this value comes from out side Excel. sometimes there is a number and sometimes it contains nothing. I have used isblank isempty when the cell is empty and they return true (due to the formula inside the cell) do u thing i can chek if the cell is...
Hya I have a formula into Excel worksheet cell this value comes from out side Excel. sometimes there is a number and sometimes it contains nothing. I have used isblank isempty when the cell is empty and they return true (due to the formula inside the cell) do u thing i can chek if the cell is...
Excel cell referencing across worksheets
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?
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?
