Results 1 to 5 of 5

Add/copy row in one sheet when another sheet is copied/pasted using VBA

Threaded View

  1. #1
    Registered User
    Join Date
    01-12-2016
    Location
    Norway
    MS-Off Ver
    2016
    Posts
    76

    Add/copy row in one sheet when another sheet is copied/pasted using VBA

    I have one sheet for calculating parts with four different vendors.
    I often need more sheets to calculate in for different projects so i added a commandbutton for copy/paste the sheet i just used an reset user input after copied.
    This works great.

    But i also have this other sheet that sums up all prices from the "part" sheets.
    when i push my command button "add sheet" the sum sheet ned to add new rows representing the new sheet added for the four different vendors.

    the existing four rows that all have cell addresses in them to the existing sheet "parts 1" is B5, B22, B39 and B56.
    The new added cells should be B6, B23, B40 and B57.

    example. sheet totalt, cell B5 have
    ='parts 1'!K443+'parts 1'!K445+'parts 1'!K449+'parts 1'!K460
    when new row is pasted it should have
    ='parts 2'!K443+'parts 2'!K445+'parts 2'!K449+'parts 2'!K460
    Sums up sheet is named total
    My first sheet with parts is named: parts 1
    if i use my cmdbutton the next will be named parts 2, and the next parts 3 ..
    Last edited by wildonln; 01-28-2016 at 03:57 PM. Reason: spelling

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 05-06-2015, 02:44 AM
  2. [SOLVED] copy from one sheet to another triggered by an entry and then pasted if similar log no
    By FlyFisherman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2013, 05:21 AM
  3. Code to allow user to choose a sheet a copied cell is pasted to
    By tancho321 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-28-2013, 01:11 PM
  4. Vba to copy text only and keep formatting of sheet that its pasted on.
    By CarJon0767 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2013, 11:05 PM
  5. VBA Copy Sheet and and Different Cell to each copied sheet
    By Jerums in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2012, 02:08 PM
  6. Replies: 1
    Last Post: 07-07-2005, 10:05 PM
  7. [SOLVED] Delete the formulas of webpage, copied & pasted on excel sheet
    By Mustafa Abedin in forum Excel General
    Replies: 1
    Last Post: 06-19-2005, 10:05 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