item

I'm trying to set up a table that has a date, then different expenses on each date. Ultimately I would like to reference expenses on each day for specific expenses. Maybe the last 10 days of "Voids", a double vlookup that could find the date, then the void and return the column value. There...

Hi, in my job, I need to sort by multiple variables in the same piece of text. The text signifies the location of an item in the building. The titels go like this tsDMG1A002B, in which, the "tsDMG" is the type of bin(pretty unimportant), "1A" is the floor(variable 1) and "002" is the number of...

I have a spreadsheet with hundreds of tabs attached. I would like to add some data to each tab. Data would be the same but will change with each tab due to data that is already there. I would like to add this new item after the last item on the page. see mockup below where the red font I may...

Hi! I have a code that splits a workbook into multiple workbooks based on unique values in the first column found in Sheet1, however I just want it to also pull the second sheet (Sheet2) that is within the original workbook into all of the workbooks that split. Any help would be greatly...

I am working on a project where I need to have item numbers auto generate into a table, once the user fills in a specifc cell in the title with a number (eg. Site Review No. 2) and the item list would auto generate 2.1, 2.2, 2.3 in the below table. Is this possible? I have searched online and...

I've tried really hard to find an answer to this problem but cannot find it. Basically I have an table which is populated as below: <colgroup><col><col span="5"></colgroup><tbody> Band 1 Band 2 Band 3 Band 4 Band 5 Product Group A 10 25 40 55 60 Product Group B 15 20 25 35 40 Product...

This code seems to be erratic in its behavior. Sometimes when I change a cell the ones that are not in the range i select get cleared. When I go back and fix the entry it seems to work fine and then when I change another one if might clear something else. The concept was that if I changed a...

I am wondering if there is a unique ID similar to EntryID which remains unchanged with an email item regardless of if its moved to another folder. Does this exist?

I have a list of items ordered by a value representing years left and an value attached for each item. I need to determine if there is an easy method of choosing a range with an average age (say 15 Years in my example) and seeing what the average item value is for that group. At the moment I am...

I'm using this code to insert the name in a textbox when I selected an item in a list box. Is it possible to type in a name in a textbox and and search and select the item listed in the listbox. I have 4 columns in the listbox and the names are listed in column(1) cbName = ListBox1.Column(1...

I created a Power Query table that has columns for Order#, Order Item#, Part#, Quantity, Item Value, Customer, Address, Order Status and Order Date. I see that the "Subtotal" menu option is greyed out. How to subtotal Item Values by Order# or by Customer like I would in a regular Excel...

I set listbox items to load picture in the picture box. Selecting an item in listbox is slow, the higher the size of the jpg file, the longer it takes to load, which do not give room to select another item quickly. is there any solution to this?

Hello, I did use formula right in the cell before. But If I remove other info the formula will be removed, so I decided to use data validation lists instead. I'm having =INDEX(OFFSET(BusinessNameStart;MATCH(D3;BusinessNameList;0)-1;2;COUNTIF(BusinessNameList;D3);1);1) So, this one will find...

I have a listbox that allows for multiple selections. However I want to select just one of theitems based on a variable value. So I will set variable “Department” to the value in cellD28 Then use that variable to select just that one item from themultiselect listbox. Prior to...

Hi, I have tens of thousands of item numbers. At time I need to circulate spreadsheets that contain them. However, there are times where I do not want people or organizations to know these exact item numbers. Is there some tool, function or script that can change these item numbers to another...

Hi Guys, A few questions. I have a pivot table currently pointing to a very larger and ever growing worksheet that is currently over 500,000 lines long and a bit over 100 megs in size. It works well - does the job, but of course it is clunky. I refresh & work with this daily. 1. How do I make...

Hi guys, in the spreadsheet pictured below in dropbox we are trying to get the total of different parts of an item in to a table automatically. The table that starts in cell AV3 is causing an issue for us. Currently it is set to get the material/paint/prod plan/ factory/site/transport totals...

Morning folks :) I have 2 tables, 1 with serial numbers in and the other with the hours that the item has been used for like this... <tbody> 526314 632541 145236 634152 854796 964785 </tbody> <tbody> 343 -794 -27 -355 256 1530 </tbody> Is it possible to generate a formula that if...

I have a code that running on INBOX and extracting , need to modify it then it will be running on all subfolders. Please.. Private Sub ExtractEmails() Dim objNS As Outlook.NameSpace: Set objNS = GetNamespace("MAPI") Dim olFolder As Outlook.MAPIFolder Set olFolder =...

Hello, My code should filter each value and copy charts to different sheets. I looped this but it breaks mid loop. It works fine with 8 first values/sheets (should be 12 or so). I get error 1004: Select method of worksheet class failed. I highlighted the part in red when the error occurs. Sub...