simple loop code needed
in [General]
|
Prev: Unlock table
Next: Lista delle edicole
From: Alan on 5 May 2010 09:54 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
From: alex on 5 May 2010 10:00 On May 5, 9:54 am, Alan <A...(a)discussions.microsoft.com> wrote: > 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
From: Alan on 5 May 2010 10:47 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" wrote: > On May 5, 9:54 am, Alan <A...(a)discussions.microsoft.com> wrote: > > 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 > . >
From: alex on 5 May 2010 11:00 On May 5, 10:47 am, Alan <A...(a)discussions.microsoft.com> wrote: > 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" wrote: > > On May 5, 9:54 am, Alan <A...(a)discussions.microsoft.com> wrote: > > > 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 > > .- Hide quoted text - > > - 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?
From: Douglas J. Steele on 5 May 2010 11:05
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. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Alan" <Alan(a)discussions.microsoft.com> wrote in message news:C110855E-4DAE-4D70-8097-F17C61C89D93(a)microsoft.com... > 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" wrote: > >> On May 5, 9:54 am, Alan <A...(a)discussions.microsoft.com> wrote: >> > 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 >> . >> |