Results 1 to 5 of 5

Thread: New Guy Questions
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2003
    Posts
    30
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default New Guy Questions

    Hello,

    Hello,

    -I have been looking deep into the bowels of the Internet searching for help with my excel project. I have been working on this for the majority of the day and have been determined to make this work.

    -I want to make a simple spreadsheet to update stock quotes. Basically three columns symbol, name, and current price. I have about 600 stocks that I want to watch. After several frustrating hours, I have been able to make 3 worksheets that will update using the already install WebQuery. I don’t like the format. I simply want to take the little information that I want and put it into a clean format on another page. How do I copy this information from the three worksheets (had to make three because it would only accept 200 quotes at a time) and put it on one clean worksheet? I am new to using excel and anything but its most basic capacity so any info will help.

    -Also, is there a better way to use WebQuery to just pick out the info I want? Am I going about this the right way?

    I really appreciate the help…….I am close to slamming my head into the monitor…

    THANKS….

  2. #2
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: New Guy Questions

    Hi Jar2112:

    Welcome to MrExcel Board!

    Let us look at the part where you want to copy the information from three worksheets into one worksheet. Unless I am missing something here, it should be a simple copying and pasting task.

    From what you have stated, there is info for upto 200 stocks on each sheet, and you would like to have info for say all 600 stocks in one sheet.
    Let us make a fourth sheet, so now we have sheet1, shee2, sheet3, and sheet4.

    Now copy the info from sheet1 and paste it into sheet4, say cell A1. Then copy the info from sheet2, and paste it at the next row after the last row of sheet4, and do the same by copying sheet3 and pasting it.

    Now , we have 4 sheets. Sheet1, sheet2, and sheet3 are your originals, and sheet4 is your consolidated working copy.

    I hope this helps.
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  3. #3
    New Member
    Join Date
    Dec 2003
    Posts
    30
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: New Guy Questions

    Hey,

    Thanks for the welcome. Actually, what I was trying to attempt is when I update the prices in the other 3 sheets, it automaticly updates the forth sheet. Is there a way to do that?

    Thanks...

  4. #4
    Board Regular
    Join Date
    Dec 2002
    Posts
    346
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: New Guy Questions

    Quote Originally Posted by Jar2112
    Hey,

    Thanks for the welcome. Actually, what I was trying to attempt is when I update the prices in the other 3 sheets, it automaticly updates the forth sheet. Is there a way to do that?

    Thanks...
    Try this:

    On sheet 4;
    select the cell where you want to start your data;
    now select sheet 1;
    select the 1st cell you want to show up on sheet 4;
    hit enter;

    on sheet 4 you now have the 1st cell contents from sheet 1;
    select this cell; left click on the handle and drag down till you have all the of contents from the 1st col of sheet 1
    repeat for the other 2 cols

    repeat for sht 2and sht3

    I'm sure there are better ways to do this but this will get the job done

  5. #5
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: New Guy Questions

    Quote Originally Posted by Jar2112
    Hey,

    Thanks for the welcome. Actually, what I was trying to attempt is when I update the prices in the other 3 sheets, it automaticly updates the forth sheet. Is there a way to do that?

    Thanks...
    Yes! -- link the cells in the fourth sheet to the respective cells in the three sheets.
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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