Thread: excel formula while using dropdowns
View Single Post
 
Old 01-21-2017, 08:57 PM
rjf1127 rjf1127 is offline Windows 7 64bit Office 2013
Novice
  
Join Date: Jan 2017
Posts: 7
rjf1127 is on a distinguished road
Default excel formula while using dropdowns
I have page 1 that has a list of products in column A and in columns X,Y,Z,AA I have transfers to and from 2 different locations. on page 2 I have a dropdown in column A of the products from page 1. in column B I have a drop down with to and from the two locations. column C is the quantity. how do I get the qty from page two to transfer to the proper cell on page 1 after using the drop downs on page two
Attached Images
File Type: jpg Page 1.jpg (112.3 KB, 21 views)
Reply With Quote