hello friends,
this is my first thread..
i really thank full if any one can solve my problem. i want to change value if i change products from drop down list.....
for more information please find attached file
hello friends,
this is my first thread..
i really thank full if any one can solve my problem. i want to change value if i change products from drop down list.....
for more information please find attached file
Hi, martinluther,
the best solution to my taste would be to use a table for the data and insert a pivot table on that showing Product name and Order Tyoe as Rows and Quantity as Column with Quantity as Data. The Table would expand when you hit Tab on the last field and the pivot would get the correct data without changing the area on which to work.
Please note that you would have to use the same areas when you are working with your formulas (you sometimes work with Rows 2 to 6 and 3 to 7 while your data ranges from 2 to 10, You could use $ to make these absolute addresses).
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Attached is a template for pulling in data from a dropdown menu. If you reorganize your data a bit and make sure names are consistent, you should have no problem creating a file that suits your needs. Please respond if it's unclear or if you have any additional questions.
Here is your workbook with the formulae filled in. Better organization of your data as in a table or other organized list would make this a little easier.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
thanks sir but if i have to many products mean more then two what i should do ?
If you upload a file containing the additional data, that will help illustrate what you're trying to accomplish.
HI,
up to my knowledge , the order number will be varying of every transaction , with respect to Partner ?
Kindly clarify me ? whether i am correct or wrong.
Punnam
Maybe this is something that you can work with or the second file that uses a table:
Last edited by newdoverman; 07-16-2014 at 02:16 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks