container

HI All I am new to VBA and looking online and recording Macros to help build my code. But I am having a issue when I get to part of my code it is slow up and also making excel go into not responding. Is there anything I can do to my code to speed this up when I run it and also stop it going...

All, I have cleaned up a group queries that transform some data for monthly FP&A analysis we do. Without tedious detail we essentially take two exports and combine them into one, and then pull from each previous query (M-Code starts with a source like #"Join Pricing Data") to pull from that...

I have multiple columns with alot of data in them. I want to know how many i need of specific items. my table currently looks like this <tbody> Week number Container type Times appeared 1 Grey Tray 10 Black box 5 </tbody> The times appeared column is calculated using countifs but it...

Hello, I have a data set with over 60,000 lines of data per year. It contains the date and time an object was placed in a specific container and for how long it was in the container. The more objects that were simultaneously together in the container the greater the weight and loading on the...

I built a spreadsheet for tracking containers at work a while back. it would search column b of sheet2 for the value input into sheet 1 and return the associated value found in column a on sheets 2. Initially we did not have any duplicate container IDs. Having added new containers to our...

Hi Everyone, I've signed up on the site as I cant figure out how to do this for the life of me. I'm trying to accomplish some sort of a heat map in excel where the values change depending on where the you hover in the map. For example, using the image below. If i hover over number 1 it will...

I'm having a hard time with this, and I'd really appreciate some help. I've got 8 compounds distributed across 4 containers. I need to see if there are any compounds for which the container is empty. I can use =SUMPRODUCT(1/COUNTIFS(tbl[COMPOUND],tbl[COMPOUND])) to return number of distinct...

Hi There, Here is the problem: Say I have 5 inventory of products (liquids): Jan Feb Mar Milk 5 10 1 Water 7 8 40 Orange Juice 10 32 3 Now say I have the following containers: Container 1 - capacity 1 Container 2 -...

Hi I'm trying to find a way to calculate the weight of a container based on whether I add 1,2,3,4 or 5 in a cell that references figures from another sheet. For Example In sheet "Weights" I have 5 cells with 40, 200, 480, 760, 1040 these are weights from an irregular shaped container based...

Hi Everyone, If I want to search for letters in the cells that are not necessarily in order, how can I do that? <tbody> CEGB DFACE EGBDF FACEG </tbody> Example 1 I want to search for any cells that container the letters D,F,E My results should be cell B1 and Cell C1 because they...

Hi all, My UserForm.Initialize() call SetControlEvents. This function purpose is to find all my ComboBox and TextBox controls and attach to them, a class module events. I use recursive because Frame and MultiPage are container. My Initial call to this function is ...