Search results

Thank you David

I have another issue with this file, that I just found out. The date and time changes everytime I type in the the next raw. Time and date are supposed to remain intact. What am I missing.

Hi Ninjas out there, See the attached file This workbook is protected (no password, yet), and my people will only be allowed to edit these ranges $D$2:$D$29,$E$2:$E$29,$A$2:$A$29 , and please tell me how to accomplish the following: once my people type in any cell and move to the next one...

Thank you Narayan. I will try that, and give you the outcome. I'm already enjoying the VBA. I dont know what took me so long to get into it.

Thanks for your reply again. I am sorry I have caused so much confussion. I do have a specific folder to save my files into. The original SS that you have been helping me with is named "ORDER", once a sales rep fills up all of the fields, he saves as (with the customer's name) into that specific...

Thank you. I will learn this formula by heart. While it seems very easy for you ninjas, it's not for me. I will have to use it more frequently.

I kind of get your concept now, but I would have to re-arrange the whole document. This is a "pre-contract/invoice/estimate" where rows from 15 to 21 will never been applied any type of discount, however rows from 22 to 54 would receive any where from 30% to 45. That is why I had a subtotal...

Ill take a look at it right away. Thanks

. 1.I just one to have 2 cells added up in each sheet, and they are not merged. Would the rest merged cells affect that code? 2.I can try, but even the IFs were difficult for me to figure out. I'm sure there could be something shorter, but mine works beautiful 3.I dont know about Data...

All files contain only one sheet called CABINETS AND C_TOPS I thought I could have a separate file in the same folder that when I opened it, it would give me the totals that I need without me having to add manually new sheets values to a long formula. I think it's time for me to get into the VBA...

Thanks for your reply. I created this Workbook, and it's not that formula i want to focus on, now, but if there's a shortening for it, sure why not? I already have the total of my costs added up in cell N1, and my proffits in cell O1. I will be using this SS for every single client and will be...

Guys, I swear that b4 I post a question, I try to do my research, and I swear that i really can't figure out what to or how to replace the data in those modules that I copy and paste. I have never used them, but now I need a code: Here is the deal: the attached file is one of many that are...

Thanks, but NARAYANK found the issue. Thanks for your time and effort.

How do I make a donation to you?

Thank you very much, that's exactly what was hapening. This happened to me because I copied and paste, but now I learned something new, and I hope someone else did too.

Hello Ninjas, Check the attached file, and please teach me how to get rid of this glitch: M33's result should be U93, but it's giving me U94. I have tried everything already: deleted raws, cut and paste in a different area, deleted U94...etc..etc...etc

If all of us just spent a couple of minutes searching in the forum we would find most of our answers. Thank you very much. Ctrl + H is exactly what I needed.

Guys, I am sorry if I took a little of your time. YOU ARE AWSOME!!! I founf my answer in another post in Which HUI helped. This is what I did: =SUMIF($E$12:$K$39,"*CABINET*",$B$12:$B$39)

=COUNTIF(A1:A100,"*cabinet*"). Thanks, this formula worked for me also. Now please take a look at my SS, and help me have my results added up. My result should be 3 instead of two because I want those raws in B6:B8 that match the "countif" to be added up. Is it possible? Thanks again

PERFECT!!! EXACTLY WHAT WE NEEDED!!! THANK YOU FOR THE QUICK REPLY.

We need a formula(s) that can reflect a person's position compared to his team in different categories, e.g. 1st place(1), 2nd place(3), 3rd place(3) forth place(4), etc... In our sample file we show that GOLF won the 1st place for COUNT category, and MAURICE was 10th place. How could we...

Hello guys, I wanted to, first Thank you all for all the help, and then introduced my next project. It is called THE THREE P's "PPP". It is about a chart, graph or dashboard, which could grow or shrink, depending on a given data. See the attached document. I ALSO WANTED TO SHARED MY OTHER...

Thank you all for the quick response. This time I replaced E1's with Narayan's.

Please, see the attached SS, and let me know how to shorten the formula from B6:H6. I know there might be a way, but I could not find it. I leave it to experts. I am learning, though, check the one I just used in E1.

Thank you Mike.