Hi,
We have an excel sheet with fields pid, width,height,price. This sheet contains pricing for all of our products, and is generated nightly.
For each product, we also have a separate sheet with the same fields. We want to keep the pricing on these sheets in sync with the priucing on the sheet above. Is there a way to tell these separate sheets, to look for the pricing on the sheet above by looking for the matching combo of pid, width and height, so that once it finds it, it copies the price from that sheet to the separate sheets?
Please let me know if any ideas.
Thanks,
Tim
Bookmarks