Search results for query: *

Hi Gwen, Make sure your pivot table toolbar is showing. Goto Pivot Table-->Formulas-->Calculated Field. It then pops up a dialog box. Give it a name (no Spaces), then in the formula box enter your fields for your calculation... I am guessing something like this (current dte itm ct - yesterday's...

Sorry Tony, I do know the name of the workbook. Thing is that the workbook name will chance everytime I receive it via e-mail. Reson being as that part of the filename contains a date. So I was wondering is it possible once you have the file open within excel, to reference to that file. Before...

howdy, How do I change to another workbook which is open in excel, yet the name will be different when I receive the file? I want to use code to reference between the two... just not sure how or even if it can be done.... Dim filename As String Dim wb As Workbook Dim wb2 As Workbook...

Hi, This appears to be great if I could get the code to work!! Do I need a reference added or something? It keeps giving me a " Run-time error '1004': Application-defined or object defined error" what am I doing wrong? or is it to do with the site security? the code as is posted above Sub...

I got it to work with the following: Private Sub Worksheet_Change(ByVal Target As Range) Worksheets(3).Activate Set isect = Application.Intersect(Range("b4"), Range("b4")) If isect Is Nothing Then MsgBox "Ranges do not intersect" Else If...

Thanks Guys... I'll do a search on the intersect method and test the 'Target' at the same time with your suggestion Geoff. Thanks, vaneagle

HI All, Not sure how to go about this. I have a pivot table in a worksheet. IF a user selects a page selection I need an an event to happen. The cell that this sits in is B4. The code I have is: Private Sub Worksheet_Change(ByVal Target As Range)...

Hi Zathras. Spot on!! Have a star!! thanks, vaneagle

Hi All, I have a custom function in excel which I use. The issue is I am not sure how I go about updating/refreshing the calculation when the source data changes. With for example, sum(A1:A10), the sum function automatically refreshes... How do I go about doing the same thing with a function...

Hi Guys, TonyJollans - i tried that method following a post in this forum and I could not get it to work...as I was thinking of recording it then make the neccessary adjustments... xlbo - I will give the forums another search... thanks guys... vaneagle

Hi, I have several excel spreadsheets with around 15 to 20 sheets with data I have extracted at around 30,000 lines per sheet. I need to remove the duplicate rows. The duplicate data sits in column B. I looked at autofilter and its not really an option given the number of files and sheets I...

Hi Skip, I have made some changes to the code. I hadn't put the pasting side of the code in as I was wanting to make sure that the code was looping through the sheets. I still have the same issue. The code opens the file up, and I goto the first sheet in the workbook. No problems. The first...

Hi All, I need to loop through sheets in a workbook to copy out a range of data. I have posted some code below. My issue is that it is not moving onto the next sheet to copy the data. Sub getdata() Dim wb As Workbook Dim TheFile As String Dim MyPath As String Dim ws As Worksheet MyPath =...

Hi ultrcyclist, to toggle between sheets in the same file press ctrl + pg up.... this will toggle to the right... ctrl + pg dn will toggle to the left. In relation to your second question, it depends on what data you are trying to display.. if in sheet 1 there is data in column A, in sheet 2...

Thanks PHV... I initially had a look for Microsoft Forms 2.0 Object Library but couldn't find it!! So I went to an Excel 97 user and found it straight away. On my pc I actually had to go browsing for the fm20.dll and load it so that it was there. All is well now. Thanks very much. vaneagle

Hi, The following code errors on me in XP. Funny thing is is that it works in Excel 97. The error it gives is: compile error: User-defined type not defined Dim JunkData As New DataObject ' Declare Variable to clear out clipboard Any ideas? Is there something I need to add in? regards...

As i understand it the -1e9 acts to ignore anything that is not numerical. Sorry.. I have misunderstood... the SUM('Step 2'!C13:D15) is not the problem its the countif...

Hi Excelerate2004, Instead of trying to trap the errors with if statements, why not replace you sum formula's with the following example: =SUMIF('Step 2'!E11:E12,">-1e9") and so on.. This will sum the following: Col A 1 5 #DIV/0! 6 text #REF! =SUMIF(A1:A6,">-1e9") Answer = 12 You can keep...

lol...maybe... Where i work we use markup and gross profit... so I am familiar with these concepts.. Regards, vaneagle

Hi Skip, Thanks skip... I shall have a look.....