item

I need a help to for a macro which search ITEM NAME for Master sheet and if found I want to Data sheet next to Item name (ie Item Code and HSN) Sample file link attached https://www.dropbox.com/s/w7nmrz0ae150r6p/Book557.xlsx?dl=0

Example: I have one item number ABCDE but this item number appears 3 times, on rows 1 through 3. Each row lists a different raw material off the bill of material, along with the budgeted tons. Material A 5 lb. 500 tons ABCDE Material B 1 lb. 500 tons ABCDE Material C 2lb. 500 tons...

Hi All, I have large data set of product SKU's that are organized with multiple sizes of the same item per row and need to break each sized item on to its own row with the correct corresponding size. I have attached screen shots for clarification. I'm really hoping you all can provide some...

New to Power BI and trying to figure a way to generate graphs based on specific Top N (other than top 1) count conditions without adjusting filters. The idea would be to have it auto update based on new data each month without having to manually select filters. Example using meal choices out...

Hi im looking for a way where i can get a total number of units by a specific date, but not by using a Pivot table. I then want to be able to manually change the date and the new information will appear. The data i have is below, Case N. is column A Etc <colgroup><col><col><col...

I have a spreadsheet with items similar to below: <tbody> # item code item description item size notes cost 001 Tool Box Prepack 1UN 47.75 CONTAINS: 0001 Screwdriver 1UN 2.79 002 Ladder 1UN 87.79 </tbody> I am trying to create a macro that will search for the word "Prepack" in...

Hi there, I'm wanting to create a formula that retrieves a unique cell value if multiple criteria are met. E.g. If 'Interface'!H8 matches item in 'ReferenceList'!ColumnT3:T245 & 'Interface'!I8 matches item in 'ReferenceList'ColumnU3:U245 then show corresponding value in...

Hi, I am curious if there is a way to loop through all control objects in a userform frame or do I have to loop through all objects in the userform and look for that particular frame as a parent? For instance, can I use a for each item in frame type loop? My Current code draws a mistype error...

Hello, This is my first post here and I have to say thank you already to many of you for helping me get as far as I have with my current project as I have found many answers by scouring these threads. However, an answer to my current problem is eluding me after hours of searching. I have a...

folks, i have a pivot table in which i wish to show the value of sales amount (calculated field) which, for each item, is the product of number of items sold and sale price. i have copied it to an adjacent part of the page to simplify the display for this post. also added the "should be" column...

Hello, I have a table with 2 columns (Schedule, Item) of data and I would like to create a formula under the 3rd column using under the criteria below. Criteria : If Column A (Schedule) shows "Yes" and if there are multiple occurrences of the same value on Column B (Item) that satisfies the...

I have a vba code that extracts ebay product details the code works fine if i am using a direct url in the code Original Code for search, but only searches 1 item .Navigate2 "https://www.ebay.co.uk/sch/i.html?_from=R40&_trksid=m570.l1313&_nkw=jackets&_sacat=0" This variation of the...

I would like to know if it is possible to use text from a cell to define a worksheet name within a vlookup? I have a power query with item product codes, each product code has its own worksheet containing details of the item Currently I am manually changing the name of the sheet within the...

Greetings, I'm making my way up slowly but surely to get better at VBA coding but the road is still long thus I humbly request for any assistance from your side :pray: I actually have a worksheet as per below: <tbody> A B C D 1 Date Item X Item Y Item Z 2 3 4 5...

Hi all, Does anyone know the lines of code that would allow me to put the value of a textbox1 from a userform in the column A just next to the 1st item of the listbox1 that is displayed in the column B ? It drives me crazy.. Here is the code of the listbox 1 For b = 0 To ListBox1.ListCount -...

Hello my combobox has 2 column counts and its items are added When i am clicking on the same it shows the values of 1st item. i dont understand why ? and not changing the value of idx as shown below infact clicking on each item should display in combobox text Private Sub ComboBox1_Click()...

Hello all, I have the following situation... I have a VBA code that checks an inventory sheet for deficiencies and expirations and, when it finds them, fills out each new row on the Supply Order Form with the name of the item, how many are used or expired, and puts that number in the...

I'm stumped on how to automatically sum data from a rolling report. The report I'm using is pre-set and only comes back in 1 format, with the criteria I need to use across the top with my sales cascading below. I want this to automatically calculate last week's total sales whenever I put the...

Hi everybody, my question is regarding with error handling in VBA on SAP Scripting. below you may see the my codes (which is not working properly) I have tried many times to make it better but unfortunately I am failed Shortly i would like to change the date of order in sap based on the excel...

have two sheets > SALES! & stocks! date & code in SALES!$C$6:$C$5088 & SALES!$E$6:$E$5088 respectively date out & item code in stocks!$C$59$:$C$1887 & stocks!F$59:$F$1887 respectively once item code scanned into SALES!$E$6:$E$5088 the current date will appear on stocks!$C$59$:$C$1887 with this...