+ Reply to Thread
Results 1 to 1 of 1

VBA that runs down column finds a criteria then inserts rows & then pastes

  1. #1
    Registered User
    Join Date
    02-28-2018
    Location
    Edinburgh
    MS-Off Ver
    2016
    Posts
    12

    Unhappy VBA that runs down column finds a criteria then inserts rows & then pastes

    Hi All,

    Wondering if someone can help. I need help writing a code that can run down a document , identify a criteria, insert 4 rows then count up 5 rows and copy paste data from another sheet.

    Ive attached a sheet with a basic example but what I want it to do is run down the rows and identify "Dissallowed Costs" then insert 4 rows. Then go back up 5 rows and go into Sheet2 copy and paste the relevant data to populate the newly inserted rows.

    Any help would be hugely appreciated.

    Thanks
    Attached Files Attached Files

+ 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: 0
    Last Post: 12-08-2014, 12:14 AM
  2. InStr function doesn't find specific text, but finds any text in column and runs code
    By mikey3580 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-27-2014, 03:50 AM
  3. Replies: 5
    Last Post: 12-12-2012, 10:38 PM
  4. [SOLVED] Speeding up a macro that finds information and copies and pastes it.
    By DannyJ in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-05-2012, 07:38 AM
  5. [SOLVED] Automating a macro that copies and pastes data and pastes 2 rows under the previous one.
    By thebank in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2012, 05:02 PM
  6. Need macro that finds and selects blank cells in col A, pastes shape in all
    By salvator in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-26-2011, 01:12 PM
  7. [SOLVED] Macro which inserts a column and cut and pastes data
    By s b via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2005, 01:05 PM

Tags for this Thread

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