macro - formula

MasterFile.xls contains a list of student names in row 1 with that student's corresponding unique student number in row 2. Under each name there are a list of dates in ascending order according to when each student attended class. Currently we have 8 classes that meet once a week. Each time...

Hi, 1st sheet of my excel: <tbody> 35582ac 35582de 38920aa 38032f 332 122 21 32 </tbody> 2nd sheet of my excel: <tbody> IR No Assembly No Qty 04 35582ac 2 122 38920aa 3 122 38852de 1 32 38032f 2 332 35582ac 2 332 38852de 3 </tbody> Required Output...

Hello, So I am building a sheet that is tracking inventory within totes at work. There is two macros that I need help on. So a little info before I get into the need of macros, I have a macro currently built that keeps a running list of items that is in the tote and when you push a button it...

Can someone help?: I have a table in excel with customer information in it, I want to be able to search for one word in a cell by using macros. I already have a Macros but I have to type in the full customer name. Here is the macros I already have: Sub Find_Data() Dim datatoFind Dim...

Hello everyone. I am having a problem with my macro. It is giving me a compile error "Next without for" when I added this line "If Sheet1.Cells(i, 9) = Active Then". It worked perfectly before I added I am sure I am just missing a simple line of text. Your help is much appreciated. Sub...

Good afternoon, I have two main sheets that are outputs of a process. Sheet 1 has a list of critical roles and the behavioural competencies for that role and each role is rated depending on whether that competency is Critical to the Role, Highly Desirable, or not necessary. Sheet 2 has...

I am working on a process to remove inactive users from a system that we are trying to automate. The problem is we decided we want a 30 day buffer on deleting users and our current system does not make that easy. I can export a list of all inactive users ever and a list of users made inactive...

So I have three sheets "Yard", "Available spaces", and "Yard configurations" If cells in Column K of "Yard configurations" equals Yes, and Cells in column B in "Yard configurations" equals ParkingLocation then use text in Column C of "Yard configurations" to find the same text in column A of...

Hi there, I'm new here and just recently try to use VBA to make my life a bit easier. But still I'm away in making a code by myself. What I'm trying to do at the moment is to build a function to copy-paste special the value only. I've seen people posting how to copy and paste special from...

Hello All, I work at a test lab and i have over 500,000 test records. I need to remove the duplicate record rows. The file has this layout. A patient can have multiple test and on rare cases have a different case number. <tbody> Case Number Patient Name Test Patient ID 1011 John Smith...

Hey folks, I am a novice to excel vba. I need help from experts like you I have to develop a macro, where i could update the values of closing stock on weekly basis. Lets consider the macro excel file as Macro1.xlsm and the file containing the closing stock Clsg2.xlsx My methodology is...

I have a spreadsheet that has some macro that takes picture url's from one column to display in another. When I run the macro (Not sure if I said that correctly. I am new at this stuff), it goes smoothly until I reach url's that look like these ones...

Hey guys, I'm struggling with this one and this forum has never let me down. This is what I'm trying to do: I have 3 worksheets. Worksheet A is my macro, worksheet B is reference and always will be, worksheet C is where the data is being manipulated by the macro. - My macro VBA data is in...

I am trying to copy the format of one cell, highlight a range of cells and select visible cells only, and paste the format to those cells. The code is below. The last two lines is what is causing it to error. HELP Selection.Copy ActiveSheet.Range("$A$1:$LR$513").AutoFilter Field:=5...

Hi Everyone, I have a spreadsheet that contains 6 columns. One of the columns contains system descriptions, which may run a paragraph or two in length. I would like to create a Macro that searches the system description column for a key word and returns "true" in a new column. For example...

I have a simple macro that trims and changes the case of a cell from lower to UPPER, however when I run this macro and the cell is inside of a table, it seems to remove the table. The values remain, but it is converted back to just a range. Here is what my code looks like. Is there any way to...

Hi am a novice on VBA and have tried everything so I would be appreciative of any help. I am looking to write a macro that will select a max value in a column of a select area. These areas (or column heights) are varying in height and therefore I need the "Selection(x1up)" selection rather than...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

I hope you are well I have some code see below. Essentially what it does is allows a user to upload two workbooks and it performs a Vlookup. The Macro was working fine until the sheets went from 65,000 to 280,000 rows. I first got the error 'run time 6 overflow' so I changed 'Dim intLastRow to...

I am trying to write a bit of code that inserts a formula into one cell and then loops to insert the same formula in the cell beneath it and so on until I want it to stop. It looks like this at the moment: Counter = 1 Do While Counter < 22 myRange.Offset(Counter, 3).FormulaR1C1 = _...