reason

Hi Sir I have mentioned below table: <tbody> ORDER_NO Reason For Rejection 4532599 Allocation Stock Mismatch Packing Surplus (blank) 4535662 (blank) 4535724 Unavailability of Stock 4535729 Allocation Stock Unavailability of Stock (blank) 4535738...

Normally when I type out code, VBA auto-populates some information for me. For example, when I type me.txt, it will show me the fields that I can choose from. For some reason, it's not doing this anymore. Thoughts on what setting I need to adjust?

I have two sheets for ease lets say they are called Master Data and Sup All the data is on the Master Data Sheet so its here I want to find the values to return to Sheet Sup I need to find out a supplier if 3 columns of criteria match on both sheets and then return the unique value on Master...

I hope that I can explain this clearly. It seems straight forward, but for the life of me, I have spent already 5 hours trying to figure this out. I have a full list of 14 Reason Codes along with their values. Basically, I need to find the TOP 3 (largest) Reason Code Totals (values) from...

good evening trying to copy all values (numbers 1 through 4) in column e to a new appropriate worksheet. For some reason not all data is copied over. There are many spaces between rows, do not believe this is the reason? Used this code before, no issue in past. Any help would be...

Hello Id like to create a button that automatically create a new row in a table, table is named ITLog_Table The table contain the following columns. ITLog_ID = primary key for the table ITLogDatum = date field Reason = picklist of 4 alternatives ITComment = text field IT_ID_SK = secondary key...

Hi Why in excel VBA there are 2 classes one is Workbook and the other is Workbooks. It is so confusing to have 2, what is the reason? Thanks

SKU Reason Code Total Cost Date A123 5 100 1/1/2017 B456 98 200 1/2/2017 A123 98 300...

Hi, this is my code; the error occurs here. Here are the references I've selected, it was working before but for some reason it doesn't now. Please help!

Morning, I created this formula (see below) yesterday and I've just realised that it's not working and I've figured out the reason... How would you change it? =COUNTIFS('Tier 3 Tracker'!$F:$F,"<=30/09/2017",'Tier 3 Tracker'!$Z:$Z,">=12")-COUNTIF('Tier 3 Tracker'!$AT:$AT,"<30/06/2017")...

Hi i have written a code that adds a pdf to an email and names the pdf a value from a certain column in a cell and for some reason it is adding a " before the name when there isn't one any help??

title says it all, here's what I have now, but for some reason, it's not working when it should... Range("A3").Select ActiveCell.Offset(1, 0).Activate Dim tbl As Range Set tbl = Range(Selection, Selection.End(xlDown)).Select MsgBox tbl.Rows.Count

Hi I have a data model that has approximately 4 tables to refresh from SQL. The problem is it is adding other spurious queries in the model after refresh. I have deleted any additional sheets and refreshed the data model and that seems to have fixed it, but is that the reason or will this...

I have spent a lot of time researching this topic and am coming here as a last resort. Thank you for reading. A table is for loans and the reasons they were denied. The columns are as follows: <colgroup><col span="2"><col><col></colgroup><tbody> Loan# Narrative ReasonForDenial1...

Hello All, Ive been trying a few things in other threads, but just cant seem to get this working. I have specific conditions that need to be counted per month. <tbody> ID Reason Timing Date <tbody> CRQ145074 </tbody> <tbody> Successful </tbody> <tbody> Standard </tbody>...

So I have a workbook with multiple sheets in it. For some reason, I am not able to set custom views on any sheets. What am I missing?

Hello all, I have a worksheet which contains dates that people have been out on visits and wish to report how many times there was a visit occurrence within a particular month undertaken by a particular individual for a specific reason. Both the individual and reason are also logged on the...

I have a rather large and complicated spreadsheet that has developed an odd behavior. It will stop for no reason on the same line of code. A simple F5 command will start it back up again, but I can not for the life of me figure out why. It's acting as though a STOP commas were in the code but...

Hello, I have been attempting to make a spreadsheet for my fantasy football league draft. In the spreadsheet, I have a searchable dropdown list which I constructed using this tutorial: How to create a searchable drop down list in Excel?. My data is taken from a dynamic web query, and my...

hey all - i am back again. so i am trying to sum up H5:L81 if the corresponding text in F5:F81 = "ABC123". for some reason it is not pulling when i use the following forumula =SUMIF(F5:L81, F5:F81="ABC123") what am i doing wrong? thanks!