vegetable

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, 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...

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...

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 everyone, I'm trying to create ranked subset lists from a 'master' ranked list and have subset lists update dynamically as changes are made to the master list. Boiling it down to a very simple example below: What I have (sample master list) of overall rankings: <tbody> 1 Vegetable...

Greetings people, I am having a huge blockade right now and I would need an inspiration... I built a database for our employee to fill in. From Time to Time, we know that false information can be filled in. I have certain "Keys" that guides me to check if what they have filled in is correct...

Sorry for the horrible description, but if I knew how to explain it better I could probably look it up. But is there a function that will output to a single cell all the row numbers that reference a single description? In my example below, I'm trying to write a function for cells C7 & C8 to...

Hi all - first post, would appreciate some help. I have an extract from SharePoint on Excel and I want to do a lookup against my Excel mapping table. The table I have in the spreadsheet is the "List from SharePoint" where I have a string with lots of # and ;s, I want to use that string and...

Hello All, I think I'm quite close with this one but I'm drawing a blank. I have a list like the one below only much bigger. For the example here i need a Unique Distinct list of just Meat and Vegetable. The formula i have is...