Hi mey You can give this a try. It contains a custom function PriceCode() Another option is to use nested SUBSTITUTE. If you need to have a 0...
Hi Dritan See attached. You will need to delete the error (it is showing when I opened the file) from cell E14 of the Data sheet. It somehow cau...
Hi Rene You can give this a try. You will need to change the path in the macro to where your files are located. Hope this helps. Sunny
Hi Daniel Instead of using complicated formulas, my suggestion is to use a 3-D sum across all your worksheets to create a summary and then sum whic...
Hi Paul You can try a formula instead of a macro. Assuming the info is in cell A1, in cell B1 enter =MID(A1,11,8) Copy down to as many rows a...
Hi Tim You are right about having many macros as the data is different for each situation. For most people, completing their job in only a few seco...
Hi David Unfortunately I am unable to show you the macro as it contains sensitive information.
Hi Tim Form my own experience, I would normally use a macro to "clean" the copied data. I have helped a colleague who used to take hours to "cle...
Hi Maurizio See if this is what you are looking for. The macro will copy the image selected in the userform from the Foglio2 sheet and paste it ...
Hi David Give this a try. Hope this helps. Sunny
Hi Shanu See if this is what you want. In cell C4 enter : =IF(A4<60,IF(B4>25000,25000,B4),IF(B4>30000,30000,B4)) Copy the formula...
Hi Brian You can try scale down the leading blank space. For example =REPT(" ",AL7/4)&REPT("|",AM7) It will look nice as long as the zoom is...
Probably you can use this as an example. It doesn't use check boxes but actual cells for the tick. Just double click on the gray cell to toggle the...
Hi Paulette You will have to create the buttons one by one on the worksheet (form) and link them to individual cells (preferably in another workshe...
Hi Paulette To retain the selection, link the check box, radio buttons, list box etc to a cell. Unfortunately your are using multi-select for th...