Forum Discussion
Enter data on a workbook and at the same time that data to be added on another workbook
On worksbook A I want to be able to enter some data, at the same time I want some of that data be reflected on workbook B. I create this formula =SUM([Book2a.xlsx]Sheet1!$C$4) and it is workin...
Your data in Workbook A should be in a Table. Use CTRL+T to convert a range to a Table. Then in your Workbook B you will reference the Table instead of a Range. As the Table grows, you will no longer have to worry about expanding the range used in the formula on Workbook B.