Results 1 to 4 of 4

VBA to move rows to new sheet

Threaded View

  1. #1
    Registered User
    Join Date
    04-27-2024
    Location
    Newcastle, Australia
    MS-Off Ver
    365
    Posts
    2

    Question VBA to move rows to new sheet

    Hi - I am not good at Excel but a bit of a Word guru. I have been asked to automate a worksheet so that when an invoice is paid (see column K) a date is input - what needs to happen is once a date is input into column K, the row would move to a new worksheet. Attached example has those rows highlighted pale orange.

    I am hoping someone can help. Where I found myself really stuck was the information will get added to as new invoices are generated, and then once paid, will need to move to the bottom of the new sheet.

    I attach workbook.
    Attached Files Attached Files
    Last edited by davesexcel; 05-31-2024 at 07:08 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula or Macro to Move Rows From Sheet 1 to Sheet 2 in Same Workbook
    By singerr45 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-03-2017, 02:31 PM
  2. [SOLVED] Macros To Move Multiple Rows To Another Sheet And Macro To Move Single Rows To DAX Table
    By jcaynes in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2013, 05:08 PM
  3. Replies: 2
    Last Post: 08-27-2013, 05:01 PM
  4. 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
  5. [SOLVED] Move rows of data from one sheet to another based on specific values of sheet
    By buntalan80 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-26-2013, 06:21 AM
  6. [SOLVED] Copy row from sheet 1 to next row in sheet 2. delete from sheet 1 and move rows up
    By papabob1954 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-16-2012, 09:38 PM
  7. 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

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