+ Reply to Thread
Results 1 to 7 of 7

Move Rows from Main Worksheet to Secondary Sheet Based on Value of a Cell

  1. 04-20-2017, 04:08 AM #1
    lexikate78
    lexikate78 is offline
    Registered User
    Join Date
    04-20-2017
    Location
    Sunshine Coast, Australia
    MS-Off Ver
    2016
    Posts
    3

    Lightbulb Move Rows from Main Worksheet to Secondary Sheet Based on Value of a Cell

    Hello! New to the forum and was close to throwing my lappy out the window - mainly due to my lack of expertise with VBA and knowing that I'm on a deadline to get this right - any help would be greatly appreciated. I have looked up all of the other 'answers' on the web to this question and they still don't work for me...

    So I have sheet1 called 'Todays Tasks' - 8 columns
    I have sheet2 called 'General To Do' - 8 columns (all headers the same as sheet 1)

    The 8th column being "H" is called Priority (if this makes a difference)
    In sheet 2 "General To Do" - whenever I prioritise a task as "A" in column 8/H (meaning urgent) I need the whole row to move to sheet1 "Todays Tasks" in list form

    Does anyone have any thoughts?

    THANKS!!!!
    Reply With QuoteRegister To Reply
  2. 04-20-2017, 04:15 AM #2
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Move Rows from Main Worksheet to Secondary Sheet Based on Value of a Cell

    i dont see sheet 1 or sheet 2


    Kind regards
    Leo
    Reply With QuoteRegister To Reply
  3. 04-20-2017, 04:22 AM #3
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,417

    Re: Move Rows from Main Worksheet to Secondary Sheet Based on Value of a Cell

    You could use AutoFilter, filter on column H for "A" and copy the visible cells to the next available row on the To Do List.

    Record a macro while you do it. It will probably need tweaking to make it generic and more efficient.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  4. 04-20-2017, 06:05 AM #4
    lexikate78
    lexikate78 is offline
    Registered User
    Join Date
    04-20-2017
    Location
    Sunshine Coast, Australia
    MS-Off Ver
    2016
    Posts
    3

    Re: Move Rows from Main Worksheet to Secondary Sheet Based on Value of a Cell

    Can you see the attachment?

    I really need an automatic VB if possible..
    Attached Files Attached Files
    Last edited by lexikate78; 04-20-2017 at 08:28 AM.
    Reply With QuoteRegister To Reply
  5. 04-20-2017, 04:46 PM #5
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Move Rows from Main Worksheet to Secondary Sheet Based on Value of a Cell

    Maybe

    Please Login or Register  to view this content.
    by change the value for column H to A, this row moves to Todays tasks

    Kind regards
    Leo
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 04-23-2017, 05:25 AM #6
    lexikate78
    lexikate78 is offline
    Registered User
    Join Date
    04-20-2017
    Location
    Sunshine Coast, Australia
    MS-Off Ver
    2016
    Posts
    3

    Re: Move Rows from Main Worksheet to Secondary Sheet Based on Value of a Cell

    Ive attached the error message
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 04-23-2017, 05:38 AM #7
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Move Rows from Main Worksheet to Secondary Sheet Based on Value of a Cell

    in wich file you have this error ?
    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. [SOLVED] Auto populate main worksheet info to appropriate secondary tabs based on info in column D
    By jingles9 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-02-2013, 03:00 PM
  2. VBA CODE to move rows from one sheet(1) to another sheet(2) based on data in cell
    By fozzieulo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2013, 02:43 PM
  3. Automatically move rows to another worksheet based on cell value
    By Jon Edwards in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-11-2013, 12:51 PM
  4. I need to move data from main worksheet into multiple worksheets based on a criteria
    By ksenia81 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2012, 05:45 PM
  5. [SOLVED] Macro to get/copy data from multiple secondary sheets to main sheet
    By CaatalyyN616 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-29-2012, 04:22 AM
  6. Macro to move rows from one sheet to another sheet based on a cell vaule
    By d55272 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-09-2012, 03:33 PM
  7. [SOLVED] Copy rows from my main worksheet to another worksheet based on data in one cell
    By gcol in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-08-2012, 05:12 AM
  8. VBA to move rows to end of sheet based on cell contents
    By lday75 in forum Excel General
    Replies: 1
    Last Post: 08-06-2012, 10:49 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1