$$Excel-Macros$$ I need a excel where users can add data but cannot delete.

2015-06-02 Thread Nasir Saikh
Hi Experts, I need to help to make a excel database. In the excel file I need, users can open the sheet and add the data write anything and can be save. But they cannot delete anything from the excel once they kept any value in the excel. Regards Nasir Shaikh -- Are you =EXP(E:RT) or =NOT(EX

$$Excel-Macros$$ Re: Inventory With PO Drop Down Lookup

2015-06-02 Thread Mandeep Baluja
Check this attachment !!! Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/groups/825221420889809/ https://www.linkedin.com/profile/view?id=312532939 On Wednesday, June 3, 2015 at 1:23:37 AM UTC+5:30, Bill Q wrote: > > See attachment. Essentially, there are two sheets here.

$$Excel-Macros$$ Multiple Hyperlink

2015-06-02 Thread chintz
Dear to all, please can anyone help me to resolve below problem. i have attached excel sheet which mention multiple hyperlink error problem when i change sheet name in workbook. is there any formula for hyperlink work after rename sheet name. Please let me know if anyone have resolution. Th

$$Excel-Macros$$ Re: Inventory With PO Drop Down Lookup

2015-06-02 Thread Bill Q
See attachment. Essentially, there are two sheets here. * Inventory (Destination sheet) * PO Details Both have a common field (item #). That would be the link. I would like to somehow view the PO details when clicking on a dropdown or similar type of tool. I just want to make it user friend

$$Excel-Macros$$ Re: Inventory With PO Drop Down Lookup

2015-06-02 Thread Mandeep Baluja
Hey Bill, Please correct me if I am wrong. You wan't to retrieve multiple values corresponding to same item number. The only thing which goes over my head is open PO(o) Can we have a sample file with the output required. Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/gr

$$Excel-Macros$$ Inventory With PO Drop Down Lookup

2015-06-02 Thread Bill Q
Hi, Ideally, I am looking for something that would look at another sheet so that it would show all outstanding Purchase orders pertaining to a specific item #. Both sheets would have the item # as the key. The dropdown would need to show multiple fields pertaining to the open PO(s) on that pa