Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-675960%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-675960%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%202%20pages%20to%20work%20together%20to%20make%20a%203rd%20page.%20I%20need%20the%20two%20pages%20to%20match%20up%20one%20line%20of%20data%20so%20it%20populates%20in%20the%20correct%20order%20and%20then%20I%20need%20one%20page%20to%20adjust%20the%20value%20of%20the%203rd%20page%20based%20on%20the%20matching%20columns%20from%20the%20other%20two%20pages.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3C%2FP%3E%3CP%3Epage%201%20is%20an%20inventory%20from%20my%20website%20and%20page2%20is%20the%20inventory%20from%20my%20store's%20system.%20I%20am%20trying%20to%20get%20the%20columns%20to%20line%20up%20by%20SKU%20number%20(they%20are%20the%20same%20on%20page%201%20%26amp%3B%202)%20then%20I%20need%20page%202%20to%20update%20the%20inventory%20on%20page%203%20as%20it%20corresponds%20with%20page%202%20based%20on%20the%20sky%20number.%20I%20hope%20this%20makes%20sense.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-675960%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-686563%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-686563%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F356098%22%20target%3D%22_blank%22%3E%40jwbarre%3C%2FA%3EYou%20need%20Page%203%20to%20sum%20up%20page%201%20and%202%20for%20the%20same%20SKU%3C%2FP%3E%3CP%3EDid%26nbsp%3B%20I%20get%20it%20right%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
jwbarre
Occasional Visitor

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?

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies