Good morning to all,
An easy one..
I have the following code, it works, but it breaks whenever somebody chooses a full column ($A:$A) as it selects all the blank cells and performs all the loop to all cells..
How may the code be adapted in order to work with the selected range EXCEPT blanks...
I'm currently configuring a workbook that we send to customers to fill out with their employee names, emails, manager names etc. So I would have something like this:
Ok so I want to be able to select in cell; A1 either a tool or a task (fixed data) using a drop down list.
Once I select what I want in cell A1; I want Cell B1 to have a drop down list that refers to a list of either tools or a list of tasks depending what is selected in cell A1.
In my worksheet I have a table (RECIPES) with a list of ingredients in column A (A2:A50), a list of recipes in row 1(B1:K1), and the quantity of each ingredient required for each recipe in the range (B2:K50). On a different worksheet I created a new table (DAILYMENU) and in row A1 there is a...
Hello I am very inexperienced with Excel. I am hoping that someone can give me some help.
How do a create a list based on frequency without blanks. "Daily duties", "Weekly Duties"?
What I have is a worksheet (Duties-Alpha) This has column A Duty, Column B Frequency, Column C Responsible Pary...