offer

Hi Excel Experts, I'm coming to you with a question, I'm helping out my friend with digitalizing their tools for their business, starting with a customer list, so they can use the details later for mailings, (now everything is on paper and in the word templates, so they don't have a nice...

Dear all, I have the following table and what I want to do is: When I start typing the offer number (or when I finish typing it), the macro automatically copy all the information recovered from the correspondent line previously input in the table. For example: If it type 45658552,it...

Hello,</SPAN></SPAN> Combine all products with different varieties to achieve a special offer price package </SPAN></SPAN> I am looking for a solution on how many special offer price packages can be prepared from the product and variety list of D5:F12, Note: there is Product A To H & Variety...

Hello hello hello, I'm trying to replace a formula within a Macro to optimise my code a bit. Previously, this was written and references a workbook called Capacity that was already opened previously in the code: Range("Z3:Z" & Lastrow).FormulaR1C1 =...

Dear Experts, I am looking to create a macro that enables me to move selected data in various cells from an "offer" sheet to a rows in "database" sheet. I have data in row 26:31 under constant headers where i input data on the offered products, i.e. grade, production year, chemicals, price...

I have the following formula: =OR(isna(C8), C8="None") When C8 matches neither condition it returns False When C8 = None, it returns True However, when C8 is #NA it returns #NA - and not True =OR(isna(C8)) returns True when C8 is #NA Can anyone offer any insight, am I doing something...

From a list I would like to generate combinations of n members from a set of x possibilities in Power Query. I have found some useful code here on creating combinations of members based on all possible values of n, and here on generating permutations for x, but I regret that I'm not good enough...

Hello I’m having a brain fart lol I have a 4 column table Column a dates Column b the words can be Offer or declined Column c will contain numbers Column d will contain various words I want a formula to look through table and identify the word Offer only and return the total of column c...

<tbody> S NO CODE NUMBER MOBILE NUMBER REFERING NUMBER 1 6375871156 2 3 </tbody> Hi good morning, I need your help for making the above chart as smart. I am giving a offer to my customers, who are purchasing mobile phones in our shop. I want to give a unique offer code...

I know how to reference 1 range of cells in an if statement. I had the below and it worked well. =IF(ISNA(MATCH("Yes",'Ticket Offer Info'!B21:B24,0)),"No","Yes") But I have having trouble figuring out how to add another range as an "OR" to the formula. I need to also reference any yes in...

Good morning, I have 300,000 rows of data in Column A. I am using a Macro that has countif in it and it takes forever to run. I am looking to have a running count greater than 1. Can anyone offer me a different solution? Thanks in advance! Sub CountingMoreThanOne() Dim LR As Integer LR =...

Hi In a cell I need a conditional formula(?) based on the value of another cell. If another cell = "yes" then I want it to require user to choose one of the values from a list If another cell = "no" then I need just to enter text 'N/A' and no offer any list How can I do this? It's probably...

I am trying to write something in VBA to get all Seller info and Price from Amazon Seller Page, My code is given below.Sub RunNewModule() Dim ie As SHDocVw.InternetExplorer Set ie = New SHDocVw.InternetExplorer Dim html As MSHTML.HTMLDocument Set ie =...