+ Reply to Thread
Results 1 to 7 of 7

Updating data from one worksheet to another when adding a new column with data

  1. #1
    Registered User
    Join Date
    01-20-2014
    Location
    Norway
    MS-Off Ver
    2013
    Posts
    7

    Updating data from one worksheet to another when adding a new column with data

    Hi!

    I'm very new to Excel, so please excuse any mistakes or if I should explain my problem more thoroughly.

    A panel of 10 workers
    So, I have an Excel document with one worksheet for every person that's a part of a small panel of 10 that I'm working with, and one worksheet with all of them in (main) in a row. Every time this panel does a survey, we add another column of data in the main worksheet with their results of how they did on the survey and the date on top.
    This data also has to be inserted into the worksheet for every person on the panel seperately, which is a bit of a pain. What I'd like to do is to be able to insert the data in the main worksheet and have the rest of them update automatically. Each worksheet for each person on the panel also has a graph on it, which needs to display the data I added in the main worksheet (the graph shows the last 10 surveys or something like that).

    I hope I'm being clear enough.
    Cheers.

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Updating data from one worksheet to another when adding a new column with data

    Can you create a mock-up of what you are planning and upload it?

    Your description makes me think that there must be a better way of doing things. Do you really need 10 graphs if they are all the same? Why not one graph that everyone can access? Why does each person need a separate worksheet? These are just some of the questions that come to mind.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    01-20-2014
    Location
    Norway
    MS-Off Ver
    2013
    Posts
    7

    Re: Updating data from one worksheet to another when adding a new column with data

    Quote Originally Posted by newdoverman View Post
    Can you create a mock-up of what you are planning and upload it?
    Sure thing. See attachement.

    Quote Originally Posted by newdoverman
    Your description makes me think that there must be a better way of doing things. Do you really need 10 graphs if they are all the same? Why not one graph that everyone can access? Why does each person need a separate worksheet? These are just some of the questions that come to mind.
    The graph on each worksheet for each person on the panel only shows the survey results for that person. It's so we can show them their results without showing them all the others.
    Attached Files Attached Files

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Updating data from one worksheet to another when adding a new column with data

    I didn't do anything drastic. I transposed your data from horizontal to vertical for the dates and assigned a column for each judge.

    The data on each judge's sheet is linked to the main sheet (I just left it as sheet1 you can rename it) and the link is carried down to row 100 and this can be extended as required.

    The charts are linked directly to the main sheet (sheet1) and are updated as data is entered into the table on Sheet1.

    The data on the main sheet is in a table so that all formulae will be automatically entered for you as you enter new rows of data. This also allows you to filter the data by each of the columns to get various views of your data as a whole. As a table, it is also very easy to produce a Pivot table that is easily updated if required.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-20-2014
    Location
    Norway
    MS-Off Ver
    2013
    Posts
    7

    Re: Updating data from one worksheet to another when adding a new column with data

    This looks super good! Awesome! Will look at it when I get to work tomorrow. Thanks!

  6. #6
    Registered User
    Join Date
    01-20-2014
    Location
    Norway
    MS-Off Ver
    2013
    Posts
    7

    Re: Updating data from one worksheet to another when adding a new column with data

    Again; thanks. This sorted us out right!

    Cheers!

  7. #7
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Updating data from one worksheet to another when adding a new column with data

    Thanks for the feedback.

    Good luck with your project.

+ 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. adding data to a new column each day that the worksheet is used
    By dkrzysik in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-16-2013, 07:44 AM
  2. Replies: 0
    Last Post: 03-03-2012, 03:29 AM
  3. Updating Old Data and Adding New Data to a Sheet
    By lkpetty in forum Excel General
    Replies: 2
    Last Post: 12-03-2009, 04:00 PM
  4. Replies: 0
    Last Post: 12-05-2008, 01:32 PM
  5. Updating one worksheet with data from another
    By gbierl in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-22-2007, 05:41 PM

Tags for this Thread

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