Hi All,
I have a workbook that contains 2 worksheets. One worksheet is the supplier inventory data, titled ("Rugs") and the other worksheet is what I use to import into my website, and it's titled ("Store").
What I do, is I link each cell of data from the ("Rugs") worksheet to the cells in ("Store"). Each day however, I receive a new file from the supplier. The sheet title from the supplier is named ("Rugs"). When I remove the outdated worksheet ("Rugs") from the workbook, and replace it with the updated ("Rugs") worksheet, all cells in the ("Store") worksheet are now all N/A.
Is there a way to prevent the (N/A) on this? Thanks
I have a workbook that contains 2 worksheets. One worksheet is the supplier inventory data, titled ("Rugs") and the other worksheet is what I use to import into my website, and it's titled ("Store").
What I do, is I link each cell of data from the ("Rugs") worksheet to the cells in ("Store"). Each day however, I receive a new file from the supplier. The sheet title from the supplier is named ("Rugs"). When I remove the outdated worksheet ("Rugs") from the workbook, and replace it with the updated ("Rugs") worksheet, all cells in the ("Store") worksheet are now all N/A.
Is there a way to prevent the (N/A) on this? Thanks