Search results

Hi Narayan, That's great! :) One more thing is that after the message appears and you click ‘ok’, the cell is cleared- which is fine. However when I added a drop down list in column B and ran the macro – the drop down list in the cell also got deleted. Is there a way to bypass this in the...

Hi Abhi, Thanks for the above, I tried it out without conditional formatting, but it can be easily overwritten. However I can definitely use it for my other work as a quick reminder to people. Also how can I apply it along with conditional formatting? Did you mean I can add this formula...

Hello Narayan, Apologies about the inconsistency but your understanding is correct. Is it possible to make two sheets: one with only the data validation (no error message etc) & the other with the vba coding (with error message) as I am very interested to learn how both are done. Many...

Hello, A1='Ref#' B1 = Name C1 = Age D1= Comments E1=DOB I am looking for a formula or code to prevent cells from being left blank. 1) If A1 is blank than nothing can be written in B,C,D,E. 2) When something is entered in A1, I'd like only B1 to become mandatory. E.g: If B1 is left...

Hi Narayan, 1) No- I just used colours to help explain what I wanted done. Everything will be in normal black font. 2)Duplicates will be identified by: Ref# & 'Original Salesman'. So for the same ref# if OriginalSalesman is same than it is a duplicate and one of them should be deleted. The...

Hello, Is there anyway the above can be done/is possible?? Serena

Hi, Sorry about the above. I started my own as I was hijacking someone else's post. Narayan - look forward to hearing from you once you get a chance. Thanks for your help again! Serena

Hi Narayan, Cheers for the above! If you really don’t mind there is something a little more challenging as I need because I am facing changes & duplication of data. S0 I want to track & keep history of the changes of ‘salesman’, which may change every week. FYI - In my weekly reports...

Hi Narayan, Cheers for the above! If you really don’t mind there is something a little more challenging as I need because I am facing changes & duplication of data. S0 I want to track & keep history of the changes of ‘salesman’, which may change every week. FYI - In my weekly reports...

Hi, Thats great! My sheet is working. One more question for my learning – So I know s,p,t represent Salesman , Product and Quantity. Can I use any letters e.g. a,b,c...to represent such variables? Thanks ! Serena

Hi Narayan, Your spreadhseet was exactly what I was looking for. However I have alot more collumns. All the buttons work without any error messages after having the relevant ranges but the problem I am having is getting my data to paste in my last collumn. Please correct me if I am wrong...