terms

Hi! I kindly ask for a little help. Any idea how to highlight values with conditional formatting? For example: I would like highlight value within "Cycle times", if the total is bigger than value in "VMD payment terms". For row 1 I should get highlighted "Cycle time 1" (116>30), for row 2...

Hi, I have the code below which runs a regression for me in Excel 2010. You will see that the DV range (X) is dynamic from AV27 down, so when the quantity of data changes it references it properly - this is fine. The same goes for the IV range (Y) but it is dynamic only in terms of the quantity...

Hello, My apologies if this question has already been asked. Please let me know if there is a list, website, publication, etc. that provides a list of most of Excel VBA's terms? I am looking for things like "Boolean, String, etc." where there might be other options, as well as terms for...

I have 2 tables, the first has Job Titles, I want to search the text of those job titles to see if they match any standard terms stored in my second table. My second table, which contains the standard terms, has multiple fields I'd like to search through to return the records that match. For...

Hi to everyone, i would to create a vba code so that to count the col "A" by "Terms of Stay" and "SUM in col. "B" for each type its accommodation as my below example. In schedule 1. are the original data and in schedule 2. is the expected result. Many thanks in advance Schedule 1...

I have a list of eleven (11) terms by which that I need to filter the data in column "C". If any row contains any of these terms, I want to show only those rows. I can keep it on the same tab. I need to repeat this every month with new data. What is the easiest way to do this?