+ Reply to Thread
Results 1 to 7 of 7

Fill in page from another page in workbook

  1. #1
    Registered User
    Join Date
    12-26-2013
    Location
    Minnestoa
    MS-Off Ver
    Excel 2003
    Posts
    5

    Fill in page from another page in workbook

    OK, NEW TO EXCEL, old to programing, but most of my knowledge is pre 2000

    What I want to do, is to populate the Lois,Beth,Kelly, and Shelley pages with the rows from the Que page when they get assigned to one of them. I tryed to program then off of a different example in the forum. It didn't work. Will include the copy. Please include an explaination of what you did. I want to learn how to do it and what I did wrong the first time. Tracking(HELP).xlsx

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,138

    Re: Fill in page from another page in workbook

    Welcome to the board!

    See if this will get you going.

    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    12-26-2013
    Location
    Minnestoa
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Fill in page from another page in workbook

    I don't mean to sound like a newbie but the progaming is great. I understand most of it, but...... can I get a link to something thing to help me understand what I don't and how to get it runing. I know to go into excel visual basic window. There is now place for me to enter the code when I get there. Learning as I go here.

  4. #4
    Registered User
    Join Date
    12-26-2013
    Location
    Minnestoa
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Fill in page from another page in workbook

    I am happy to say that I got it to work, Now I just need it to delete the row that it pulled it from. I am going to look to see if that is in here somewhere. Thank you for the help.

  5. #5
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,138

    Re: Fill in page from another page in workbook

    Glad you got it working.

    In the future, please ask specific questions. The "can I get a link to something thing to help me understand what I don't and how to get it running." doesn't help me help you.

  6. #6
    Registered User
    Join Date
    12-26-2013
    Location
    Minnestoa
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Fill in page from another page in workbook

    Ok, good point. I had shared my workbook with someone real quick and then tried to work on the coding again, and I couldn't get to it until I un-shared the workbook. I didn't know what was going on so I didn't even know what to ask. I wasn't able to figure out how to get it to delete the lines that were cut from. I tried one version, and adapting to your coding. I think I put it in before the cut and paste because it cut the lines out but never pasted anything in yours. I am also looking for a beginners guide because the more stuff I get this workbook to do the more they want me to do with it. The forums are good but I am missing the base needed. (Apparently I am in the wasteland of computer knowledge.)

  7. #7
    Registered User
    Join Date
    12-26-2013
    Location
    Minnestoa
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Fill in page from another page in workbook

    And going one step further, (not sure I am ready for it) but instead of just coping the data over can a person just link the lines? So a change in one will show up on other page? Don't know if it is even possible, but a person can hope?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 11-17-2013, 01:40 PM
  2. Help with adding rows to fill a page.
    By synapsis in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 06-18-2012, 12:05 PM
  3. Using a reference from another page to fill a worksheet
    By Fuddy Duddy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-21-2008, 04:12 AM
  4. How can I force my data to fill the page?
    By edt in forum Excel General
    Replies: 2
    Last Post: 07-28-2006, 11:20 AM
  5. [SOLVED] Resize Last Row to Fill a Page Width
    By Sloth in forum Excel General
    Replies: 0
    Last Post: 02-17-2006, 06:30 PM

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