vba -help

Hi guys, I have a simple problem, or at least i believe its simple. I have a spreadsheet that helps me to tracks orders. I want to be able to add a bit code to my current VBA script that sorts the data based on the values in a particular column (smallest to largest). Current table looks like...

I need to find a way to find and repalce using VBA so that 00904-0201-61 converts to 904020161 or 12345-6789-11 converts to to 12345678911 by removing the - between then numbers. ActiveSheet.Columns("C").NumberFormat = "@" or ActiveSheet.Columns("C").NumberFormat = "00000-0000-00"</SPAN> do...

I have a spreadsheet in which Worksheet 1 is a master list of names andgroup assignments. Worksheet 2 sorts these names into the respective groups. Worksheets 3 and 4 are group specific worksheets, pulling the sorted group lists from worksheet 2 into column A. Attendance Data for each...

Excel 2007 Windows XP Hello I need to populate a table with two formulas. The numbers of rows and number of column will vary. I've got my code up to the point where the table is outlined: <tbody> Employee Name Job Title 7/22/12 7/23/12 7/24/12 Employee1 Employee2 Employee3...

Hello Forum! May i ask for VBA codes help? The first sheet of the workbook is where everything takes place. The source of reference is on Worksheet two (known as Detroit) and on worksheet three (known as new york) On Worksheet one, the headers (text) are on row 1, from column A to column L. The...

Good morning, I wondered if somebody could help me. I have the following code but I need to work out how to put each variable on another line - I can't figure it out. So each "or/and" combination I want on a seperate line. Private Sub CommandButton1_Click() Dim LR As Long, i As Long...

=IF(COUNTIF($A$2:$A$7,C2)>0,B2,"")</PRE> The problem is that the value that is being place in the cell is not the correct value. In this case NIMOOC30 is in A2 and the value associated with NIMOOC30 in B2 is 6. Hoever the value returned in D8 for NIMOOC30(C8) is 4. I need it to be 6 <TABLE...

This is new to me..so the terms may not always be correct. I have a list in a column in excel 2010. This list is in the thousands. Let's say that the list is in C1 and runs to C4036 each of the numbers are different too. Each of these numbers represent a electonic component number in our...

Hello all, What I am trying to do is to take several parts of data from an excel sheet and move them to a ticketing system we use to log tickets. So far i have: Sub Fill_Form() Set IE = CreateObject("InternetExplorer.Application") With IE .Visible = True ' im using facebook as an example...

I've got a simple macro that makes copies of the original table 10 rows below the last table. Once it has copied the table it takes a same sized formula table and copies it next to the new table. Or so it should but the macro stops running right after copying the first table and I can't figure...

I'm trying to create a popup messgage box based on a cell value in a worksheet. I have multiple worksheets in my workbook. In my 1st worksheet "Bridger" I'd like a pop up box to appear when/if AE3<=AE4. The message will say "Time to order tickets". The remaining worksheets will have...

Hi, What is the fastest (and safest) way to delete rows based on a criteria which is a part of a cell value, within a specific column? e.g. cell value is 'temp flexi 12345678' and the criteria for deletion is 'temp flexi ' Cheers

So here are the basics: I am working on a large coordination/ scheduling document and want the ability to write a code that would turn certain columns (to be specified in the code by both ranges and single column references) transparent to a certain degree (again specified by code) This...

Hello Mr Bill Hello to the forum! In VBA if i want to select the first row in selection or the last row or both : how to write the code, whatever the selection is : relative selection 9 different no of columns and different no of rows ) but with the same format : double border line in first...

Hi Everybody! I'm new here and I really hope, that there is sb here who can help me with problem I'm stuck with. First things first: there is the part of code I have problems with: Dim Laenge As Integer row = 6 Do While row <> RowEnde + 1 On Error GoTo ende1 Sheets("PCExupload...

here's my problem i need a code so that the text is on the adjacent cell not on the same cell, if the cell is color red the message next to it is "out of parameter", and another color is green, and the message next to it should be "ok" the messages should be on the next column(F2:F50). Sub...

Hi, I am working on creating an electronic client database. It is a very simple design: for every client, a single form is completed with their information. However, what I am looking to do is to add a function that allows me to search for specific records based on some criteria (e.g. last...