simple loop code needed

[Alan]

Hi
i'm reallly having a bad day today

i needs a simple loop formula

bascially from coloum g2 to l2

i needs to start from 1 to 5 and then when it to column h start at 2
for example

column g column H
1 2
2 3
3 4
4 5
5 1

can any give me code to do this

thanks

 

[alex]

Hi
i'm reallly having a bad day today

i  needs a simple loop formula

bascially from coloum g2 to l2

i needs to start from 1 to 5 and then when it to column h start at 2
 for example

column g  column H
1                2
2                 3
3                  4
4                 5
5                 1

can any give me code to do this

thanks

Hi Alan,
I don't understand what you're trying to do!
Can you explain it a little better?
alex

 

[Alan]

basically

i want the macro to enter values 1 to 5 for range g2:g6
then move onto row h2:h6 and start with 2 and place i and the bottom

so it should look like this

Column G Column h Column i
1 2 3
2 3 4
3 4 5
4 5 1
5 1 2

which then i can create a bigger range from G to P


can you help, i just can't work it out

 

[alex]

basically

i want the macro to enter values 1 to 5 for  range g2:g6
then move onto row h2:h6 and start with 2 and place i and the bottom

so it should look like this

Column G         Column h      Column i
1                          2                 3
2                          3                 4
3                          4                 5
4                          5                 1
5                          1                 2

which then i can create a bigger range from G to P

 can you help, i just can't work it out






- Show quoted text -

It sounds like you're looking for Excel help; you're in an Access
group!

Off the top of my head: why couldn't you type 1-5 in column G, and
then using your cursor (when it turns to a plus sign) increment each
value by 1 to the right? I'm guessing it needs to be automated?

 

[Douglas J. Steele]

This newsgroup is for questions about Access, the database product that's
part of Office Professional.

Your question appears to be related to Excel. As such, you'd be best off
reposting to a newsgroup related to Excel.

 

[Daryl S]

Alan -

This looks like Excel rather than Access. You may want to post your
question in the Excel forum - this is the one for Microsoft Access.