+ Reply to Thread
Results 1 to 2 of 2

Multi Function Macro (copy/paste values based on criteria, delete/insert rows, printing)

  1. #1
    Registered User
    Join Date
    09-11-2014
    Location
    Baton Rouge
    MS-Off Ver
    Excel
    Posts
    3

    Multi Function Macro (copy/paste values based on criteria, delete/insert rows, printing)

    So I am just now learning about macros and how beneficial they can be.

    I seem to know what macros are capable of but do not have the knowledge to create one. I can record a simple macro but what I am needing goes much further.

    Basically I have a workbook with two worksheet; one labeled "Borrowing Base Detail" and the other labeled "Released Units".

    The "Borrowing Base Detail" tab has multiple rows of headings so the data input does not begin until column C and row 7. The "Released Units" tab will have the same headings.

    What I need the macro to do is:
    1) if the data in each row for column E on the detail tab says "Remove", then copy the whole row and paste it on the next available row on the released tab. I want to paste the values only.
    2) insert another row on the bottom of detail tab but I also want it to include the formulas, conditional formatting, etc that are used within the detail tab

    On the detail tab my data input fields end on row 67 as row 68 sums the columns and I then have lookup tables below that, that drives most of the formulas in rows 6 through 67 on the detail tab. I would want the inserted row to be added prior to the data sum row. Is it also possible to have the # of rows added equal the # of rows that were just deleted? Additionally, row 67 just happens to be the ending row of data entry on this particular sheet. There could be instances where move data rows are required. In these cases I would just want the newly inserted rows to be added prior to the data sum row.

    I will then apply this macro to a button as the workbook is intended to be used by others. So once they change the status in column E to "remove", they can just have all move to the other worksheet with one click.

    I would also like to have another macro to provide two print options. Again, I would assign a the macro to a button for each option.
    1) to print all columns up to and including column AT
    2) to print all columns up to and including column BI

    I currently have it set where rows 1 - 6 and columns A - N are repeated when printing with columns A - AT all printed on page one and columns A - N plus AU - BI all printed on page two.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Multi Function Macro (copy/paste values based on criteria, delete/insert rows, printin

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Replies: 3
    Last Post: 09-27-2013, 04:33 PM
  2. Replies: 3
    Last Post: 08-15-2013, 01:22 PM
  3. Macro to Copy Values, Insert Row, Paste in Another, Delete Original Data
    By JimPDX in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-23-2013, 05:35 AM
  4. Excel Macro to insert two rows based on condition and copy and paste multiple cells
    By mannabhalo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-13-2012, 12:56 PM
  5. [SOLVED] Macro to copy and paste rows to a new sheet based on criteria
    By Belo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-31-2010, 02:25 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