+ Reply to Thread
Results 1 to 4 of 4

Copy based on cell description from one sheet to another

  1. #1
    Registered User
    Join Date
    07-29-2016
    Location
    Iowa
    MS-Off Ver
    2010
    Posts
    3

    Copy based on cell description from one sheet to another

    HiProject.xlsx

    I've been trying to solve this one for a while without any luck.

    File has different sheets renamed with date range by week ( this cells are manually copy & paste), one that's call year to date ( this sheets is the one that needs to formula to be able to search all the other sheets based on the ID#, when found copy cell on B1 column and B2, since this two numbers belong to A1 / ID#.

    A B
    ID %-CPH
    AA8 73.5
    AA8 275.6

    Some ID#'s only have % and some both.

    A B
    C99 75.20
    Z95 80.50
    Z95 310.0

    When the numbers get copy and paste are all random and not always end up in the same cell for the weekly ones, the YTD will always stay in the same cell.

    I'm not even sure if this can be possible. Thanks in advance for your help

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Copy based on cell description from one sheet to another

    I am totally confused by your explanation.

    is this what you want?

    Lookup B64 (YTD A3) on every sheet and return the sum of the values found in column ELS in YTD B3, and CPH in YTD C3??

    If not, please expalin again.

    ALSO: How many sheets (excluding YTD) are in your real sheet?
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    07-29-2016
    Location
    Iowa
    MS-Off Ver
    2010
    Posts
    3

    Re: Copy based on cell description from one sheet to another

    yes look up B64 from all 5 weeks and return and average of the values from B1 and B2 if any. I just started the file, it starts on 9-5 and will continue week by week. currently I only have 5. If you look at my file on the YTD sheet I have where the values need to be from the search.

  4. #4
    Registered User
    Join Date
    07-29-2016
    Location
    Iowa
    MS-Off Ver
    2010
    Posts
    3

    Re: Copy based on cell description from one sheet to another

    Thank you for taking the time on my problem.

+ 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 paste data one to multiple sheet based on cell value to sheet name
    By kannan1847 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2015, 12:54 AM
  2. Search for a sheet based on a cell copy to that sheet first empyt cell
    By WimpieOosthuizen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-28-2014, 01:47 AM
  3. Copy Name with description in a cell as many times descriptions come in a range
    By brajpalshishodia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2012, 12:31 PM
  4. [SOLVED] Macro to Copy Data from one Sheet A to Sheet B based on value in cell on sheet A
    By scass in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2012, 07:21 PM
  5. copy description from sheet 1 to sheet 2
    By MeloReese in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2012, 01:53 PM
  6. [SOLVED] Macro: Dynamic creation of sheet based on cell value then copy range to the new sheet
    By BeachRock in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-15-2012, 11:31 AM
  7. Copy Rows from selected Sheet to New Sheet based on Cell Value
    By joemcmillen in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 04-03-2008, 03:44 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