simple loop code needed

  • Thread starter Thread starter Alan
  • Start date Start date
A

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
 
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
Click to expand...

Hi Alan,
I don't understand what you're trying to do!
Can you explain it a little better?
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
 
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 -
Click to expand...

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?
 
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.
 
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.
 
Back
Top