part

Hi All, I found a video on youtube that draws bingo numbers with no repeats so I simply copied the Macro code by hand, the first part works and creates a random set of numbers the second part however is coming back with an error. This part works fine: Sub StartOver() Cells.Clear...

Hello, Looking for some advise on the the best method for accomplishing this task. I'm working on a project that involves pricing. We want to be able to analyze some pricing, but to do so, I need to transpose multiple lines of data into one line. Here is an example of the data. Customer -...

This is a two part question - 1. I am familiar with the countifs function however I would like to find out if one of the criteria is able to count if cell is not null. So for example if I have two columns A & B my formula would look something like =COUNTIFS (A:A, "XYZ", B:B, "CELL VALUE NOT...

Hi, I am trying to create a comment from the cell contents in an adjacent column (offset -1) for a range. The purpose is to create a popup comment that represents a part description when you hover over the part. <tbody> Part Number Part Description part 1 part 1 desc part 2 part 2 desc...

Looking for help on a formula Sheet 1 has a list of 3000+ transactions. Column A has "date", Column F has "Part Number", Column H has "Quantity" Sheet 2 has the totals that need to be filled in. Column A has "Part Number", Column C, row one has "January", Feb, etc. I would like to know how...

Hi Folks! I am back asking for your help. I receive a file in the following format. The rows that start with data in Column "A" are part numbers. Below those part numbers with data beginning starting in column "C" are accessory codes and accessory descriptions, pertaining to the part above. I...

I have PARTS listed in column A and CUSTOMER NAMES in column C. I need to look up column A and return all customers associated with a PART and display it horizontally. Any help would be greatly appreciated.

Hi, I'm trying to match actual orders to budgeted orders. Column A: Part number Column B: Actual Order Qty Column C: Display Part Number Most of should be the same as part number in column A, but not all of them map. Column D: Budgeted Order Qty I would like to add a column to show for...

I have a code that loads a value into 2 text boxes when you choose a part # in t lit box. I would like to modify the code so that it sees the part #in the list box and loads the text box, instead of upon selection of the part #. Can someone shoe me how to make the modification? Private Sub...

I have two columns One has Part Numbers (There are Duplicates) Second has Unit Prices I want to see the Average Unit Price when I filter. I cant use countif/SumIf.... I want to be able to filter on both columns so doing CountIf/SumIf by part number doesn't help me in this situation. I am...

I need a formula to find a specific word in column A then find another word on that row, and then give me the column number that the second word is in. So the first part would be =MATCH("Word1",A:A,0) The second part would be =MATCH("Word2",Row:Row,0) where Row is the result of the previous...

He goes over a little too fast for my newbie ears: I managed to adapt the formula to extract data from non adjacent COLUMN(S), but I don't understand the following: What part the AGGREGATE and SMALL functions play? Why he has to subtract the second ROW reference and divide? What the <>...

Hi, Is there any other alternative or shorter solution for rewriting the below formula example.i have read in an older post that the SUBSTITUTE function cannot handle the "old_text" part as an array{1,2,3,4,5,6,7,8,9,0} Thanks In Advance. <tbody> A1B2C3D4E5F6G7H8J9K0...

I am trying to get the formula that says "IF this cell contains this OR that" however there are 3 conditions. Here is an example of a cell: <tbody> PLT-NA-NA|CIG-NA-NA|GLD-NCORP-A|BSC-NCORP-A I have the first part of the formula...

Help please :) I have a invoice prepared and i am looking to have a part number from a drop down list but then want show in another column the description generated by the part number. Any help would be greatly appreciated Regards,

So at work a guy goes through a spreadsheet and color codes different part numbers will the fill function depending on the status of the part then we get a new list of parts on another sheet and he has to manually go back and forth do highlight the cells on the new sheet. Is there a way when we...

Hello guys, I have a string in which i want to find a part, and once found replace it with a different string. Say i have: abcd1abc I want to find the part cd1 and replace it with cd2 Replace(ActiveCell, "cd1", "cd2") But i want to replace text: cd(any number) with cd2. And as far as i...

Hi, In order to automate a site and get around using the date picker ive found I can remove the 'read only' part of the input on the site which allows me to input the date, however i cant seem to automate this. Im trying to change : <input id="fromDatePicker" placeholder=""...

I have loads of files that have a before save code within them. I need to change the location, is it possible to change part of the code without opening them all individually? This is the code Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If...

Hi, Appologies if this is long winded but it seemed the easiest way to explain myself. I need to create a solution to break the following table up into multiple, 2 part sections A&B. The total quanity of each section must be divisable by 15. Neither section can exceed 45,270 and the sum of...