relative location

  1. B

    Excel Path to different directory

    Hi, Lets say I have the following directory structure --Main -----DirA -----DirB And lets say in DirA I have A.xls and in DirB I have B.xls When I am working in DirA I would like to reference data in DirB .. so currently it is done something like this: DirA -> Cell A1 ->...
  2. L

    Need Hyperlink to use Relative Reference, defaulting to absolute

    I have a ? Icon in a few areas in my spreadsheet to use as a hyperlink to jump to another worksheet in the same workbook to a named cell. I select the icon and EDIT HYPERLINK I select PLACE IN THIS DOCUMENT and select the named cell from a list. when I hover over the link, it shows an...
  3. M

    Macro to "Add line" identical but below - relative to button location - Excel 2010

    I have a simple table to calculate income for a customer. I need to be able to add a button next to each line that adds another row below the button location, where it copies and pastes everything, enters 0 in amount cell, clears Source content and leave cursor in Source. I've searched...
  4. C

    Create Phone Number list with multiple groups

    I have a list of names/ phone numbers which is formatted as: <tbody> First Last Phone 1 Phone 2 All Choir Youth etc. John Smith 910-111-1111 910-111-1112 x x Sara Green 910-111-1113 x x </tbody> All phone numbers are part of the "all" category (would be glad to delete if...

Some videos you may like

This Week's Hot Topics

  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • Highlight Row and Column on cell selection
    In the following I have some code I need modified to see if I can do the following: 1) Only have this work when selecting a cell inside a couple...
  • Need Numbers Inputted and Deleted
    Thanks for your help. Not sure if there is even an = equation for this. Please see attachment. If there is a solution, please respond with = So...
  • Worksheets(x).Select Error
    Hi, I am trying to select multiple sheets using the following code. [CODE=vba] Dim x As Integer ThisWorkbook.Worksheets(3).Select...
  • myFind Range not working
    Please can someone say why this myFindRng goes red in the code? [CODE=vba]Private Sub Model_Chose_Change() With ThisWorkbook.Worksheets("Job...
  • How to identify the last page break in a sheet
    How can I find the position of the last page break in my sheet? There may be multiple pages and I want to know how to find the position of the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top