Search results for query: *

I have two spreadsheets in one workbook.  One is a "Master" work sheet with about 800 names in Column A separated by 24 rows.  For example rows 6, 30, 44.... Up to 16302.  In the areas between the names is data in columns B through L twenty deep, for example B9:L28,  B33:L52 etc up to...

If someone can show me one simple thing, I would appreciate it. If I go to a spreadsheet in a work book and select a cell, how do I find the cell in other spreadsheets that have the same content. Thank you in advance. Lou

I'm afraid that since I was concerned about using too much space, I did't make myself clear. At the risk of taking up too much room, I will try again. There are well over 100 golfers in this data base, but not all golfers are in each category, so the number of golfers in each category varies...

There are many sheets, and I would like to access the stats in all the other sheets for a particular golfer. Say I want to know how Tiger Woods did in Drives, Money making, Ranking, etc. that is in different sheets, then compile all of it as Tiger Woods Data Base.

This Rank Player Events Avg Points Total Points Points lost Points gained Country Week Last Week 1 1 Luke Donald 52 10.29 534.83 -197.68 191.05 Eng 2 2 Rory McIlroy 50 9.01 450.67 -146.59 208.67 Nir 3 3 Lee Westwood 47 8.16 383.68 -144.74 165.6 Eng 4 4 Tiger Woods 40 6.71 268.44...

Thanks to you both for your help. I will post a workbook file as you requested, but I don't know how. Not as simple, apparently, as attaching a file in email. LouLBI

I can download into spreadsheets such things as Point Standings, Money Leaders, World Ranking Driving Distance etc. with the listing of the golfers names in the order of their ranking.  What I would like to do is ask the question, for example, what is Tiger Woods statistics in all of these...

Andy In the learning mode, I was trying to figure out how to loop and I found this example published on the website http://www.mrexcel.com/archive/VBA/6681.html And modified it until it worked for me. It had that statement in it and I kept it, but at my stage of knowledge, I don't know what it...

My apologies to the forum. I had some cells in the spreadsheet that were occupied. Loulbi

Sub LoopRg() ' ' LoopRg Macro ' Macro recorded 6/9/2012 by Lou ' ' Dim ColStart As Integer Dim ColEnd As Integer Dim x As Integer Dim y As Integer Dim z As Integer 'Define your range start and end ColStart = 6: ColEnd = 6 'x = the number of ranges to go through For x = 0 To 8...

I created a file partially by recording, and since it was repetitive, I did some copy/paste with editing. It ended up about 18 pages long, but it wouldn't't execute, and gave an error message of "procedure too large". I can't find any obvious syntax errors, and I didn't know that there was a...

Sub FillLabels() ' ' FillLabels Macro ' Macro recorded 5/18/2012 by Louis Napoli ' '     Range("A1").Select     Selection.CurrentRegion.Select     Selection.SpecialCells(xlCellTypeBlanks).Select     Selection.FormulaR1C1 = "=R[-1]C"     Selection.CurrentRegion.Select    ...

Is there a "Rosetta Stone" type reference that shows what each statement does? Sorry that I don't know what IMHO stands for.

This is what i get when i run the routine Sub ImportFile() ' ' ImportFile Macro ' Macro recorded 5/17/2012 by Louis Napoli ' '     Workbooks.OpenText Filename:="C:\Excel VBA Practice\Ord9711.txt", Origin:= _         437, StartRow:=4, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 1), _...

In trying to reproduce lesson 2 p 33, I write Sub ImportFile() ' ' ImportFile Macro ' Macro recorded 5/17/2012 by Louis Napoli ' '     myFile = Application.GetOpenFilename("Text Files.*.txt")     Workbooks.OpenText         FileName:=myFile, _         Origin: = xlWindows,_         StartRow:=4, _...

I am using this as aself teaching text. I find it hard to follow and if I make an error it is difficult to recover. Is anyone familiar with this book?