+ Reply to Thread
Results 1 to 8 of 8

How can I copy more cells from different worksheets into one that updates automatically?

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    Copenhagen
    MS-Off Ver
    Excel 2007
    Posts
    4

    How can I copy more cells from different worksheets into one that updates automatically?

    Hi..
    I’m new to anything ells than basic excel, and don’t know how to program in excel.

    I have the same type of data from different persons with different values (See attached file, the worksheets are called: Anne, Tine and Per).

    I want to copy the results from: Projects/Activity, Type of project, Total [min], Person and Week for the different persons into a new worksheet (gathered data), and it should be able to update automatically if I make changes in any of the worksheets (called Anne, Tine and Per).

    In the end I would like to make a pivot, So I am able to see how many minutes there is used on each type of projects or project/activity, where I can select a specific week and person (As shown on the worksheet called type of project (only with the data from Anne).

    But the main question is how can I copy more cells from different worksheets into one worksheet that updates automatically?

    I really hope some one know the answer and can help me

    Kind regards
    Marie
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    365
    Posts
    495

    Re: How can I copy more cells from different worksheets into one that updates automaticall

    This is like the basic code that you need:

    Please Login or Register  to view this content.
    If you understand the lines and know what they do, you can adjust it for your specific case. Is this enough or do you need more details?
    When I say semicolon, u say comma!

  3. #3
    Registered User
    Join Date
    07-29-2013
    Location
    Copenhagen
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: How can I copy more cells from different worksheets into one that updates automaticall

    Thank you very much for your answer, but I don´t quite get what to change. Right now I'm using the code below, but what do I have to change to make it update automatically (I have never coded in Excel before):

    Sub Combine()
    Dim J As Integer
    On Error Resume Next
    Sheets(1).Select
    Worksheets.Add
    Sheets(1).Name = "Combined"
    Sheets(2).Activate
    Range("A1").EntireRow.Select
    Selection.Copy Destination:=Sheets(1).Range("A1")
    For J = 2 To Sheets.Count
    Sheets(J).Activate
    Range("A1").Select
    Selection.CurrentRegion.Select
    Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select
    Selection.Copy Destination:=Sheets(1).Range("A65536").End(xlUp)(2)
    Next
    End Sub


    /Marie

  4. #4
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    365
    Posts
    495

    Re: How can I copy more cells from different worksheets into one that updates automaticall

    Lol if you understand that code then you know more than I do
    Sorry I can't help you any further.

  5. #5
    Registered User
    Join Date
    07-29-2013
    Location
    Copenhagen
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: How can I copy more cells from different worksheets into one that updates automaticall

    No no, I don't understand that coding, I have just found it somewhere and it partly works (does not update automatically). But thank you very much for answering.
    /Marie

  6. #6
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    365
    Posts
    495

    Re: How can I copy more cells from different worksheets into one that updates automaticall

    I just saw that I misunderstood your problem; I thought you wanted to copy data to another file, but it's just another sheet in the same file. This may be possible even without macros. Can you edit your file so that it shows how the desired data in the Gathered Data sheet look like and where the data come from?

  7. #7
    Registered User
    Join Date
    07-29-2013
    Location
    Copenhagen
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: How can I copy more cells from different worksheets into one that updates automaticall

    You were right, it is possible without a Macro. I just found out that it is as simple as just linking the different worksheets.
    Thanks.
    /Marie

  8. #8
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    365
    Posts
    495

    Re: How can I copy more cells from different worksheets into one that updates automaticall

    Haha you're welcome for the inspiration

    Please mark the thread as solved

+ 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: 2
    Last Post: 06-03-2013, 09:30 AM
  2. Replies: 4
    Last Post: 06-02-2013, 08:21 PM
  3. Replies: 1
    Last Post: 10-30-2009, 10:31 AM
  4. Automatically copy cells across Worksheets
    By Rattly Noise in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-22-2007, 10:42 AM
  5. Replies: 2
    Last Post: 12-28-2005, 04:45 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