+ Reply to Thread
Results 1 to 5 of 5

Macro for pasting Link cells various sheets to Summary Sheet

  1. #1
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    Macro for pasting Link cells various sheets to Summary Sheet

    Hi
    Greetings to All
    I take this as an oppourtunity for thanking forum for rendering invaluable solutions in excel vba coding.
    I am working in Accounts Department. We prepare various financials for our company
    We prepare different sheets for the relevant company and consolidate in summary sheet by copying the cells and pasting the link.
    It takes a quite a lot of time and we need to prepare atlease 50 sheets to 100 sheets We need to prepare this auditors so that they can view the link and satisfy.
    Is it possible to automate through macro.
    your advise will be helpful.
    Cell A3 will be heading of the sheet

    No of rows will be different for each each
    B colm with cell text" Total" shall be value will be pasted in the summary sheet.
    Attaching the excel

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Macro for pasting Link cells various sheets to Summary Sheet

    What about to put in sheet "summary", "TOTAL" & "TB amount" and "DIFFERENCE" on the top of the table: row 1,2,3 ???
    It will simplify the job !!
    - Battle without fear gives no glory - Just try

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Macro for pasting Link cells various sheets to Summary Sheet

    See here a piece of code .
    Pay attention to the sheets lay out which different from sheet to the other: The reference is "Raman"
    Have look also to the sum formula range in sheet "Summary": See file attached
    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    Re: Macro for pasting Link cells various sheets to Summary Sheet

    Hi
    Thanks a lot
    It works fine .
    I thank you from bottom of the heart.
    Thanks & Regards
    N.Srinivasan

  5. #5
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Macro for pasting Link cells various sheets to Summary Sheet

    You are so welcome

+ 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. Challenge: 3 different sheets, 1 summary sheet, how to link up?
    By KatSGLon in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-14-2018, 08:41 AM
  2. Attributing same cells but different sheets, to new summary sheet
    By silentb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-03-2015, 02:57 PM
  3. [SOLVED] Loop through sheets - pick up formula from same cells each sheet into summary sheet
    By Webbo in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-07-2013, 01:43 PM
  4. MACRO to copy cells from multiple sheets into a summary sheet
    By andrewtmliu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-02-2013, 10:48 PM
  5. [SOLVED] Summary sheet - copy cell contents from multiple sheets to one summary sheet
    By jsmity in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 10:32 AM
  6. Replies: 2
    Last Post: 02-27-2012, 10:45 PM
  7. macro that will automatically link a newly created worksheet to a summary sheet
    By liquidblack in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2009, 03:22 PM

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