provided

I know this should be simple, but for some reason it's not working for me. I'm trying to locate in a cell the following phrase "5. IS THIS A COMPLIANCE SERVER, IF YES ICD MUST BE PROVIDED:" in a cell that looks like this: PLEASE COMPLETE THE FOLLOWING, ONE SERVER PER TICKET PLEASE. 1...

Hi There, I need to create excel tab after every 2 minutes as per sheet1 in workbook and rename them as per SR.no provided in sheet1 like below. <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> SR.NO 1 2 3 4 5 6 7 8...

So i am having an issue with a code that I was using. It makes everything capitalize on the page no matter where. Bu when I use code now it freezes the workbook and then crashes it. Is there anything I can do about this? I have provided the code that i use below Code: Private Sub...

I'm having an issue with a report and was wondering if any assistance can be provided. I've created a micro-enabled workbook that gives me 2 sheets of data(STEWARDS and INVENTORY REPORT) and even creates folders based on the information provided from my STEWARD sheet. I now want to create...

I am trying to ascertain the last date that a worker provided their services for us. I have created some unique lookup values which include the worker's name, the department they worked in and if the job was 'filled'. The data I have has every single shift that the worker has ever completed for...

I have the following XML Code to present the user with UNDO & REDO QAT Options in my workbook The commands and buttons do work - However I am only able to UNDO (or REDO) 1 level back - I was hoping to get several UNDOs if needed Not sure how many are provided in standard Excel Ribbon but I...

Hi all, Need help on macro to add a blank row whenever a checkbox is checked in column Q. I have provided a sample of the workbook.

After the brilliant solution to my thread https://www.mrexcel.com/forum/excel-questions/1059039-listing-all-values-within-range-values.html (which I am still working out on understanding the code), if there is more than one requirement in the sheet, is this possible?? If Value A, Value B...

Hi guys I don't know if the below is enough for people to suggest any improvements, but I wanted to ask if I can write the below in a more efficient way? its a if statement going through different rules...

Hello Guys, Hope you are doing well today, I appreciate your quick response and help on the above concept, however i have few things which i want to bring to your notice and require your assistance in getting one single function for the previous scenario provided in addition to the other two...

Hello everyone, I want to automatize my work with excel, but sumif function is giving me small issues. I provided a screenshot to explain you my problem. Can you please tell me how can I tell excel to sum all the values from "new errors" column but only if the event type is "ICH"? You can...

I've written a macro that processes seven reports every day. My bosses have asked me to set up a macro that adds to the original macro when new reports become available. In other words, a macro that creates a macro. If nothing else, I figure I can create a blank script in Word, an input box...

Hello Everyone, Is there a way for the sub code to prompt for a password before it allows for the sub to continue? Where if the incorrect password is provided by the user it exits the sub. Something like this would help a lot! Thanks, Pinaceous

In cell j2 will need formula to look at cell e2and if value =bz then result =7.2,if e2 = mx then result is 6.9, if e2 =or then result is 13.2,if e2 = pr then result 14.3,if e2 = to then result is 17.8, If none of these conditions apply then use this formula =(141/(g2+131.5)-.01111)*8.32 Thanks...

Hi I have a formula which currently checks a list of dates and returns a figure provided certain conditions are met. The formula I am using is the following one...

Hi All, I need to sort three columns on a condition that the First column 'B', is sorted in alphabetical ascending order, then column 'C' is sorted based on the texts is contains and finally column 'D' is sorted with the texts it contains. Background on the sheet (only FYI), column 'B' is the...