$$Excel-Macros$$ Automatically read conditional data from one sheet and write conditionally on other

2016-03-26 Thread nitin goel
I am trying to make an Invoice and inventory management sheet in excel. Sheet1(ITEMS) - List of all items, Name, Value, tax, Unit of Measurement Sheet2(SALES INVOICE) - Invoice Template, we select items and input qty to print invoice. Sheet3 (STOCK oUT) - On a button press on sheet2, qty for ite

$$Excel-Macros$$ lookup from list or to find a cell contain any one of the item in the list

2016-03-26 Thread Ganesh N
Dear Team, Kindly request to help me with some formula to find the cell contains any item from the list. I have used search formula but it is not working if the list of item in different order. Working in one sheet and list are in another sheet If you have any concern kindly let me know. Thanks

$$Excel-Macros$$ Bell curve in excel 2010 and above

2016-03-26 Thread santosh subudhi
Hi All, I am looking on to prepare a bell curve for my team based on their monthly preformace. Which should show them where they stand in comparision to others and it has to be prepared with formula only. -- Regards Santosh santoshkumar.subu...@gmail.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT

$$Excel-Macros$$ Hi

2016-03-26 Thread kuldeep rawat
-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, For