...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 dte itm count)/current dte item ct)*100
hope this helps...
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...
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 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...
...As Long
Dim lngSheetCount, numsheets As Long
Set wb = ThisWorkbook
MyPath = "U:\My Documents\Testing\data\"
ChDir MyPath
TheFile = Dir(MyPath & "\*.xls")
Do While TheFile <> ""
Workbooks.Open Filename:=TheFile, UpdateLinks:=0, ReadOnly:=True
Set wb2 = ActiveWorkbook
sname =...
...wb As Workbook
Dim TheFile As String
Dim MyPath As String
Dim ws As Worksheet
MyPath = "U:\My Documents\Testing\data\"
ChDir MyPath
TheFile = Dir("*.xls")
Do While TheFile <> ""
Set wb = Workbooks.Open(MyPath & "\" & TheFile)
For Each ws In ActiveWorkbook.Worksheets
nrow =...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.