assign

I have 500 rows of 6 digit numbers where I need to assigned a unique value based on first three digit of the number: For example: 100000-199999 Assign value U023 200000-299999 Assign Value U220 300000-366999 Assign Value U222...

Hello - I want to create a spreadsheet for a video game 50/50 drawing that I am in charge of weekly. And I need an easier way to assign the ticket numbers. So basically tickets are 2K per ticket. But if you buy 5 tickets, you get 1 free. I want a spreadsheet that has three columns: Name...

Hello Magical Excel Guru's! I am trying to determine if there is a way that I can use either a formula or vba to auto assign sequential numbering based on text. Basically we have the united states split into 5 zones. There are multiple states in each zone. Each customer will be assign a site...

Hello all,I am planning out a spreadsheet that will involve multiple sheets of entries. The first worksheet will be a filtered regurgitation of all the sheets. I want each item in the entire workbook to have a unique identification number. What would be the best way to automatically assign an ID...

Hello. Just signed up and am amazed at all the stuff one cando with Excel and VBA. I only know a handful of VBA codes and hope to learn alittle more and contribute where I can. I have my sports team files that I use as a hobby andrecently found out about VBA and how some things can be...

Using Excel 2010 I'm trying to assign the visible cells in a range to a variable after having filtered the data. However, I'm getting a Run-time error '13': Type Mismatch error. Following is the pertinent code for the variable: Dim strMaker As String strMaker = Range("C2:C" &...

Hi, For my own use and to replicate a childhood game I am trying to construct a cricket match. So far I have: A21=INDEX(A:A,RANDBETWEEN(1,COUNTA(A:A))) to return scores between 0 - 6 including OwZhat Then =IF(A21="OwZhat",A19,"") which in turn triggers A19 =CHOOSE(RANDBETWEEN(1,2),"OUT","NOT...

Hi Guys, I have a little problem, everytime when I need to run macro the name of files are changed. I want to automatize it maximally as I can and it need to be friendly for newbies. How can I assign name of chosen files to macros using box like below? Need to run twice this box, choose file...

Hi, I am here for a help. I am looking for code that which can help to assign position for a shape we insert in excel sheet. Example: If I inserted rectangle shape. given values in cell A1 =2 ,cell B1= 3 then this values should be positioning values for that particular recetangle shape...

i have a sheet with a hundred check boxes. Can someone help with a VBA script to assign the same macro to all checkboxes on current sheet?

Hi there, Currently I have a set of data consisting of an unique identifier (ID), four product properties (Brand.1.1, Brand.1.2, ...), and a preference. What I would like to do is for each product category (i.e. Brand, Price, and Preference) is assign numeric identifiers to values - that is...

Hi there, I have a column that contains non-numeric values (in some cases, repeated) - for example, software brands. Am I curious if there is a quick (1-step) way to assign numbers to each value in the column such that common elements will be assigned the same number. In other words, replace...

Hello, I have data for different time intervals for one month. <tbody> <tbody> <tbody> Start Time End Time Value 1 Value 2 1.1.2012 00:08 1.1.2012 00:18 12,3 13,4 1.1.2012 00:18 1.1.2012 00:29 14,6 12,5 1.1.2012 00:29 1.1.2012 00:39 8,7 9,6 </tbody> </tbody> etc. I want to create...

Hello All, I have a spreadsheet filled with data concerning this quarters sales (Customers, Qty's, Cost, etc). I have another spreadsheet with the Customer and the sales manager who handles the account. I need to assign the customers with their respective sales manager on the first spreadsheet...

Hi, I have written (adapted) the following code to turn specific cells into checkboxes, which works very nicely: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim CheckCells As Range, CheckCell As Range Set CheckCells = Intersect(Target, Range("CheckBoxes")) If...

Hello Excel experts out there, I have multiple rows of data with same batch number & different end dates. I want to be able to use Excel assign a weight to the row base on the latest end date. After that, I want to pivot the data base on the weight assigned to it. Pls see below for example...

Hi Guys, On my workbook, the user is presented with several buttons to click and upon clicking one of them - it creates a new worksheet called "SummaryReport" - this worksheet will not exist in the workbook unless the user clicks that specific button. However, once this button is clicked and...

Folks, Please save me from lunatic asylum! I want to position the focus onto certain specific cells, each of which I have defined as named ranges. Effectively these are starter cells for distinct sets of calculations. I want to give the user a choice of which starter cell to use. I want...

Hi everyone, How can I assign a value held by a global variable into a cell from within a VBA function? Function needs to make some if-then analysis therefore reaching a global variable from within a cell -even if it is possible, is not what I am after. The Function in VBA should be copying...

Hello Everyone, I have a macro which creates from a template (my MasterSheet), a number of sheets, which are based on a sheet called Tools. The data coming from these sheets is then supposed to transfer over onto a summary sheet(which I called Class). My problem is that with the macro that I...