Keep cell references within the same folder when duplicating the folder

Occasional Contributor

I have a basic set of folders set up for projects(Folders for New Jobs). In the Contractor Info folder the basic information is entered into the ContractorInfo.xlsx workbook. I have referenced these cells from the ContractorInfo in other worksheets stored within this set of folders such as the MasterInvoice.xlsx. I would like to duplicate this set of folders for each new job but the cell references in the MasterInvoice are still referencing ContractorInfo.xlsx from the Folders for New Jobs and not the file within the folder I have duplicated. Is there a way to duplicate these folders and have the formulas and references stay within this new set of folders?




0 Replies