Update Access Data Base from Office Live site
Can I update an Access Data base from a Linked Excel spreadsheet uploaded to an Office Live site ?
Answer Question
| July 21, 2008 3:29 PM
Microsoft Access, Microsoft Excel, Office Live
Can I update an Access Data base from a Linked Excel spreadsheet uploaded to an Office Live site ?
Answer Question
| July 21, 2008 3:29 PM
Microsoft Access, Microsoft Excel, Office Live
how to increase no of rows of validation list (drop down list)???
hello, thanks for viewing this thread. i have one excel sheet. i have entered following data in 30 rows in one column and created the validation list for that data 10:00 AM 10:01 AM 10:02 AM ” ” ‘ ” 5:00 PM i want to show drop down list box with my own no of [...]
Answer Question
| July 23, 2008 1:46 PM
DropDownList, Excel macros, Microsoft Excel
hello, thanks for viewing this thread. i have one excel sheet. i have entered following data in 30 rows in one column and created the validation list for that data 10:00 AM 10:01 AM 10:02 AM ” ” ‘ ” 5:00 PM i want to show drop down list box with my own no of [...]
Answer Question
| July 23, 2008 1:46 PM
DropDownList, Excel macros, Microsoft Excel
Can data in Excel 2003 be set up to automatically move from one sheet to another in a workbook?
Is it possible to create a macro, or multiple macros to upon a button push move data from one sheet to another in the same workbook in Excel 2003? We have a workbook with three sheets, instead of having to manually copy and paste information once we have completed it from sheet one to the [...]
Answer Question
| July 22, 2008 6:22 AM
Excel 2003, Excel macros, Macros, Microsoft Excel
Is it possible to create a macro, or multiple macros to upon a button push move data from one sheet to another in the same workbook in Excel 2003? We have a workbook with three sheets, instead of having to manually copy and paste information once we have completed it from sheet one to the [...]
Answer Question
| July 22, 2008 6:22 AM
Excel 2003, Excel macros, Macros, Microsoft Excel
Current Date in Excel Query
I am using Excel 2003. I am trying to run a query that will used daily and the only thing that will change with the query is the current date. Is there a way to use a formula saved in the query that will automatically use the current date instead of having to manually input [...]
Answer Question
| July 17, 2008 6:32 PM
Excel 2003, Excel formulas, Excel queries, Microsoft Excel, Query
I am using Excel 2003. I am trying to run a query that will used daily and the only thing that will change with the query is the current date. Is there a way to use a formula saved in the query that will automatically use the current date instead of having to manually input [...]
Answer Question
| July 17, 2008 6:32 PM
Excel 2003, Excel formulas, Excel queries, Microsoft Excel, Query
Adding dayys to a date without adding weekends
I want to enter a date into a cell in microsoft excel and in another cell I want it to add five days onto the previous date without includind the weekends in so if I enter the 7/16/2008 into the first cell then I want to have it add five work days making it the [...]
Answer Question
| July 23, 2008 4:38 PM
Calendar, Excel formulas, Microsoft Excel
I want to enter a date into a cell in microsoft excel and in another cell I want it to add five days onto the previous date without includind the weekends in so if I enter the 7/16/2008 into the first cell then I want to have it add five work days making it the [...]
Answer Question
| July 23, 2008 4:38 PM
Calendar, Excel formulas, Microsoft Excel
EXCEL find-copy-paste
Hello! Using VBA for first time, so everything is toughed for me.. The problem is: we need to find on the first sheet named SD in second column all cells contianing word ‘drilling’, then for each cell copy row which contains that cell and paste it in other sheet or book (doesn’t matter). Please help [...]
Answer Question
| August 30, 2008 6:50 AM
Microsoft Excel, VBA
Hello! Using VBA for first time, so everything is toughed for me.. The problem is: we need to find on the first sheet named SD in second column all cells contianing word ‘drilling’, then for each cell copy row which contains that cell and paste it in other sheet or book (doesn’t matter). Please help [...]
Answer Question
| August 30, 2008 6:50 AM
Microsoft Excel, VBA
Rusty and Need Help
I’ve been out of the IT Business for several years and have come out of retirement to work with a local community college on Training Grants. We collect specific pieces of data on each student that works for the company that we have the state grant for. It is becoming a nightmare to track everyone. [...]
Answer Question
| July 16, 2008 3:08 PM
Access 2007, Excel 2007, Microsoft Access, Microsoft Excel
I’ve been out of the IT Business for several years and have come out of retirement to work with a local community college on Training Grants. We collect specific pieces of data on each student that works for the company that we have the state grant for. It is becoming a nightmare to track everyone. [...]
Answer Question
| July 16, 2008 3:08 PM
Access 2007, Excel 2007, Microsoft Access, Microsoft Excel
programming
Tag# 301-22-AB02-103, I want this Tag format in this formate XXX-XX-NNXX-XXX, it means in place of Numbers i want ‘X’ and in Place of alphabet i want ‘N’, do you know how can you we do that in Excel? i wana to change numeric values in ‘X’ and alphabet in ‘N’ form, and my friend [...]
Answer Question
| July 15, 2008 6:48 AM
Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
Tag# 301-22-AB02-103, I want this Tag format in this formate XXX-XX-NNXX-XXX, it means in place of Numbers i want ‘X’ and in Place of alphabet i want ‘N’, do you know how can you we do that in Excel? i wana to change numeric values in ‘X’ and alphabet in ‘N’ form, and my friend [...]
Answer Question
| July 15, 2008 6:48 AM
Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
Do you have a favorite construction estimating software tool?
Hi, this is Brian Eastwood. I’m the editor of a fairly new TechTarget site called ConstructionSoftwareReview.com, which, as its name implies, focuses on construction software products. To that end I wanted to throw a question out to ITKnowledge Exchange readers — what is your favorite construction estimating software tool? Are you using Microsoft Excel? What [...]
Answer Question
| May 5, 2009 6:03 PM
Estimating, Hard Dollar, HeavyBid, Microsoft Excel, Sage Software, Software
Hi, this is Brian Eastwood. I’m the editor of a fairly new TechTarget site called ConstructionSoftwareReview.com, which, as its name implies, focuses on construction software products. To that end I wanted to throw a question out to ITKnowledge Exchange readers — what is your favorite construction estimating software tool? Are you using Microsoft Excel? What [...]
Answer Question
| May 5, 2009 6:03 PM
Estimating, Hard Dollar, HeavyBid, Microsoft Excel, Sage Software, Software
how to reference clipart in excel
Ok, what I want to do might not be possible, but I thought I would ask anyway. I have a simple drop-down box (data-validation) with “yes” and “no” options. Ideally, when someone chooses “yes” I would like a clipart to be entered into the cell. For instance, I would like a checkmark or a thumbs-up [...]
Answer Question
| July 17, 2008 12:11 PM
Clip Art, DropDownList, Microsoft Excel
Ok, what I want to do might not be possible, but I thought I would ask anyway. I have a simple drop-down box (data-validation) with “yes” and “no” options. Ideally, when someone chooses “yes” I would like a clipart to be entered into the cell. For instance, I would like a checkmark or a thumbs-up [...]
Answer Question
| July 17, 2008 12:11 PM
Clip Art, DropDownList, Microsoft Excel
how to recover an excel file
i did format my disk, but unfortunately, i also deleted an important excel file. i used getDataBack to recover that file, but when i get it back, i totally cannot read it, the data inside appear all like this “ZUØƠ&¥¥<Ó·UßçœZZ.XMUßwđ¥¥.^µUø™Ũ{đ¥¥_®×,R¥|ni2#EZ™™�” So how can i fix this problem, anyone, plzzzz, help me, it’s kind of important, [...]
Answer Question
| June 24, 2012 4:44 PM
Backup & recovery, Microsoft Excel
i did format my disk, but unfortunately, i also deleted an important excel file. i used getDataBack to recover that file, but when i get it back, i totally cannot read it, the data inside appear all like this “ZUØƠ&¥¥<Ó·UßçœZZ.XMUßwđ¥¥.^µUø™Ũ{đ¥¥_®×,R¥|ni2#EZ™™�” So how can i fix this problem, anyone, plzzzz, help me, it’s kind of important, [...]
Answer Question
| June 24, 2012 4:44 PM
Backup & recovery, Microsoft Excel
automatic publish of charts to web
On worksheet (5) I have graphs based on the 4 previous sheets. I publish this final sheet as a webpage to the intranet but wanted to find a way for the republishing to be automatic. The graphs are updated once the data is changed but I want the user to use the intranet rather than [...]
Answer Question
| September 28, 2008 11:49 AM
Excel Charts, Intranet, Microsoft Excel
On worksheet (5) I have graphs based on the 4 previous sheets. I publish this final sheet as a webpage to the intranet but wanted to find a way for the republishing to be automatic. The graphs are updated once the data is changed but I want the user to use the intranet rather than [...]
Answer Question
| September 28, 2008 11:49 AM
Excel Charts, Intranet, Microsoft Excel
Designing Table Layout
Hi, I am doing very simply frequencies and descriptives but wondered if I can design the layout of the output table myself rather than exporting to Excel and copy pasting a million times…can anyone help?
Answer Question
| July 8, 2008 8:57 AM
Database design, Microsoft Excel, tables
Hi, I am doing very simply frequencies and descriptives but wondered if I can design the layout of the output table myself rather than exporting to Excel and copy pasting a million times…can anyone help?
Answer Question
| July 8, 2008 8:57 AM
Database design, Microsoft Excel, tables
Pivot table issue
Hello, I have created a rather large pivot table and what I am trying to do is on the pivot table itself, as I uncheck something from one of the categories, I want the unchecked items to log a history of what has been unchecked, while the checked items stay. I have already gotten the [...]
Answer Question
| July 7, 2008 6:56 PM
Microsoft Excel, PivotTable
Hello, I have created a rather large pivot table and what I am trying to do is on the pivot table itself, as I uncheck something from one of the categories, I want the unchecked items to log a history of what has been unchecked, while the checked items stay. I have already gotten the [...]
Answer Question
| July 7, 2008 6:56 PM
Microsoft Excel, PivotTable
Automatic Publish web page when excel data changes
I have 4 files created from scheduled jobs on the AS400. Each file automatically updates a worksheet in an excel spreadsheet. (sheet1 to sheet 4) On the 5th worksheet I have graphs based on the 4 sheets. I publish this final sheet as a webpage to the intranet but wanted to find a way for [...]
Answer Question
| January 19, 2012 1:58 PM
AS/400, AS/400 job scheduler, Excel functions, Microsoft Excel
I have 4 files created from scheduled jobs on the AS400. Each file automatically updates a worksheet in an excel spreadsheet. (sheet1 to sheet 4) On the 5th worksheet I have graphs based on the 4 sheets. I publish this final sheet as a webpage to the intranet but wanted to find a way for [...]
Answer Question
| January 19, 2012 1:58 PM
AS/400, AS/400 job scheduler, Excel functions, Microsoft Excel
Forms in Excel 2003
I have created a form in 2003 Excel that has drop-down menu from a list file created on multiple worksheet within the document. This works fine. What I need to do is create a drop-down menu on a field that will not only bring up a list of title to choose from but also when [...]
Answer Question
| February 16, 2010 12:59 AM
DropDownList, Excel 2003, Excel macros, Microsoft Excel
I have created a form in 2003 Excel that has drop-down menu from a list file created on multiple worksheet within the document. This works fine. What I need to do is create a drop-down menu on a field that will not only bring up a list of title to choose from but also when [...]
Answer Question
| February 16, 2010 12:59 AM
DropDownList, Excel 2003, Excel macros, Microsoft Excel
Ms Excel Question
i have entered different students name in column A, Paper name in Column B & their marks in column C. like: john english 90 magi maths 15 john stats 99 john history 35 & i’ve applied this formula: =if(A2:A66000=”John”,sum(C2:C66000)) to get the total marks of John in all papers,but it doesnt work. plz help…!!!
Answer Question
| February 25, 2009 8:51 AM
Excel formulas, Microsoft Excel
i have entered different students name in column A, Paper name in Column B & their marks in column C. like: john english 90 magi maths 15 john stats 99 john history 35 & i’ve applied this formula: =if(A2:A66000=”John”,sum(C2:C66000)) to get the total marks of John in all papers,but it doesnt work. plz help…!!!
Answer Question
| February 25, 2009 8:51 AM
Excel formulas, Microsoft Excel
Select documents from a Notes View and paste into Excel
I’m looking for code to select documents from a particular View and then paste it in a particular template of a Microsoft Excel spreadsheet. Is this possible? And if so, can anyone offer me some sample code?
Answer Question
| June 30, 2008 3:44 PM
Domino Designer, Lotus Notes, Lotus Notes View, Microsoft Excel
I’m looking for code to select documents from a particular View and then paste it in a particular template of a Microsoft Excel spreadsheet. Is this possible? And if so, can anyone offer me some sample code?
Answer Question
| June 30, 2008 3:44 PM
Domino Designer, Lotus Notes, Lotus Notes View, Microsoft Excel
How do I export an Outlook 2007 public folder calendar to Excel?
With Outlook 2007, I want to export from a calendar in a Public Folder into an Excel format. The Import/Export menu option only allows me to pick as a source for the export, a calendar in my personal folders. How do I export from a Public Folder calendar? This question was submitted by a SearchExchange.com [...]
Answer Question
| June 27, 2008 12:50 PM
Exchange Public Folders, Microsoft Excel, Outlook calendar, Outlook Import/Export
With Outlook 2007, I want to export from a calendar in a Public Folder into an Excel format. The Import/Export menu option only allows me to pick as a source for the export, a calendar in my personal folders. How do I export from a Public Folder calendar? This question was submitted by a SearchExchange.com [...]
Answer Question
| June 27, 2008 12:50 PM
Exchange Public Folders, Microsoft Excel, Outlook calendar, Outlook Import/Export
Data Transfer from AS400 to excel
i need to download data from As400 to Excel using TTO option. How to download the description of the fields instead of field names. I have tried with the COLHDG & TEXT keywords in the DDS of the PF. But, the records are getting downloaded with the filed names only. Please revert to me ASAP [...]
Answer Question
| April 29, 2010 11:32 AM
AS/400 import/export, Data transfer, Microsoft Excel
i need to download data from As400 to Excel using TTO option. How to download the description of the fields instead of field names. I have tried with the COLHDG & TEXT keywords in the DDS of the PF. But, the records are getting downloaded with the filed names only. Please revert to me ASAP [...]
Answer Question
| April 29, 2010 11:32 AM
AS/400 import/export, Data transfer, Microsoft Excel
