Look forward to it Mully.
By the time we next meet, I am sure that Arsenal will be top, and Tampa will
be floundering in the bottom half. Yeah!
Bob
"mully" wrote in message
...
Hi Bob
Re - jigged the sheet I had forgotten about the header row - worked
absolutely spot on when I took it out and I inserted the adjustments you
suggested .Once again thank you for all your help - I'm sure I'll be here
again sometime in the future and maybe we will link up again.
All the best
Mully ----- Come on you Reds !!!!! Tampa
"Bob Phillips" wrote:
Hi Mully,
That suggests that the value in Bn is not found in the newly generated
A1-A10, B1-B10, etc. I assumed that the values in B1:B30 would be within
those ranges of values.
You don't have a value in B1:B30 that isn't one of those do you?
BTW, the line
For i = 1 To 17
should read
For i = 1 To 30
and it will copy B-L from the rows 1:30 to the equivalent cells in rows
265:524
Owen and Jenas, you can have them both, I don't rate Jenas, and feel the
team has to play for Owen rather than vice versa.
--
HTH
Bob Phillips
"mully" wrote in message
...
Hi Bob
Getting this error message when running code ---
Run-time error '13' Type Mis Match
VBA picks out the line below
j = Application.Match(Cells(i, "B").Value, Range("A265:A524"), 0)
When this runs correctly will it also copy each rows cells C to L
along with the code number say A6 ??
Looks like you are right according to the press this morning Owen &
Jenas
are on Tampa Bay United's shopping list don't mind Owen But Jenas
ARGH!!!!!
Glad I went fishing before I read that.
Cheers ----- Mully
"Bob Phillips" wrote:
Is this it?
Sub Mully()
Dim i As Long
Dim j As Long
For j = 1 To 26
For i = 1 To 10
Cells(264 + (j - 1) * 10 + i, "A").Value = _
Cells(i, j).Address(False, False)
Next i
Next j
For i = 1 To 17
j = Application.Match(Cells(i, "B").Value,
Range("A265:A524"),
0)
Cells(i, "B").Resize(, 11).Copy Cells(264 + j, "B")
Next i
End Sub
--
HTH
Bob Phillips
"mully" wrote in message
...
Hi Bob
Now I'm on my own (Wife gone spending) had a good go with the
previous
and
got it working ok but because I didn't explain it properly - I
have
set up
a
test sheet with 30 rows - all using columns B to L filled with
data.
In
column B on each row I inserted a code number A1:A10 / B1:B10 /
C1:C10and
mixed them all up so say for example A6 could by the end of the
week
be on
row 17. I have jigged around with your previous code and it now
will
place
the code numbers in order A1:A10 on rows 33-42 / B1:B10 on rows
44 -
53 /
C1:cC10 on rows 55-64 all in the correct order how would i get it
to
grab
the
data in Columns C:L and put it on the same row that say A6 has
moved
to
which
at the moment is row 38. I was wasting so much time copying and
pasting
just
trying to keep up to date.
Thanks and all the best for the new season it looks like we are
both
going
to need it
Cheers Mully
"Bob Phillips" wrote:
Sorry Mully, didn't notice it was you.
Comments inline.
"mully" wrote in message
...
Hi Bob
So Viera's gone and Wenger wants Jenas to replace him eh!!
Jenas
not
in
the
same class in fact to use an old adage he's not good enough to
lace
his
boots
- and if he's an of International class Gawd 'elp us all.
To be prefectly honest, I think we made a mistake not letting
him go
last
year for Euro 40M to Madrid. As a consequence, Viera sulked. He
has
not
been
the same since his injury, not sure if he is in decline or still
moping,
either way it is time to cash him in, so I think Wenger is
correct.
I think the Jenas story is a Newcastle plant to entive your boys
in.
I
would
put money on Jenas going to Tampa Bay Disunited than the
Gooners.
We do need a strong midfield man though, to support Silva (Jenas
ain't
him
though).
Now back to businessas you know I've used this community an
awful
lot
in
recent weeks and thanks to everyone they've taught me a lot -
yourself
especially!!! just tried and used the revised macro worked
spot on
first
time
great & thanks
Pleasure as always.
can I ask another question regards this worksheet and its a
damn long sheet I shortened the macro to 20 row entries from
260
rows -
If I
gave each row in column B a code number as follows A1 to A10
and
through
the
alphabet to Z1:10 (thats why we have 260 rows) through the
week
after
sorting the data each day they obviously end up in different
rows
on
the
sheet. is it possible to place say A1:A10 in order in row
265-
274
then
B1:B10 in rows 275 - 284 and so so on through to letter Z.
Because
I
would
use Column B for the Identifier the other data would then be
in
Columns
C - M.
Not sure I get the question, but here is a stab
Sub Mully()
Dim i As Long
Dim j As Long
For j = 1 To 26
For i = 1 To 10
Cells(264 + (j - 1) * 10 + i, "A").Value = Cells(i,
j).Address(False, False)
Next i
Next j
End Sub
|