+ Reply to Thread
Results 1 to 7 of 7

Worksheet Question

  1. #1
    Greg B
    Guest

    Worksheet Question

    I have a workbook that is volitile and I would like for a macro to look up
    value j13 and copy each one onto a worksheet. I need it to be volitle so I
    dont need to change it each time a new person is put on the database.

    Any ideas would be great

    Thanks

    Greg



  2. #2
    Barb Reinhardt
    Guest

    Re: Worksheet Question

    How many worksheets do you have and where do you want to copy it?

    "Greg B" <laptopgb@ihugspam.com.au> wrote in message
    news:dki9ct$6n0$1@lust.ihug.co.nz...
    >I have a workbook that is volitile and I would like for a macro to look up
    >value j13 and copy each one onto a worksheet. I need it to be volitle so I
    >dont need to change it each time a new person is put on the database.
    >
    > Any ideas would be great
    >
    > Thanks
    >
    > Greg
    >




  3. #3
    Greg B
    Guest

    Re: Worksheet Question

    Thats the thing I have not a limit of worksheets. Here is the idea I have.

    The two cells i need from all sheets are

    "b3" and "j15"

    the thing is when I have a new person I have an automatic page setup where I
    get their details and a new worksheet is added. I just want to collect this
    information from these sheets and place them on a worksheet called "details"

    Hope this is a little bit more helpful

    Thanks
    Greg
    "Barb Reinhardt" <reply@tonewsgroup.com> wrote in message
    news:u7FJltg4FHA.3276@TK2MSFTNGP10.phx.gbl...
    > How many worksheets do you have and where do you want to copy it?
    >
    > "Greg B" <laptopgb@ihugspam.com.au> wrote in message
    > news:dki9ct$6n0$1@lust.ihug.co.nz...
    >>I have a workbook that is volitile and I would like for a macro to look up
    >>value j13 and copy each one onto a worksheet. I need it to be volitle so
    >>I dont need to change it each time a new person is put on the database.
    >>
    >> Any ideas would be great
    >>
    >> Thanks
    >>
    >> Greg
    >>

    >
    >




  4. #4
    Bob Phillips
    Guest

    Re: Worksheet Question

    Greg,

    There are a number of difficulties here.

    The obvious thing is to trap the NewSheet event and code into there, but the
    two cells will not be populated by then.

    Then there is the possibility that you will rename the default name
    allocated to the sheet.

    Does the details sheet have to know the source of the data?

    Could the code prompt and load those two values?

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Greg B" <laptopgb@ihugspam.com.au> wrote in message
    news:dkibu4$bob$1@lust.ihug.co.nz...
    > Thats the thing I have not a limit of worksheets. Here is the idea I

    have.
    >
    > The two cells i need from all sheets are
    >
    > "b3" and "j15"
    >
    > the thing is when I have a new person I have an automatic page setup where

    I
    > get their details and a new worksheet is added. I just want to collect

    this
    > information from these sheets and place them on a worksheet called

    "details"
    >
    > Hope this is a little bit more helpful
    >
    > Thanks
    > Greg
    > "Barb Reinhardt" <reply@tonewsgroup.com> wrote in message
    > news:u7FJltg4FHA.3276@TK2MSFTNGP10.phx.gbl...
    > > How many worksheets do you have and where do you want to copy it?
    > >
    > > "Greg B" <laptopgb@ihugspam.com.au> wrote in message
    > > news:dki9ct$6n0$1@lust.ihug.co.nz...
    > >>I have a workbook that is volitile and I would like for a macro to look

    up
    > >>value j13 and copy each one onto a worksheet. I need it to be volitle

    so
    > >>I dont need to change it each time a new person is put on the database.
    > >>
    > >> Any ideas would be great
    > >>
    > >> Thanks
    > >>
    > >> Greg
    > >>

    > >
    > >

    >
    >




  5. #5
    Greg B
    Guest

    Re: Worksheet Question

    I never thought of That I have code to add the sheet I could just extend it
    a little bit more. Thanks for that
    Just was too blind to see it that way.
    \
    Thanks
    Greg
    "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
    news:egkGh4g4FHA.3904@TK2MSFTNGP15.phx.gbl...
    > Greg,
    >
    > There are a number of difficulties here.
    >
    > The obvious thing is to trap the NewSheet event and code into there, but
    > the
    > two cells will not be populated by then.
    >
    > Then there is the possibility that you will rename the default name
    > allocated to the sheet.
    >
    > Does the details sheet have to know the source of the data?
    >
    > Could the code prompt and load those two values?
    >
    > --
    >
    > HTH
    >
    > RP
    > (remove nothere from the email address if mailing direct)
    >
    >
    > "Greg B" <laptopgb@ihugspam.com.au> wrote in message
    > news:dkibu4$bob$1@lust.ihug.co.nz...
    >> Thats the thing I have not a limit of worksheets. Here is the idea I

    > have.
    >>
    >> The two cells i need from all sheets are
    >>
    >> "b3" and "j15"
    >>
    >> the thing is when I have a new person I have an automatic page setup
    >> where

    > I
    >> get their details and a new worksheet is added. I just want to collect

    > this
    >> information from these sheets and place them on a worksheet called

    > "details"
    >>
    >> Hope this is a little bit more helpful
    >>
    >> Thanks
    >> Greg
    >> "Barb Reinhardt" <reply@tonewsgroup.com> wrote in message
    >> news:u7FJltg4FHA.3276@TK2MSFTNGP10.phx.gbl...
    >> > How many worksheets do you have and where do you want to copy it?
    >> >
    >> > "Greg B" <laptopgb@ihugspam.com.au> wrote in message
    >> > news:dki9ct$6n0$1@lust.ihug.co.nz...
    >> >>I have a workbook that is volitile and I would like for a macro to look

    > up
    >> >>value j13 and copy each one onto a worksheet. I need it to be volitle

    > so
    >> >>I dont need to change it each time a new person is put on the database.
    >> >>
    >> >> Any ideas would be great
    >> >>
    >> >> Thanks
    >> >>
    >> >> Greg
    >> >>
    >> >
    >> >

    >>
    >>

    >
    >




  6. #6
    Tom Ogilvy
    Guest

    Re: Worksheet Question

    Dim rw as Long, sStr as String
    Dim sh as Worksheet
    Worksheets("Details").Cells.ClearContents
    rw = 1
    for each sh in Worksheets
    sStr = lcase(sh.Name)
    if sStr <> "details" and sStr <> "setup" then
    rw = rw + 1
    With Worksheets("Details")
    .cells(rw,1).Value = sh.Range("B3")
    .Cells(rw,2).Value = sh.Range("J15")
    End with
    end if
    Next

    --
    Regards,
    Tom Ogilvy


    "Greg B" <laptopgb@ihugspam.com.au> wrote in message
    news:dkibu4$bob$1@lust.ihug.co.nz...
    > Thats the thing I have not a limit of worksheets. Here is the idea I

    have.
    >
    > The two cells i need from all sheets are
    >
    > "b3" and "j15"
    >
    > the thing is when I have a new person I have an automatic page setup where

    I
    > get their details and a new worksheet is added. I just want to collect

    this
    > information from these sheets and place them on a worksheet called

    "details"
    >
    > Hope this is a little bit more helpful
    >
    > Thanks
    > Greg
    > "Barb Reinhardt" <reply@tonewsgroup.com> wrote in message
    > news:u7FJltg4FHA.3276@TK2MSFTNGP10.phx.gbl...
    > > How many worksheets do you have and where do you want to copy it?
    > >
    > > "Greg B" <laptopgb@ihugspam.com.au> wrote in message
    > > news:dki9ct$6n0$1@lust.ihug.co.nz...
    > >>I have a workbook that is volitile and I would like for a macro to look

    up
    > >>value j13 and copy each one onto a worksheet. I need it to be volitle

    so
    > >>I dont need to change it each time a new person is put on the database.
    > >>
    > >> Any ideas would be great
    > >>
    > >> Thanks
    > >>
    > >> Greg
    > >>

    > >
    > >

    >
    >




  7. #7
    Greg B
    Guest

    Re: Worksheet Question

    Thankyou Tom much easier than me trying to get it running. Works Great I was
    definately going in the wrong direction

    Thankyou Again

    Greg
    "Tom Ogilvy" <twogilvy@msn.com> wrote in message
    news:Ohi377g4FHA.1276@TK2MSFTNGP09.phx.gbl...
    > Dim rw as Long, sStr as String
    > Dim sh as Worksheet
    > Worksheets("Details").Cells.ClearContents
    > rw = 1
    > for each sh in Worksheets
    > sStr = lcase(sh.Name)
    > if sStr <> "details" and sStr <> "setup" then
    > rw = rw + 1
    > With Worksheets("Details")
    > .cells(rw,1).Value = sh.Range("B3")
    > .Cells(rw,2).Value = sh.Range("J15")
    > End with
    > end if
    > Next
    >
    > --
    > Regards,
    > Tom Ogilvy
    >
    >
    > "Greg B" <laptopgb@ihugspam.com.au> wrote in message
    > news:dkibu4$bob$1@lust.ihug.co.nz...
    >> Thats the thing I have not a limit of worksheets. Here is the idea I

    > have.
    >>
    >> The two cells i need from all sheets are
    >>
    >> "b3" and "j15"
    >>
    >> the thing is when I have a new person I have an automatic page setup
    >> where

    > I
    >> get their details and a new worksheet is added. I just want to collect

    > this
    >> information from these sheets and place them on a worksheet called

    > "details"
    >>
    >> Hope this is a little bit more helpful
    >>
    >> Thanks
    >> Greg
    >> "Barb Reinhardt" <reply@tonewsgroup.com> wrote in message
    >> news:u7FJltg4FHA.3276@TK2MSFTNGP10.phx.gbl...
    >> > How many worksheets do you have and where do you want to copy it?
    >> >
    >> > "Greg B" <laptopgb@ihugspam.com.au> wrote in message
    >> > news:dki9ct$6n0$1@lust.ihug.co.nz...
    >> >>I have a workbook that is volitile and I would like for a macro to look

    > up
    >> >>value j13 and copy each one onto a worksheet. I need it to be volitle

    > so
    >> >>I dont need to change it each time a new person is put on the database.
    >> >>
    >> >> Any ideas would be great
    >> >>
    >> >> Thanks
    >> >>
    >> >> Greg
    >> >>
    >> >
    >> >

    >>
    >>

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1