Results 1 to 8 of 8

inserting rows with data from one worksheet to another worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    03-11-2020
    Location
    Bloomington
    MS-Off Ver
    2018
    Posts
    22

    Question inserting rows with data from one worksheet to another worksheet

    Hi All!

    I'm not the best at explaining things so I'll try my best and include pictures.

    I have a question regarding VBA. I'm trying to add rows based on my "Domain Count" in column J with the data from columns D, E, & G in worksheet (Sheet1) into another worksheet (Sheet2).

    Excel Image 1.png
    Excel Image 2.png

    Even a macro to show me how to either:
    1) insert the number of rows based on 'Domain Count' under each header,
    2) copy and paste data under each specified header based on 'Control Objective'

    Thank you for your help!
    Attached Files Attached Files
    Last edited by excelhelp31120; 03-12-2020 at 10:13 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy rows 1-10 from one worksheet into another worksheet inserting above a particular row
    By meldev in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-21-2014, 06:16 AM
  2. How to protect worksheet against inserting new rows
    By Candaloo in forum Excel General
    Replies: 3
    Last Post: 08-27-2014, 01:44 PM
  3. Help with inserting mulitple rows in worksheet
    By Nadia June in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2013, 11:59 AM
  4. INSERTING ROWS IN PROTECTED WORKSHEET
    By TLAngelo in forum Excel General
    Replies: 0
    Last Post: 07-18-2006, 01:20 PM
  5. [SOLVED] Inserting rows, updating linked worksheet
    By Patti in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-20-2006, 05:30 PM
  6. Inserting fillable Rows within a Protected Worksheet
    By dtmd in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-18-2005, 02:40 PM
  7. Inserting Rows into a worksheet
    By Floyd Elkins in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2005, 08:09 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