+ Reply to Thread
Results 1 to 3 of 3

[QUESTION/HELP-VBA/MACROS]Auto Edit Link from "Sheet1" to "Sheet2"

  1. 07-28-2016, 11:41 PM #1
    iphone3g
    iphone3g is offline
    Registered User
    Join Date
    07-28-2016
    Location
    Bantayan, Cebu
    MS-Off Ver
    2016
    Posts
    4

    Question [QUESTION/HELP-VBA/MACROS]Auto Edit Link from "Sheet1" to "Sheet2"

    Is there a macro or a formula where when i copied "Sheet1" it will automatically generate or edit the link formula for "Sheet2" where "Sheet1" and "Sheet2" is linked to sheet "Summary". Where sheet "Summary" contains the link for the sheets to be copied or will be created in the future.

    Picture 1 - sheet "Summary": is the main sheet where i enter my data and then goes to the sheets.

    Summary.jpg

    Picture 2 - sheet "Sheet1-infinity": is the sheet/s to be created/copied where it contains the links from sheet "Summary" that what i want to happen is when i copied "Sheet1" it will make the formula from "Sheet1" like =SUMMARY!A4 to newly created/copied "Sheet2" become =SUMMARY!A5 and so on and forth all i need to do is copy sheet then rename it then all links is well.

    CopiedSheet.jpg

    Picture 2.A - Copied Sheet: Newly Created-Copied Sheet for "Sheet14"

    CopiedSheet1.jpg

    Picture 2.B - the IDEA i want to make:

    crop2.jpg
    Reply With QuoteRegister To Reply
  2. 08-10-2016, 11:44 AM #2
    CRIMEDOG
    CRIMEDOG is offline
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Re: [QUESTION/HELP-VBA/MACROS]Auto Edit Link from "Sheet1" to "Sheet2"

    Clarification needed
    Does the Bill Number Column reference the Sheet i.e. Bill Number 1 relates to Sheet1! . Bill Number 2 relates to Sheet2! etc...?
    Reply With QuoteRegister To Reply
  3. 08-24-2016, 02:49 AM #3
    iphone3g
    iphone3g is offline
    Registered User
    Join Date
    07-28-2016
    Location
    Bantayan, Cebu
    MS-Off Ver
    2016
    Posts
    4

    Re: [QUESTION/HELP-VBA/MACROS]Auto Edit Link from "Sheet1" to "Sheet2"

    Quote Originally Posted by CRIMEDOG View Post
    Clarification needed
    Does the Bill Number Column reference the Sheet i.e. Bill Number 1 relates to Sheet1! . Bill Number 2 relates to Sheet2! etc...?
    Yes sir thats right (y)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel 2010 -- "Visual Basic" "Macros" and "Record Macro" all disabled.
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2017, 06:11 AM
  2. [SOLVED] Range("A1") = Sheets("Sheet2").CenterHeader.Text doesnt work.
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-27-2013, 07:06 AM
  3. Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"
    By Jokeman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  4. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  5. [SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 08:28 PM
  6. Auomatically populating "Sheet2" when "Sheet1" is full
    By longbow007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2013, 11:50 AM
  7. [SOLVED] Sheets("Sheet2").Range("AA1") = "Note"
    By dcburkejr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-03-2012, 04:10 PM
  8. use variable in Workbooks("book1").Worksheets("sheet1").Range("a1"
    By Luc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2005, 04:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1