do while

I have a pretty big task in mind, and I'm stuck on a lot of parts. I've outlined it below: 1. search for a specific phrase in the spreadsheet (exact phrase, match entire cell contents). Store its index. This is easy enough: Cells.Find(What:="Vendor Terminal p/n", After:=ActiveCell, LookIn:= _...

Hi all, (Excel 2007) The issue I'm having is that a loop statement of mine is failing to recognize that a couple values are equal. It works for the first 3 iterations of the loop, then stops recognizing. I tried copying another set of numbers in the failing one's place, and that actually...

I wrote this code, but can't figure out how to get the data to compute all 15,360 iterations based on 10 variables (in blue boxes): <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument>...

Hi, I have 5 sheets in a file viz. Data,Class,A,B,C,D,E. I have written a macro to extract the class column from Data and remove the duplicates and list them in Class sheet. Now i want to write a macro which will autofilter the data based on cell value and paste them to the respective...

Hi there, I need to add anther argument to this code: Sub TestRun() Range("A1") = InputBox("How many Winners would you like to pick?") MsgBox ("This is a test run. All test winners will be cleared afterwards!") Range("B2").Select Do ActiveCell.Formula =...

This is the first part of my assignment. I am about to go crazy because I cannot figure out how to do any of this. I know how to go to VBA and create the subroutine, but after that i'm pretty much lost. Anyone have any ideas. I am extremely desperate! I just need something to look at to learn...

Hello, I'm looking to perform a calculation on some data from subtotals. Because of the format the last value isn't in column A and there are spaces in the data. Below is my code: Cells(1, 23).Value = "Unused Lines" 'calculates the unused lines x = 2...

I have a spreadsheet with about 20,000 lines. (The number of rows fluctuate) I need a macro to remove (delete) rows that contains the phrase "Off Peak" and "Weekend" I was setting it up in a loop but I don't know how to make the loop end after ALL the "Off Peak" and "Weekend" info is removed...

I have this code: Private Sub checkbox1_Change() If CheckBox1.Value = False Then Sheet2.Range("b13") = "" End If End Sub Private Sub CheckBox1_Click() If CheckBox1.Value = True And Sheet2.Range("b13") = "" Then Sheet2.Range("b13") = Sheet2.Range("a13") Sheet1.Range("C27") =...