Update data in one sheet from another sheet that updates daily?
I have separate product sheets (70 of them!) for each product a division creates. Each row in the sheets has a unique line item number. The first 23 columns contain data pulled from one of our systems, including the line item number. The remaining 26-40 columns contain data that's managed manually.
I have another single sheet that contains the same data points as in those first 23 columns in the product sheets. This data is ripped and replaced daily. I'd like to use a formula to update the 23 columns in all 70 product sheets with the latest data, based on using the line item number as the lookup. This way I avoid altering all the data that's updated manually in the other columns. But I am stumped on how to do this.
Any ideas? Many thanks!
Help Article Resources
Check out the Formula Handbook template!