Search results for query: *

Is there a way to ONLY copy the formula and not the conditional format? Each time I copy a cell it brings the conditional format with it regardless if I paste special formula or a regular paste. I have 300 rows and over 256 columns with conditional formatting. Any help would be greatly...

I have several worksheets with a pivot table on each worksheet from OLAP source in Excel 2007. The goal is to get the group1 (Parent), group2 (Parent child),and group3 (child). example: Group1 (the variant VarField (1,x)) Mammal Group2 (the variant VarField (2,x)) Dog Group3 (the variant...

I'm hoping someone can point me in the right direction. I have 2 tables that are 30K+ rows. I've put them in arrays. 1. need to find unique ID from myarray in the 2ndarray 2. if finds unique ID in 2ndarray a)need to check to see if certain criteria match b) if doesn't match criteria find...

I'm very new to vb script. I've looked on the internet and haven't quite found what I need. I have a script that works for the most part, but it doesn't give excel time to refresh all the QueryTables (takes about 3min to refresh). So, I'm wondering if there is code to put in for delay before it...

I collect information from "Start" sheet that has the date and time, which is stored in the varList (but is seems to store it as text). In my "Report" sheet I have the minimum time (I get this from the "Start" sheet) as the starting point. Then add 30 seconds to each row. What I'm trying to...

I'm trying to fix the "Cannot Shift Objects off sheet" by looping through all the cells in a workbook. If the cell has a comment I want to change the properties of the comment to "Move and Size" (xlMoveAndSize) with the cell instead of the "Dont move or Size with cells" (xlFreeFloating). I...

I have the following formula which works. But now I'm being asked to only provide the max value and not the sum, based on the 2 criteria. SUMPRODUCT(--(('[test.xls]Sheet1'!$AA$1:$AA$10000=$C13)*('[test.xls]Sheet1'!$W$1:$W$10000=K$1)),'[test.xls]Sheet1'!$V$1:$V$10000) So is there a way to add...

I'm not sure if this is the right forum. 1. I'm trying to loop through all the pst files in my c:\ looking for specific date/time of email as well as to/from on the email. 2. Once I find these I would like to copy the emails to a new pst file. I've found some code, but not sure if it's what...

I'm not sure if this is the right forum. 1. I'm trying to loop through all the pst files in my c:\ looking for specific date/time of email as well as to/from on the email. 2. Once I find these I would like to copy the emails to a new pst file. I've found some code, but not sure if it's what...

I'm trying to find out if you can modify the start date and/or finish/due date of a task through outlook (2003) then be able to upload into Office Project web access (2007). Does any one know if this is possible? Thx

Is there a way to compare rows in a text file usning VBA (Excel 2003)? I need to compare the rows before I import that text file data into excel. So, row 1 is the headers, and rows 2 to 70,000 is the data that I need to compare. I need to see if row 3 and row 2 have the certain data, etc. the...

I have an MS Query that I'm hoping I can get advice on for Excel 2003. What happens in excel is that the user puts in the criteria in certain cells, then the VBA opens up Business Objects, runs the query then saves the file as a text tab delimiter. After this it pulls that data into the MS...

I need to sort a text file before I can loop through the information. 1.Can some one tell me how to do this? Here's what I have so far: Sub TXTQryTbl() Dim ConnString As String Dim qt As QueryTable Dim strtemp As String Dim intFN As Long Dim varFields As Variant Dim i As Long Dim lrow As...

Hello, I'm hoping someone can point me in the right direction on the best method for pulling in data from a text file to excel 2003. The text file can have as many as 1Million rows. so I've been trying to do the data query in Excel (I've already set up an ODBC connection for txt,csv, etc.)...

I'm not sure if I'm stating this correctly, so bare with me. I'm creating a custom toolbar where the user can create their on view of the worksheet. I've created much of the code and I'm stumped on how to get the name of the menuitem (commandbar button) the user selected, so I know which sheet...

I have Excel 2003 and I've created an Add-in as well as a seperate workbook w/a module to import the add-in to users "Add-ins" folder on their hard drive. It adds the add-in, but I don't think the "AutoExec" works since the menu item is not appearing on the toolbar Here's the code for adding...

ok. I really screwed my Excel up. I was trying to delete a custom button I created in the "Tools" menu and accidentally delete the "Tools" menu Sub DeleteMenuItem() On Error Resume Next CommandBars(1).FindControl(ID:=30007).Delete end sub I've tried replacing "Delete" with "Add" and that...

I'm trying to preselect (or make the checkbox=true) in a combolist in Excel 2003 through VBA. This is due to the fact that 204 items are the normal selected items. I wanted to provide the flexibility to the user to either select or remove additional items. Here's the code I have so far and...

I'm trying to preselect (or make the checkbox=true) in a combolist in Excel 2003 through VBA. This is due to the fact that 204 items are the normal selected items. I wanted to provide the flexibility to the user to either select or remove additional items. Here's the code I have so far and...

I've gone through the threads on this site and haven't found anything that could help me w/the sumproduct. I created name ranges using the following formula in the "Refers to Box": OFFSET('F'!$A$1,1,MATCH("Cost",'F'!$A$1:$DR$1,0)-1,5000) the name for this one is FCost...