items

Hi I would like to add a list of items to a dictionary and then loop each item. The problem is, I don't know how to refer to a list range that is on another worksheet than the main data that is being filtered. "Items" are located on sheet wsList, so where am I suppose to add it? Dim dict As...

Dear Sir, I have two sheets, COMPONENTS: Content table with different headings of Components Name, under each heading there are many items mentioned. BOQ: I have Three column A,B and C. I have "Descriptions" in Column A, Column B is "RESULT" and C column is "ITEM FOUND" Now what I am...

Hello, I would really appreciate some help please What I want to do is search for A2 in column F:F and for B2 to be >= in G:G. So, 2 variables. Then, if these two variables are met I want to substact the 5 items that are required in C2, from H2 and H3 (5 items in total) and show somehow where...

Hi all, I have some code that I am using to import data from scripting dictionary array items. I am trying to get it to ignore items that have a date older than one year but it does not seem to like the code. I'm not sure why and wondering if anyone can help. Below is a small excerpt of some...

Hoping someone can help with this topic. I have a drop down that has 24 items that are always rolling or being updated. I'm looking for a way to filter on the last 12.

I have attached links to two spreadsheets: "Before" and "After." Here is what I am trying to do to "Before" so it ends up looking like "After." 1) If you look at the code in "Before," you will see I am trying to apply this formula to all items in column A: =RIGHT(A2,LEN(A2)-FIND("-",A2,1)) 2)...

Hi Community, Been trying to figure this out all morning. I have a range of data, with column headers. I have computed values based on certain criteria in a range of cells Similar to the following: Lets call it clothing items. Mon 400 Tue 300 Wed 6 Thur 7 Fri 50 I...

Hi, Newbie here! I've built a spreadsheet to track reports that are on track/due or overdue. I've added IF formulas to show the on track/due/overdue items and used conditional formatting to change the cell colour which is working without any problems. I have chart to show the volume of items...

Hey guys, I'm trying to search a value in multiple columns, and return a STRING if this value is found. The STRING depends on which column the value is found in. I have 2 work sheets: Sheet 1 = 'Items' Sheet 2 = 'Location On sheet 'Items', I have a list of values in Columns A. Some of these...

Good afternoon, Excel gods. I am in charge of gathering price changes of restaurant items from our distributor. Our Distributor sends me weekly and bi-weekly reports on only the items that have changed prices. In total, I have a little under 700 total items. I can't seem to figure out how to...

I have a sheet that can contain upwards of 1500-2000 rows. I am trying to get VBA to filter based on certain if criteria matches items pull into an array. Part of my code work perfectly since the column (Column U) only have minimal criteia to filer by to begin with. Column D on the other hand...

I have two listboxes Items for Selection (this is a multi select) Items Selected When all the required items are selected the user will click a button to send them to the Items Selected Listbox. When they appear in the Selected listbox I need them to be in alphabetical order and as I am...

I am creating an order form that allows users to select items from a drop down. I want a pop up to show up when they order the same item more than once. I have the following formula for the Data Validation (list) for the drop down...

Good day, I have been working to simplify a log that is used by a lot of people I work with. I originally built it years ago with helper columns and need to get rid of them. I have 2 items I need to solve but will post the second one in a different post. Item 1: I have a massive log, column B...

I am a complete novice at excel, so please forgive me. I am trying to take usage data from my order catalog for two regions and combine them into one table, while keeping the usage totals in discrete columns. The items in the two catalogs are mostly the same, with a few unique items in each...

Hi all, This has been quite a wonderful forum and great place to learn. I have the below problem which I require some advice. 1. I am trying to consolidate the sales of a few items from 3 different sources (3 different worksheets) 2. These 3 different worksheets name all these items...

Hello, I am really having trouble figuring out how to do this and would greatly appreciate any help. I have a column of data and I need to analyze ranges of numbers like this example: 10.2 5.1 2.6 11.6 5.7 I want to make be able to calculate for example (and eventually convert to charts)...

Hi All, I have a bit of a challenge... I use this retail software that spits out these awful csv reports that don't provide the information I need -- unfortunately it lumps all sales together, whether they are actual sales or comps. I want to create a formula or formulas to isolate all items...

Howdy and thanks! I have a table of data. I want to be able to highlight the row based off criteria. G2 contains a total (200) H2 contains how many items used (115) I2 contains how many items remaining (50) These aren't the actual but bear with me Highlight (orange) criteria for the row "if...

Hello, I have a list of text data in cell AQ2:AQ430 i need to find every occurrence of that list across cell M2:AP500 Then Highlight the matches only. I have gone through plenty of permutations of the condition formulas most have suggested with no good results. tried index countif isna vlookup...