Programming

Loop by Group Within Group
Can you show me how to convert sheet A to sheet B format? In sheet B, I want to give a space for every Sales Person and do not repeat their id / names. I also will need to give a space for each region within each sales person. I appreciate your help. sheet A Sales Person ID Sales Person Name customer type reg... 26 Mar 2010 18:00

Password entry userform
I'm looking for the code to load, enter a password, then unload a userform. Here's what I'm trying to do: I want users to click a button to open the userform. They then will scan a personal barcode which will use VLOOKUP to enter their initials in the target cell. Upon successful entry, the userform unloads... 26 Mar 2010 16:46

Reference list
Hi all, using excel 2007 If a cell has precedents and dependants ~ If I click on trace dependents once, it will show arrows to direct dependants If I click trace dependents more than once (till it beeps) it will expand the arrows to all indirect dependancies Is it possible to write a macro to show all depend... 27 Mar 2010 09:40

Extracting Data From a Chart
I am writing a program in Excel and I have a matrix chart or an array (15x11). What I am looking to do is to find the y-value which corresponds to a known x-value but the x-value is dependent upon a value entered by the user. In other words, I have a chart with 15 sets of x-values and depending upon a value w... 26 Mar 2010 18:00

Debugging
Using XL2007 I have lost the ability to debug VBA code. The code runs but it ignore any breakpoints or even the stop command. Can anyone tell me what has happened to my settings to make this happen? Paul Smith ... 26 Mar 2010 10:24

Debugging
Using XL2007 I have lost the ability to debug VBA code. The code runs but it ignore any breakpoints or even the stop command. Can anyone tell me what has happened to my settings to make this happen? Paul Smith ... 26 Mar 2010 10:24

Another Easy Question
How do I take the value from each cell defined in the range("A4:A40,F4:F40") and place 1000 before the value and give this new number a name. Example: Number in A4 is 37984 I want to use 100037984 I have tried... Dim F As Range Dim myNum As Variant Dim Num As Long Worksheets("Sheet1").Activate For Eac... 27 Mar 2010 12:00

Link checker: checking if a URL exists
Hello, I have a spreadsheet with 3,000 URL addresses. I'd like to create a macro which scan each line, and show me if the URL exists or not. For instance: Column A Column B http://www.google.com | valid http://www.jkgjkjkdjsl.net | invalid htt... 26 Mar 2010 10:24

Sumproduct error
Hi all, I got macro below which is not working as I get error syaing "Type mismatch" and on clicking Debug button it highlights the below line c.Offset(0, 3).Value = Application.Evaluate("Sumproduct((" & RngC = .Range("E1").Value & c.Offset(0, 1).Value & c.Offset(0, -1).Value & ")*(" & RngD & "))") Please ca... 26 Mar 2010 08:02

Move lines from one sheet to another
Hi, I have a macro that is intended to find an entry on one sheet and cut and pastes it into the next empty line on another sheet. I am getting the dreaded runtime 1004 with the message "Cut method of range class failed" The specific piece of code (part of a much larger macro) is: If rTargetCell.Value =... 26 Mar 2010 09:11