fruit

Hi all, Please help! I need a macro that does the following: User will input the information in the table below. User will then click a button tied to the macro. The macro will return the filled out table in a newly created sheet. For the table created by the macro, the cells will need to...

Hi all, I'm mediocre at best with VBA so need quite a lot of help and may be asking questions to understand better. I need a macro that does the following: User will input the information in the table below. User will input a category (Fruit) and an identifying label (Color). User will then...

Hi, Please find below the Sample spreadsheet. <tbody> ACD AVAL AVALCD AVCDREF A Apple Fruit B Banana Fruit C Cat C for Cat Animal D Dog D for Dog Animal E Elephant E for Elephant Animal F Fox F for Fox Animal G Grape Fruit ....... ....... ....... ....... </tbody> Is it...

There are 4 excel sheets in a workbook and every sheet has huge data i.e. datewise productwise sales details Now i want get the below details in 5th excel sheet i.e. total sales of specific product in specific time by using VBA code as every sheet has atleast 4-5 lakhs data Why i'm asking...

Hi All, I am trying to work out a formula which allows me to return a value from a table based on 2 criteria with partial word match. I have an example below. I would greatly appreciate any assistance! Thanks <tbody> Group Date Apples #F2F2F2[/URL] , align: right"]10/2/18 </tbody>...

I have two data validation lists. The second is dependent on the first. So let's go with the old fruit and vegetable tables. First list, my choices are Fruit or Vegetable. The second list is dependent on the first. Let's say if you select Fruit, your choices are Apple, Orange, and Pear in the...

Hello! I've been asking a lot of questions lately, but please bear with me. I am trying to learn as fast as I can. I have two columns, V & W. What I want to see if I can do is vlookup V5 & vlookup W5 in the same table and combine them together. Example, in Sheet1 Column V says Apple and Column...

ood day, Hey everyone i found myself in difficult situation as i am unable to get unique number of product sold for each customer each brand .. for example : <tbody> Custo No Brand Product code Product Name 120 HEINZ 002 ketchup Paste 130 Fruit 010 Orange 130 Heinz 001 Ketchup Mayo 115...

Hello, I have a spreadsheet that contains several columns similar to the below: <tbody> A B C D E F G 1 Report Date: 6/22/18 2 First Name Last Name Category Sub Category Reg Code Dist Code Area Code 3 Jon Doe Fruit Apple 11 000 00 4 Jane Doe Fruit Apple 11 001 00 5 Jack Doe...

Hi, I am facing a live problem and hoping that someone can help me. I have 3 trucks and bunch of vegetables and fruits and I have to distribute these products in each of these trucks. The parameters that I have to check are Type, Quality and Availability. Explained with the screenshot: <style...

Hello, i have a spreadsheet that i would like to add a column to "E" and name it BUCKETS as the header. then i want it to copy a formula down from e2 down to lastrow that related to the information in column D The issue im running into is that the row numbers are not changing in the formula...

Dear Sir I am trying to search for same value in a column and return value base on some formula How to create a excel formulate that it will search in the column and if there is matching fruit, it will generate a formula to add the price andr select the biggest number in the WEEK? For...

Hi All, I'm having a problem getting index/match to work with wild cards, and I haven't come across a solution to my particular issue. Here's a simplified version: <tbody> A B 1 Apples Fruit 2 Pears Fruit 3 Bananas Fruit 4 Grapes Fruit 5 Corn Veg 6 Beets Veg...

Hi, I have a table on the left which shows a Van and which fruit goes in each van. What I want to do is replicate the right in terms of result, therefore having a list of fruit which I already have but using the table on the left show which van is carrying a particular fruit. (See Link for...

hi everyone i need some help from coctail macros/vba codes. i have some fruits(14) every week this fruits counts changes. example this week we buying 23 berry next week maybe 10 another week maybe buying 30 berry. we have unstable gradient "fruit ice" (its mean ice + fruit ) just...

I'm relatively new to VBA and I'm trying to write a code that will look at the receiving person column for Peter and will replace the Target Person and Target Fruit columns to match what's in the Sending Person and Sending Fruit. I used this thread here to figure out the code, but that thread...

Hello all, I have a data set with about 200 columns and 10,000 rows. Here is a sample: ColA ColB ColC Apple 1 Fruit Apple 2 Fruit Cuke 1 Veg Cuke 8 Green The result set I would like is: ColA ColB ColC Apple 1 Fruit Cuke 2 Veg 8 Green I want...

Hi Members, I am a beginner at VBA and would like to ask for some help from fellow members please. I have a Userform with a ComboBox which accesses a RowSource Range (For example, Column A) in a worksheet. I would like to filter the items in the ComboBox list (Column A) based on the...

I have this database with numerous different codes for the same listing: All Fruit............Fruit Code Apples..............AP1 Pears................PE1 Peaches............PC1 Bananas...........BA1 Pears...............PE3 Strawberries.....ST1 Apples.............AP3 Bananas...........BA4...

Hi, I'm looking for a way to have a if formula and data validation in the same cell so if i have in A1 Peaches, Pears, Bananas, in a Data Validation is there a way that if none of them are selected i can have "Please Choose from the list of fruit in Drop Down" as a formula in the same cell. As...