1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Google Docs Spreadsheet

Discussion in 'Web & Email' started by JPLamb, Apr 26, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. JPLamb

    JPLamb Thread Starter

    Joined:
    Jan 27, 2005
    Messages:
    577
    Hi all.

    Not sure if this is yet possible in Google Docs.

    I have a Spreadsheet with a few sheets in it. I am wanting to pull some data from 1 sheet onto another automatically. for example on my fist sheet i have a list of dates in one coloumb and a list of prices in the one next to it. They are used on that sheet for a calculation but i am wanting to pull them automatically on to my second sheet to show a differenc calculation.

    Is this possable? I know how to do it on Excel but not Google.

    Thanks
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,422
    First Name:
    Wayne
    how are you doing it in excel, not sure i fully understand what you want to copy across - an example spreadsheet with dummy data would help
     
  3. JPLamb

    JPLamb Thread Starter

    Joined:
    Jan 27, 2005
    Messages:
    577
    I have attached a document with dates and prices on sheet 1 and then sheet 2 pulls the dates and prices from sheet 1.

    Hope the attached makes things clearer

    Cheers
     

    Attached Files:

  4. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,422
    First Name:
    Wayne
    sheet 2 just uses an =sheet1!cell
    google docs will do that - just use the same formula
    or is there a macro that does that for you - a little confused still - sorry - on what you do
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/919285

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice