Hi Stefi I suggest in future you attach a file instead of a screenshot as it will give us a clearer picture (and it save us a lot of time from re-k...
Hi Aye Can't download your attachment. Getting a 400 Bad Request error. Can you upload the file again?
Hi Rashid In cell F12 enter =IF($E$7-SUM($F$11:F11)>E12,E12,MIN($E$7-SUM($F$11:F11))) Copy down as many rows as needed. Hope this helps...
Hi Khushboo Gaurav Q1 - Use a custom format for the cell Q2 - Use Index/Match Please refer attachment. Hope this helps. Sunny
Hi Robert You can refer here to see if it helps. Sunny
Hi Aye You could try this but like Philip said above, it is best if the problem could be resolved at the source. Sunny
Hi Mike I suggest you use VLOOKUP. Sunny
If you need a macro then maybe you can try this. Just make sure that there is nothing under the data. The number of rows in your data must be consi...
No problem.
At least now with your attachment we can see what you actually wanted. I am not aware of any way that the formula can become B1, C1 etc when A1 is ...
OK now I understand why you wanted so many SKU. In this case using a userform is not recommended. Please refer attached. You only need to enter/...
Hi Saliha You can give this Add-In a try. Good luck Sunny
Hi David You could copy the required column and then use Paste - Paste Special - Transpose to do it column by column. If you require a formula t...
Furthermore I am wondering why you want a user form to do the searches. You could have easily done it using Data Validation (DV) and VLOOKUP in anot...
Other than the 10 SKU that you need to see at once, is the file that I gave you working properly?