cell reference file name

  1. P

    Dynamic filename referencing for small calculations

    Hello, first post here- I am trying to streamline the set up for a worksheet which I reference every day. Background info- The goal of the spreadsheet (Main) is to reference other worksheets (Project), which are stored on our local server, and pull data from those project worksheets to...
  2. F

    Vlookup using a cell containing a reference to closed workbook array

    Hi all, I am trying to do the below VLOOKUP, however I am getting an error. The Source Workbook is closed and I would like array to be a cell in my workbook (G1 in this example). Anyone have any idea if this is possible in Excel? Any help would be greatly appreciated! <tbody> A B C D E...
  3. W

    need Macro to export 4 worksheets to a new workbook and to save the new workbook as a name from a single cell plus additional standard information in

    Hi, I am looking for a macro that will export four names sheets to a new workbook then save to a specific file location on out network. the file name needs to contain the name in a specific cell "F2"on one of the work sheet tabs "2016 Distributor Medalist Results". The new file name should be...
  4. C

    VBA SaveAs to New Drive, use cell ref as name, and Password Protect document

    Need help please - Just learning VBA. Trying to write macro that will save file to orig location (not protected), then SAVEAS to new folder location, rename using cell CE3 as name along with time saved, and password protect this document (not original). Macro won't work - what am I doing...

Watch MrExcel Video

This Week's Hot Topics

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