Interject Documentation > jMergePoint()
Estimated reading time: 1 minute**
**
Function Summary
Acts as a reference point for ReportMerge . For examples and discussion, view the tutorial.
Function Arguments
| Parameter Name | Description | Default | Optional |
|---|---|---|---|
| TabName | Enter the name of the tab to be copied. Supports a single variable (example "Sheet1", "Sheet*", or just "*") | NO | |
| Placement | Enter "before" or "after" to indicate the placement of the sheet based on the anchor sheet | NO | |
| Anchor | Enter the name of the sheet to be used as the placement anchor. Also use jTabName() to indicate the current sheet, or use jTabName(Sheet2!a2) to reference another sheet. | NO |
Function Composition
| Formula | Example | Explanation |
|---|---|---|
| =jMergePoint (TabName ,Placement , Anchor ) | = jMergePoint ("Trend" ,"before" ,jTabName(First!E14)) =jMergePoint ("*" ,"before" ,jTabName()) | Move the **Trend** tab from the other Excel file to be in front of the tab named " **First".** Move all of the tabs to be in front of the current tab (the one with this formula in it) |