+ Reply to Thread
Results 1 to 7 of 7

Get repetitive text and sum in another sheet based on condition

  1. 11-06-2019, 03:33 PM #1
    cd2000
    cd2000 is offline
    Registered User
    Join Date
    11-05-2019
    Location
    Shikaka
    MS-Off Ver
    2007,2010
    Posts
    4

    Post Get repetitive text and sum in another sheet based on condition

    Hello , I am Dan, I am a student at works man craft, and I don't have enough money to sustain myself , so I got a job, low payment, but recently one of the staff got fired so I got an opportunity. But its in a field that I lack many ...for now .
    So if anyone would be kind enough to help on my new post that need some advanced excel skills and not only , I would really appreciate it.
    And my problem is as follows :
    I have to keep track of same "fac" that in the same manifest has many fields with diff values and quantities. I have to sum the same "fac/date" from sheet1 in sheet(fac.O.P.)AUTOMATED like you can see In example : 2548/10.09 gets summed in fac.O.P. in row number 1 with value 2558.38 under column B(Nr fac) , C(Val to fac) , E(Val fac C.D S.P.), I(Prg 15/30.01.02/10.01.09) and so on to fill the columns specified in the table...and if I fill clumn P(o.p./date) the row would go to corresponding sheet prg in that table format.
    I tried to do something ...but it is not as near or complete is just a test ...and I can't work it out.
    I would really appreciate the effort, thank you.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-08-2019, 01:23 PM #2
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,535

    Re: Get repetitive text and sum in another sheet based on condition

    Hello cd2000 and Welcome to Excel Forum.
    With only two cells (I5 and I11) against which to test, it is hard to know if this will work for the values listed in J5:O11.
    That said try pasting the following into cell I5 and copying down to I11:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    If the formula works for the other cells then we can look at filling values into the "Prg 15-30.01.02-10.01.09" sheet.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
  3. 11-13-2019, 11:21 AM #3
    cd2000
    cd2000 is offline
    Registered User
    Join Date
    11-05-2019
    Location
    Shikaka
    MS-Off Ver
    2007,2010
    Posts
    4

    Re: Get repetitive text and sum in another sheet based on condition

    Hello JeteMc , thank you for the formula , I really appreciate your work, but this is good for only half of my problems
    I need a VBA code that sums and copy all unique ID from sheet1 to sheet2(FacOP) and arrange them corresponding to columns in that sheet.



    P.S. : I've also learned from your formula , now I know how it works and I can make it better, thank you very much
    Last edited by cd2000; 11-13-2019 at 11:24 AM.
    Reply With QuoteRegister To Reply
  4. 11-13-2019, 11:29 AM #4
    cd2000
    cd2000 is offline
    Registered User
    Join Date
    11-05-2019
    Location
    Shikaka
    MS-Off Ver
    2007,2010
    Posts
    4

    Re: Get repetitive text and sum in another sheet based on condition

    Can you take a look at the Green button from sheet2 named 15/30.01.02/10.01.09?
    How to rearrange output of my copied data ....based on columns in sheet2?
    Reply With QuoteRegister To Reply
  5. 11-13-2019, 12:13 PM #5
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,535

    Re: Get repetitive text and sum in another sheet based on condition

    Responding to post #3, what would be considered as an "unique ID" on sheet 1?
    Responding to post #4:
    I don't know VBA, however if I understand what you are asking then try pasting the following into cell I6 on the "Prg 15-30.01.02-10.01.09" sheet and drag the fill handle down:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Paste the following into cell B6 and copy down to B14 and then, while B6:B14 are still selected copy over to H14:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 11-14-2019, 02:16 AM #6
    cd2000
    cd2000 is offline
    Registered User
    Join Date
    11-05-2019
    Location
    Shikaka
    MS-Off Ver
    2007,2010
    Posts
    4

    Re: Get repetitive text and sum in another sheet based on condition

    Unique id in Sheet1 is column T
    Reply With QuoteRegister To Reply
  7. 11-14-2019, 09:04 AM #7
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,535

    Re: Get repetitive text and sum in another sheet based on condition

    I believe that the formula for columns I:L (Fac. OP. sheet) should read:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Note that in order for the formula to work, cells I3 and K3 need to be unmerged and the dates in I3 and K3 need to be copied to J3 and L3 respectively.
    Unfortunately there is no data in columns N, T, U, Q, or D on sheet 1 with which to test in columns J:L
    I suggest uploading another file with the missing data that was used to calculate J7, K8, K11, L6 and L11.
    Let us know if you have any questions.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formul for most repetitive text from cells that satisfies condition
    By DarkLord76865 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-11-2018, 10:30 AM
  2. Copying rows from sheet 1 to sheet 3, based on if condition.
    By Mooohan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2015, 11:57 AM
  3. Deleting rows on one sheet based on a condition in another sheet in the same file
    By Steve2107 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-18-2014, 06:48 AM
  4. [SOLVED] [Urgent] Inserting Time sheet Data in to Master sheet Based On the Condition Using Macros.
    By kkcmania in forum Excel Programming / VBA / Macros
    Replies: 42
    Last Post: 05-17-2013, 07:56 AM
  5. Need autorun Macro that copies data from Master sheet to second sheet based on condition
    By angie18a in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-01-2013, 12:26 PM
  6. Macro to removed entire row on Sheet A if a text matches a condition on Sheet B
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-03-2012, 04:22 PM
  7. repetitive text imports
    By Knox in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2006, 04:45 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1