+ Reply to Thread
Results 1 to 7 of 7

Cut A Row Paste It On First Empty Row In Another Sheet Based on Condition DropDown

Hybrid View

Bookstr Cut A Row Paste It On First... 08-23-2013, 12:25 PM
Bookstr Re: Cut A Row Paste It On... 08-23-2013, 05:50 PM
jaslake Re: Cut A Row Paste It On... 08-23-2013, 06:03 PM
Bookstr Re: Cut A Row Paste It On... 08-23-2013, 06:24 PM
jaslake Re: Cut A Row Paste It On... 08-23-2013, 06:31 PM
Bookstr Re: Cut A Row Paste It On... 08-23-2013, 06:37 PM
jaslake Re: Cut A Row Paste It On... 08-23-2013, 11:08 PM
  1. 08-23-2013, 06:24 PM #1
    Bookstr is offline
    Registered User
    Join Date
    08-22-2013
    Location
    United states of america
    MS-Off Ver
    2013
    Posts
    4

    Re: Cut A Row Paste It On First Empty Row In Another Sheet Based on Condition DropDown

    Thank you John worked like a charm. Is there a way to hide it?
    Reply With QuoteRegister To Reply
  2. 08-23-2013, 06:31 PM #2
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Cut A Row Paste It On First Empty Row In Another Sheet Based on Condition DropDown

    Hi Bookstr

    Regarding this
    Is there a way to hide it?
    Yes...you could take a couple of approaches:
    • You could hide the entire Column
    • You could change the Font of that Column to White such that the Column will still be visible but the Text will be White and appear to be unseen.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
  3. 08-23-2013, 06:37 PM #3
    Bookstr is offline
    Registered User
    Join Date
    08-22-2013
    Location
    United states of america
    MS-Off Ver
    2013
    Posts
    4

    Re: Cut A Row Paste It On First Empty Row In Another Sheet Based on Condition DropDown

    Thank you again. This is now Solved!
    Reply With QuoteRegister To Reply
  4. 08-23-2013, 11:08 PM #4
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Cut A Row Paste It On First Empty Row In Another Sheet Based on Condition DropDown

    You're welcome...glad I could help.
    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. Counting the number of empty cells based on a condition in a range
    By naga in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-01-2013, 10:01 AM
  2. [SOLVED] Macro to cut row and paste into secondary worksheet based on dropdown value
    By sol2010 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-17-2013, 05:32 PM
  3. Pop Up Message when Certain Cells are empty based on condition of previous adjacent cell
    By marduk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-19-2012, 10:16 AM
  4. insering empty row based on a condition
    By darkhorse4321 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2010, 02:16 AM
  5. Copy/Paste from one sheet to another based on condition
    By TheTempest in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-16-2010, 01:13 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1