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