Forum Discussion
having trouble with a formula, it won't add new input to the sub tabs
I've been working on a formula to extract data from the master sheet on excel to sub sheets. I've got the formula to work but when I enter new teams on the master sheet, it's not extracting to the sub...
You are obviously referring to an external workbook. Thus, you must include the extension name in the workbook name, like this:
[YHLRegistation.xlsx]
If possible, avoid external references. Instead, refer to ranges in the same workbook, although in another worksheet.
[YHLRegistation.xlsx]
If possible, avoid external references. Instead, refer to ranges in the same workbook, although in another worksheet.