+ Reply to Thread
Results 1 to 13 of 13

Transfer selective cells value in a flagged row to new sheet Respectively

  1. #1
    Registered User
    Join Date
    03-24-2020
    Location
    Doha, Qatar
    MS-Off Ver
    2007
    Posts
    7

    Transfer selective cells value in a flagged row to new sheet Respectively

    Hi
    am facing an issue which need an expert to solve, I have this workbook which contains two sheets (Registration & Refunds)
    now in sheet 1 (Registration) I keep register each new card dispute I received & there is a flag column.

    If the flag column has the value "R" then I want selective cells in same row to be transferred to sheet 2 (Refunds)

    The real challenge is, Registration sheet will keep increase in the rows so if for example row number 2 and row number 7 are flagged with "R" the challenge is to make them appear in Refunds sheet in sequent rows 1 & 2 without empty rows in between. (Below each other)

    Sheet 1 (Registration):
    if column K has the value "R" then transfer the value in cells (Account, Amount, description 1 & 2) to sheet 2 (Refunds)

    Sheet 1.jpg

    Sheet 2 (Refunds):
    The requested cells are transferred but in same row number of sheet 1, the challenge is instead of the values be in row 11 in Refunds sheet to be in row 3 direct under the first row

    sheet 2.jpg

    and her I attache a sample excel with comments inside
    Attached Files Attached Files

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Transfer selective cells value in a flagged row to new sheet Respectively

    One way...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,095

    Re: Transfer selective cells value in a flagged row to new sheet Respectively

    Hello Sebastine,

    Another way is to simply use the AutoFilter:-

    Please Login or Register  to view this content.
    I hope that this helps.

    Cheerio,
    vcoolio

  4. #4
    Registered User
    Join Date
    03-24-2020
    Location
    Doha, Qatar
    MS-Off Ver
    2007
    Posts
    7

    Re: Transfer selective cells value in a flagged row to new sheet Respectively

    Thank you SinTek,

    it works as a charm, but one issue appeared, lets say that I flagged 3 rows in sheet1 with R they all shown in sheet2 respectively in charming way, BUT once i remove the flag "R" in sheet1 what is happening in sheet2 is that only first row will be removed not the other two!

    do you have solution for that?

  5. #5
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Transfer selective cells value in a flagged row to new sheet Respectively

    vcoolio's code works well...
    Are you wanting to overwrite the entries in sheet2 only to show R rows...

  6. #6
    Registered User
    Join Date
    03-24-2020
    Location
    Doha, Qatar
    MS-Off Ver
    2007
    Posts
    7

    Re: Transfer selective cells value in a flagged row to new sheet Respectively

    Thanks Vcoolio

    it works as a charm too, but one issue appeared, lets say that I flagged 3 rows in sheet1 with R they all shown in sheet2 respectively in charming way, BUT once i remove the flag "R" in sheet1 what is happening in sheet2 is that non of them is removed and need to manually remove the cells

    do you have solution for that?

  7. #7
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Transfer selective cells value in a flagged row to new sheet Respectively

    Please Login or Register  to view this content.

  8. #8
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Transfer selective cells value in a flagged row to new sheet Respectively

    Do you mean that once the "R" is removed on Sheet1 the already transferred corresponding entry on sheet2 should be deleted??

  9. #9
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,095

    Re: Transfer selective cells value in a flagged row to new sheet Respectively

    Hello Sebastine,

    Ditto to what Nigelog asked.

    .........or is Sintek's suggestion in post #7 what you require?

    Cheerio,
    vcoolio.

  10. #10
    Registered User
    Join Date
    03-24-2020
    Location
    Doha, Qatar
    MS-Off Ver
    2007
    Posts
    7

    Re: Transfer selective cells value in a flagged row to new sheet Respectively

    Yes Exactly... if the R Flag is removed then sheet2 be empty

  11. #11
    Registered User
    Join Date
    03-24-2020
    Location
    Doha, Qatar
    MS-Off Ver
    2007
    Posts
    7

    Re: Transfer selective cells value in a flagged row to new sheet Respectively

    Yes exactlly, once the R flag removed in sheet 1 then sheet 2 be empty

  12. #12
    Registered User
    Join Date
    03-24-2020
    Location
    Doha, Qatar
    MS-Off Ver
    2007
    Posts
    7

    Re: Transfer selective cells value in a flagged row to new sheet Respectively

    Amazing, now it works fine... all in rows in sheet2 are removed once R flag is removed in sheet1


    Thank you

  13. #13
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Transfer selective cells value in a flagged row to new sheet Respectively

    Glad we could help...tx for rep +
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Last edited by sintek; 03-26-2020 at 04:39 AM.

+ 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. Transfer selective cells value in a flagged row to new sheet
    By Sebastine8287 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-24-2020, 03:10 AM
  2. [SOLVED] Macro to Transfer Selective Data
    By chrixton in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-19-2014, 07:00 PM
  3. Replies: 1
    Last Post: 02-13-2013, 01:32 PM
  4. Replies: 5
    Last Post: 12-11-2012, 05:04 AM
  5. adding flagged cells
    By nynative in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-28-2012, 04:47 PM
  6. Selective data transfer
    By BBoyAl in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-08-2012, 05:32 PM
  7. Selective data transfer to other columns
    By Tom Cular in forum Excel General
    Replies: 4
    Last Post: 03-09-2006, 08:35 AM

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