+ Reply to Thread
Results 1 to 4 of 4

Copy info from one sheet to anothe automatically

  1. #1
    Registered User
    Join Date
    02-22-2015
    Location
    Detroit, MI
    MS-Off Ver
    Office Mac 2011
    Posts
    2

    Copy info from one sheet to anothe automatically

    I have a workbook with several sheets attached to it.
    All my sheets perform as I want except 1.

    I have a data sheet that has several data entry fields with different dates and amount of players.
    i need to get this info into a 2nd sheet without doing a copy and paste.

    I need to transfer the Week, Players, P, HH, and F/F fields into sheet 4:

    Week March 13, 2015
    # Players 21
    Name January 29, 2016
    13
    Pld P HH F/F
    x
    x 4 $25
    x 2 $15
    x 3 $20
    x 5 $40


    x 7 $90


    x $16
    x
    x 6 $50 $26




    x
    x 1
    x
    x

    My problem is that WEEK and PLAYERS change week to week. I'm tired of "Copy and Paste". I need the first sheet for other calculations.

    Can anyone suggest a way to do this?

    Thanks in advance.

  2. #2
    Forum Contributor codeslizer's Avatar
    Join Date
    05-28-2013
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2003 - 2010
    Posts
    245

    Re: Copy info from one sheet to anothe automatically

    It would easier for us to understand and offer a solution/suggestion, if you could "Go Advanced" and upload a sample worksheet.
    cOdEsLiZeR - Back after a long break.. Let's sLiZe some more cOdEs!!

  3. #3
    Registered User
    Join Date
    02-22-2015
    Location
    Detroit, MI
    MS-Off Ver
    Office Mac 2011
    Posts
    2

    Re: Copy info from one sheet to anothe automatically

    I can't send through here.
    I will send via private email and have phone call to explain how it all works.

    It's too complicated to just upload and have you try to find your way around.

    Gordon
    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: Copy info from one sheet to anothe automatically

    Welcome to ExcelForum.

    Perhaps you should consider posing this problem in the Commercial Services area where you can communicate privately with the person trying to solve your problem.

    The General area is open to all members and the problems posed should be posed in such a manner that the problem is understood by all who are interested in solving it.

    Consider the spirit of the last part of Rule #4: Don't Private Message or email Excel questions to moderators or other members. (or Word, Access, etc.) The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.

    There are many intricate problems posed here and their solutions are available to all members to see and to learn from. That would necessitate knowing the intricacies of the problem as well as you can describe them.
    <---------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

+ 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. [SOLVED] Copy info from one sheet to another so it organizes automatically!
    By ropciks113 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-05-2013, 01:58 AM
  2. Automatically copying info from one sheet to another
    By alexBLAYZA in forum Excel General
    Replies: 1
    Last Post: 02-28-2013, 09:20 PM
  3. [SOLVED] Macro That Automatically Copies Row from Sheet 1 into Sheet 2 Based on Info in that Row
    By smartmika in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-27-2012, 10:52 AM
  4. Replies: 14
    Last Post: 01-29-2008, 04:47 PM
  5. Is there any way to make buttons copy from one worksheet to anothe
    By Emtsuj in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-01-2005, 05:45 PM
  6. [SOLVED] I need to copy table from one sheet to anothe
    By Maya in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-03-2005, 03:06 PM
  7. How do I tell Excel to take a selected item and copy it to anothe.
    By HEATHERCOX in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-28-2005, 12:06 PM
  8. How do I copy page set up attributes from one worksheet to anothe.
    By KathieMacFarlane in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-26-2005, 07:06 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