+ Reply to Thread
Results 1 to 6 of 6

Copy Information into a template

  1. #1
    Registered User
    Join Date
    07-14-2006
    Posts
    49

    Copy Information into a template

    Hi All,

    I hope I am posting in the correct place.

    I know exactly what I want to do, just no idea how to do it.

    Please see Tab 1 shown here:tab1.jpg. This tab holds all the data needed. As you can see, there is 2 command boxes (Let1 & Let2) on each line of data. My data runs up to 400 rows at any time, I have cut the info down for this demo.

    When the Let 1 command box is pressed, I would like the relevant information feed into Tab 2 from that row. So for example, if i press Let 1 situated in A3, information for Emma will pull through to Tab 2. Tab 2 is shown here:tab2.jpg.

    Tab 3 works in the same way, but i would like that to populate when Let 2 is pressed on a row. Tab 3 is shown here:tab3.jpg.

    I hope this makes sense.

    Any help at all on this would be appreciated.

    Thanks in advance,

    Emma x

  2. #2
    Registered User
    Join Date
    07-14-2006
    Posts
    49

    Re: Copy Information into a template

    Hi,

    Does anyone have any ideas on this please?

    Thanks

  3. #3
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,147

    Re: Copy Information into a template

    Why attach a jpg when an excel sample file is much easier?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  4. #4
    Registered User
    Join Date
    07-14-2006
    Posts
    49

    Re: Copy Information into a template

    I want to be able to learn the answer and apply it myself, rather than someone doing it for me. It also has lots of other data on that is not fit to be shared.

    Im guessing no-one has any ideas?

  5. #5
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,147

    Re: Copy Information into a template

    Why not attach a sample file ? We will waste a lot of time in replicating your jpgs into an excel file.

  6. #6
    Registered User
    Join Date
    07-14-2006
    Posts
    49

    Re: Copy Information into a template

    Never mind, I will try and get an answer from somewhere else.

+ 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