Excel

Copper Contributor

I am trying to 2 pages to work together to make a 3rd page. I need the two pages to match up one line of data so it populates in the correct order and then I need one page to adjust the value of the 3rd page based on the matching columns from the other two pages. 

 

For example

page 1 is an inventory from my website and page2 is the inventory from my store's system. I am trying to get the columns to line up by SKU number (they are the same on page 1 & 2) then I need page 2 to update the inventory on page 3 as it corresponds with page 2 based on the sky number. I hope this makes sense.

1 Reply

@jwbarreYou need Page 3 to sum up page 1 and 2 for the same SKU

Did  I get it right?