Results 1 to 8 of 8

macro: when row in inserted in sheet 1 a row is inserted into other sheets copying formula

Threaded View

niamh147 macro: when row in inserted... 07-28-2014, 05:06 AM
patel45 Re: macro: when row in... 07-28-2014, 05:40 AM
niamh147 Re: macro: when row in... 07-28-2014, 11:07 AM
patel45 Re: macro: when row in... 07-28-2014, 11:43 AM
niamh147 Re: macro: when row in... 07-29-2014, 05:16 AM
patel45 Re: macro: when row in... 07-29-2014, 05:37 AM
niamh147 Re: macro: when row in... 07-29-2014, 08:28 AM
patel45 Re: macro: when row in... 07-29-2014, 11:10 AM
  1. #1
    Registered User
    Join Date
    07-28-2014
    Location
    london
    MS-Off Ver
    2010
    Posts
    4

    macro: when row in inserted in sheet 1 a row is inserted into other sheets copying formula

    hello! if anybody can help me with this i would be very very grateful as i have been struggling with it for a couple of weeks with it now!!

    Basically i have a workbook of 17 sheets. I'm looking for a macro that inserts a row into all other sheets when it is inserted into (preferably) sheet 1 (but whichever is fine!). When sheets are inserted i would like for all the formulas in each sheet to copy down the different formulas. the employee names are in column 2 of 2014 total, and each sheet copies the text... i dont mind copying over the names to each other sheet, but for this book to be used by others i need it to be as easy as poss!!!

    I have attached the workbook... please let me know if anybody can help at all or if its not possible!!!!!

    Really appreciate any answers or comments!!!

    niamh
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Insert Row in other sheets with inserted formula. 2007
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2013, 07:51 AM
  2. [SOLVED] Macro that links cells from to sheets via formula after being inserted
    By JohnMaier in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-28-2013, 06:40 PM
  3. Add a picture and assign a macro everytime a new sheet is inserted
    By bcn1988 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2013, 02:35 PM
  4. [SOLVED] Macro to link cells from two sheets after they are inserted
    By JohnMaier in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-06-2013, 06:16 PM
  5. Macro to copy some columns to newly inserted sheets
    By paul_20k in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2006, 10:48 AM

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