How To Calculate NPV Of Alimony / Child Support

Apr 29, 2014

I have a string of payments and want to calculate the Net Present Value. Also, what should be used as a discount rate?

View 7 Replies


ADVERTISEMENT

Formula To Calculate School Grade Of Child Based On Their Birthday?

Jul 10, 2014

When speaking with parents I want them to enter in their child's birthday i.e. 12/1/1998 in one cell and then automatically generate what grade they should be in the next cell. If the grade year cutoff date is Sept 1.

View 2 Replies View Related

How To Get Parent Row Into Child Rows

Feb 22, 2013

[Code]......

(and about 5000 more sets with garbage page headers in between the sets of parent rows)

Basically the data spit out by machine is separated by a blank row.

Let's say I need all the data with the child row "tn" , so I would autofilter /PivotTable it for that entry, but that leaves me with a blank column A. It'd be no issue if I had the column A heading in the child rows (and the number of spaces in between is random like 2 sometimes 15+ so Vlookup/Index/Match aren't too useful). It is possible to have a function that repeats the first row until it hits a space?

Like so:

[Code] ......

Then I could autofilter/pivottable to get:

[Code] .....

View 1 Replies View Related

Indented Parent Child Relationship

Jul 19, 2014

I have the following table and i need to be able to present it an indented list of parent child relationship. The hierarchy can go 1000+ levels deep. How do i achieve this using VBA?

OName
OPackID
PPackID
PName
ParentID

Name1
556
556
Box1
389

[Code] .........

If there is a better way of presenting it, it isn't limited to an indented list.

View 5 Replies View Related

Master-child Relationships In A Userform

Jan 17, 2007

I have an application that uses data stored in an excel spreadsheet. Over time the amount of data has become greater, and the application more unwieldy and difficult to maintain. In order to simplify it, I am trying to create a userform that displays multiple levels of master-child table data (for example, clients-orders-items). The data is stored in separate worksheets. The lower levels must allow inserting and deleting lines, moving them up or down, and editing the data. Does anyone have an example of such a userform that I could adapt to my specific requirements?

View 3 Replies View Related

Map Point VBA Support

Dec 28, 2006

Does anyone know if Mappoint 2006 has automation support? I know that 2004 does. I am wanting to use the automation from excel's VBA.

View 6 Replies View Related

Copy Contents From Child File To Master?

Feb 12, 2014

Basically, the code copy contents from 4 "Child" files to a "Mater" file.

Everything works smoothly but no data is being copied from the "Child" files.

[Code] .....

The other thing I've noticed is that if a "Child" file is open, I cannot run the code. Is there a way that even a "Child" file is open, the code can copy it's contents on the background?

View 14 Replies View Related

Remove Duplicate In Child Sheet By Comparing To Other

Mar 15, 2014

How to remove duplicate in child sheet if the records for columns A, H and S are exactly matching with the columns A, H and S of Master sheet.

When I used it in some of my other process, it is not working.

[Code] ....

Attached File : Macro.xlsm‎

View 3 Replies View Related

Child & Parent Data Validation List

Dec 10, 2007

I have data for , say - Cars, Company and Average.

I solve this upto 2 level i.e cars and companies.

But i want a third level also.

When i select Car from drop down list, using data - validation - list , in cells(1,1) , i should get all companies in Cells(1,2) and on selecting companies , i should get Average in cells(1,3).

If i do define name ,and then data validation list , and then use Indirect() function, i can solve it upto 2 level.

Eg. I can get company for car .. but how to get Average Also.

View 8 Replies View Related

Create Parent Child Relationship From Hierarchy

Feb 7, 2008

I have an excel file (see sample attached) with a hierarchy with parents and children spread across different columns and rows. However, I am trying to condense it into one column with parents and one column with children. The only way I've been able to do this is by copying and pasting parents onto children rows, which is both a manual and time-consuming process (when you have a lot of rows). I feel like there must be a way to use VBA or a formula or something to get it to work. I have attached a sample, so you can see what I am trying to do (current data and desired data).

View 6 Replies View Related

Does Pocket PC Support Macro Or VBA?

Aug 13, 2006

I am thinking about purchasing a pocket PC. Anyonce can tell me if pocket Excel (or SpreadCE) support Macro/VBA function.

View 3 Replies View Related

Event OnClick - Show Smart Art Shapes Below (child)

Oct 10, 2012

I'm trying to make a menu in my Workbook to access all the others sheets.

To make things easier for my boss, I'm trying to make the menu with SmartArt Shapes (Hierarchic) because it's easier to add/remove itens.

The thing is: he wants it to show the boxes below (hierarchic child) when i click the "mother" box.

It will work pretty like web menus except the mouseover. Image below

menu.jpg

View 1 Replies View Related

Display A Tree-like Structure From Parent-child Nodes

Oct 1, 2008

I encounter the following problem which has been bugging me for weeks.

I am doing up an engineering spreadsheet which calculate the electrical cable size from node A to node B.

Col A and B goes like this:

From|To
Transformer|MSB_A
MSB_A|SSB_A1
Transformer|MSB_B
MSB_B|SSB_B1
SSB_A1|DB_A1
SSB_B1|DB_B1

So Transformer is the parent of MSB_A and MSB_A is in turn the parent of SSB_A1 and so on.

What I would like to achieve is to put these data into the following configuration:

Transformer----->MSB_A
............................|-> SSB_A1
.....................................|----->DB_A1

Transformer----->MSB_B
...........................|-> SSB_B1
....................................|-----.>DB_B1

NB: Please ignore the "dots" above.

This will give the user an overview of the parents and node relationship.

I can't seem to find a solution how to achieve this.

View 9 Replies View Related

Align Numbers From 2 Columns In Parent Child Manner

Apr 5, 2008

I have searched numerous times for the answer I need, but no joy yet.

I have a spread sheet that has one column (call it 1) of data with a single entry each of 100, 200, 300, 400, 500, and so on.

I have a second column (call it 2) that has multiple entries of 100, 200, 300, 400, 500, and so on, and I want to sort so that the rows wind up with the numbers in column 1 all sorted in an accending order, but I want all the same numbers in column 2 sorted to "list" next to the same number before the next number sorts. See below for a small example of what I hope to see once it sorts.
100
100
100
100
200
200
200
200
300
300
300
300

Auto Merged Post Until 24 Hrs Passes;Unfortunately the example didn't post correctly..perhaps this will work but note that the x's are in column 1 and don't exist.

100
xxx100
xxx100
xxx100
200
xxx200
xxx200
xxx200
300
xxx300
xxx300
xxx300

View 5 Replies View Related

Object Does Not Support This Action Error 445

Jul 7, 2009

When I execute this, I got error run-time error 445, object does not support this action. I am using window vista, microsoft office 2007. How can i change the code to make it workable?

View 2 Replies View Related

Copy Data From Child Workbooks And Paste In Master Workbook

May 25, 2009

I had to copy data from child woekbooks (*.xls) and paste it to the master workbook with same page to page every time when a macro is executed i had done the copy and paste part

But I'm Facing the problem in which i had to deal with

Validations as on both master and child sheet validation (column based combo box is activated )
one is worktype
2ns is time type

i jst had to copy data to the master macro works perfectly fine but the problem is that a msg box appears which signifies that i had to change the name (version ) for both types when i click yes 2 times it pastes the data

I'm attaching my macro as well as pic of that msg box with this attachment

View 6 Replies View Related

Column Delay In Days To Support Formula?

Jan 24, 2013

Total amount to pay by D -
2839300284
Description of Customer
Txn Date
Amount Paid

[Code].....

View 1 Replies View Related

Keydown To Effect To All Controls That Support Event

Dec 31, 2006

Is there a way to fix a private sub to catch keydown effect of various combos and textboxes of my userform?

Instead of typing the same thing to each and every control's keydown event just call a sub. Code goes like:

Select Case KeyCode
Case 112
ShellExecute 0, "open", "hh.exe", ThisWorkbook.Path & "1.chm", "", 1
Case 113
If MsgBox("Backup now", vbQuestion + vbYesNo) = vbYes Then BackUp
Case 114
Col = 3
SearchD
Case 115
showexcel
Case 116
readonly
e.c.t.

Instead of that, if i place code in a private sub test() just call test in keydown event

View 9 Replies View Related

Can Visual Basic Support Windows XP Themes

Jan 10, 2007

Does anyone know how to cause my controls to look in XP style.

I scanned and did not find.

View 6 Replies View Related

Formula: Recognise When A Child Equalled Or Bettered A Club Record In An Event

Sep 2, 2008

I wrote a formula to recognise when a child equalled or bettered a club record (CR) in an event. However what I neglected to do and cannot work out is for the formula to recognise the new time as the new club record that will then have to be equalled or bettered from then on to be recognised as a club record. For example CR for 70 metres is 9.28 secs. Formula I was working with was IF(ISBLANK(B3),""),IF(B3

View 9 Replies View Related

IE6 Automation In VBA - Open A (child) Page On Clicking A Button In Main (parent)

Jan 29, 2010

My query is regarding internet explorer 6 automation via code in VBA (Excel 2003). I'm trying to open a page on clicking a button in main page.

I'm able to open both parent and child pages via VBA, but now want to automate events (like radio btn click etc) in child page.

below is my initial code -

'========
Sub ListLinks()
Dim IeApp As InternetExplorer
Dim sURL As String
Dim IeDoc As Object
Dim i As Long

'Create new instance of IE
Set IeApp = New InternetExplorer

View 9 Replies View Related

Run-time Erro '445' : Object Doesn't Support This Action

Nov 3, 2008

While clicking a button in the excel, am getting a run-time error. Everybody's need is urgent even I understand boss. Anybody else who is in the same shoes as mine. Here goes the solution:

View 5 Replies View Related

Error 438: Object Doesn't Support This Property Or Method

Oct 3, 2008

When I run my code (which opens Excel from Access) it does everything it is supposed to but I then get the above error but I do not get the error if I open the VBA window and then run the code. (The code is password protected, not sure if this is relevenat though).

View 9 Replies View Related

Run Time Error 438: Object Does Not Support This Property Or Method

Jan 8, 2009

I'm getting a really weird error in that I can't reproduce it. It sometimes occurs when I open the document and sometimes not. HEre is the
Private Sub Workbook_Open()
Dim dic, Dn As Range, rng As Range

Set rng = Sheets("Moisture").Range("B2:B1000")

Set dic = CreateObject("Scripting.Dictionary")
With dic
For Each Dn In rng
If Not .exists(Dn.Value) Then
.Add Dn.Value, ""

End If
Next Dn
Set wksPayment = Sheet10
wksPayment.ListBox2.List = .keys
End With
End Sub

The line that hangs up is the wksPayment.Listbox2.List = .keys line. Any ideas or ways to test or further figure out what is causing the problem?

View 9 Replies View Related

VBA - Cells Property Failing - Object Does Not Support This Method

Jan 5, 2010

I am trying to use the Cells Property in VBA but it is not working and I cannot figure out why for the life of me. Below is my ....

View 9 Replies View Related

Filesearch ‘object Doesn’t Support This Action’ Error

Nov 29, 2006

Not sure if I am having a brain fade or not but the following code gives an ‘Object doesn’t support this action’ error (at the ‘with..’ line) and I can’t figure out why.

Sub test()
With Application.FileSearch
.NewSearch
.LookIn = "D:"
.FileType = "*.*"

MsgBox (.FoundFiles.Count)

End With
End Sub

View 5 Replies View Related

Finding A Cell In A Row :: Object Doesn't Support This Poperty Or Method

Jan 6, 2009

I have a userform listbox2 that i am trying to save info from to a worksheet.

I am getting the error "Object doesn't support this poperty or method" when I am trying to set the cell of a find ......

View 9 Replies View Related

Add Image To Userform - Error Object Doesn't Support Method

Nov 6, 2013

Following code from net and applied.

But runtime error on the highlighted line: "object doesn't support this property or method

Code:
Private Sub cbAddImage_Click() With Application.FileDialog(msoFileDialogFilePicker)
.AllowMultiSelect = False
.ButtonName = "Submit"
.Title = "Select an image file"
.Filters.Add "Image", "*.gif; *.jpg; *.jpeg", 1

[Code] .......

View 6 Replies View Related

Remove Lines In Chart (object Doesn't Support Property Error)

Dec 12, 2011

I'm trying to remove lines in my line charts. I searched the internet and find the following code:

Code:
Sub RemoveLines()
Dim ser As Series
For Each ser In ActiveChart.SeriesCollection
ser.Format.Line.Visible = False
Next ser
End Sub

However, when I run the code, I got "Object doesn't support this property or method". I did select the chart. I have excel 2003 with vba 6.5.

View 1 Replies View Related

Copy/Paste Error Object Doesn't Support This Property Or Method

Oct 16, 2008

The macro below is stored within worksheet "Data Lookup". When the value in B1 changes, the code is executed but fails when it comes to the paste function. I get a "Object doesn't support this property or method".

Also, it appears the copying is not occuring correctly. It is supposed to copy from the Data3 worksheet but, in fact, its copying from the Data Lookup worksheet. Does storing this macro within a worksheet prevent the macro from moving between sheets?

Sub Worksheet_Calculate()
If Range("B1").Value = Range("N1").Value Then End
Sheets("Data3").Select
Cells(13, 6).Copy
Sheets("Data Lookup").Select
Cells(23, 11).Paste
End Sub

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved