assign

Hey! I have finances laid out in Excel. There are multiple worksheets in the workbook. Each worksheet is for a particular year. "2018" "2019" "2020" etc Is there a way to assign a calendar year to each of these worksheets? ie: I want to assign the year 2019 to the 2019 worksheet, so that...

I have a 3x3 migration matrix and I would like, based on the transition rates, to randomly choose which items to move from a state to another and keep the same distribution, for instance if i have this array: Pupil Grade Grade N+1 1 A A 2 A A 3 B A 4 B B 5 A B 6 A C...

Hi, I have an excel sheet with two columns Col 1 - Named Bounced - contains - All bounced emails Col 2 - Named Data - Contains Complete Email data Requirement - I would like to assign "Y" in Col C if the email in Data matches with Email in Bounced. This is to separate the bounced emails from...

Hi guys, I have Name (let say myName) that I am adding value (let say myValue). This is not the range, I want it to hold the value itself (which is name of another workbook for later use in VBA). In the name manager myName shows correct value, but when in VBA I am trying to assign myName.value...

I've used VBA before for something similar, but that was when I had some helper tables. Not sure where to begin with this one. Basically for each range, I need to assign a sequential number to the range, and then I need to assign a sequential number to each row within the range. Here's what...

Hi, Just out of curiosity. How many queries we can have in a database. Is there any limit on number of queries we can assign to a table

Hello, I uninstalled, Microsoft Office and reinstalled. Still cannot assign a hyperlink to a cell. I cleaned my PC of any Microsoft Office file (used the cleanup Office Microsoft utility) still have the same problem. right click, add hyperlink, and press return. right click again and it's blank.

Hi I have a form with a combobox that contains 1,2,3,4 I need to create a work worksheet at Runtime and assign it the following properties. Name = "Week" & the value of combobox CodeName = "wks"& Worksheet name I get a compile error on the CodeName ( Can't assign to read only property) Here is...

hi guys I have 10 staffs in a group. Each staff is responsible for the closure of the computerized system at the end of the day. I need a vba code to assign the closure to each staffs.Each staff are entitled two closures per month.Working days are Monday to Friday. Is it possible to have it...

Greetings, Not sure what I am missing here...looking to assign an integer value to a column c = Workbooks("Matrix.xls").Worksheet("Paper1").Cells(1, Columns.Count).End(xlToLeft).Column Thanks!

Hi there, I have a page which is generating dynamic rows and I need to assign a macro to one of the cells in the process. I can add strings via the vba, but I cannot suss out how to make Range("A" & row) assign to macro 'Macro1' if you can point me in the right direction, that'd be ace! Cheers

I created a maco (Clearcells), but I cannot seem to make it work. It should clear the contents from cells W3:W5 in a different worksheet (Calls Data) and then assign W3 with the value of 1. I am missing something here. Also, how can I add the code to include to refresh a pivot table after the...

Hi everyone, total noob here. I hope don't miss anything, in that case i apologize. I have this task: assign a random probability to a table of items. For example: i have a table composed by 10 elements Item 1 Item 2 Item 3 Item 4 .. Item 10 To each one i should assign a probability, aka, a...

Hello, I have a macro that grabs a specific email template then attaches a specific PDF file to it then sends it all off without display. Here's the code: <code> Dim objOL As Outlook.Application, msg As MailItem, p$, i%, ap$ 'Below is the location of the all the workflows on the network ap =...

I have a list of invoice dates between two periods for a total of 260 business days. I need to find a way to assign a number between 1-260 to each invoice date. I have other fields being pulled in that is duplicating my invoice date preventing me from sorting and numbering 1-260. I hope my...

Hi All, I need a formula to look at values in 3 columns and then based on what is displayed assign a score. The first column is a status (green, yellow, red), the 2nd is a yes or no column and so is the 3rd. So for example if the first column is red and the other 2 are "yes" then it needs to...

Is there a way to assign a unique key to records, after they have been sorted? I have code that currently reads the value of a cell in the last row and adds 1 to it. The issue is, I have to sort the same sheet, which will inevitably cause the numbers to become non-sequential. I was thinking...

Hi How should I use IF or IFS function to deal with the situation below. Many thanks! I would to assign the number "1" for the age group of 1960s, "2" for the 1970s and "3" for the 1980s. Current data: <tbody> Date Age Group 1/1/1960 31/12/1969 1/1/1970 31/12/1979 1/1/1980...

Dear All, I think I need to write my very first VBA macro, but I have no idea on how to begin (other than how to open the VBA editor). Maybe I don't need the VBA but I don't know how to do it with the basic Excel functions. PLease note that I am working in excel 2010. So what do I want: I...

Hi guys, I'm creating a file that allows me to automatically determine the number of items to assign to a person depending on their current bucket load. I'm having trouble looking for the code/formula to insert that will allow me to do what I'm looking for. Here is my sheet...