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...

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
Back
Top