+ Reply to Thread
Results 1 to 6 of 6

switch to same sheet same cell in different workbook

  1. #1
    Forum Contributor
    Join Date
    04-25-2014
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    149

    switch to same sheet same cell in different workbook

    hello friends ,

    i have two different workbook ..
    workbook 1 = formula.xlsx
    workbook 2 = hyperlink.xlsx

    name of sheets in both workbooks are same
    sheet 1 = 5055
    sheet 2 = 5560

    now , is it possible if i am in cell b3 in worksheet 5055 of formula workbook ,
    and when i switch to hyperlink.xlsx , i am in automatically or already in b3 cell of worksheet 5055 of hyperlink workbook.

    formula.xlsx is main workbook , where main data is stored and studied

    for sample file i have attach two files with smaller data and only two sheets ,

    but actual data and number of sheets are more....
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: switch to same sheet same cell in different workbook

    By clicking a hyperlink?
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Forum Contributor
    Join Date
    04-25-2014
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: switch to same sheet same cell in different workbook

    yes hyperlink is good option ,

    but my formula workbook has already hyperlink to another workbook

    i am getting data to my formula workbook from another workbook ,

    but as a sample file , i dint attach file in that manner .....

  4. #4
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: switch to same sheet same cell in different workbook

    Sorry, i didnt mean that as a solution, i meant is it from a hyperlink, as you mentioned hyperlinks

    workbooks("Hyperlinks.xlsx").Sheets(ActiveSheet.name).range(ActiveCell.Address).activate

  5. #5
    Forum Contributor
    Join Date
    04-25-2014
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: switch to same sheet same cell in different workbook

    sorry sir ,
    but i am new to vba ....

    can you help me in detail , how to proceed ?

  6. #6
    Forum Contributor
    Join Date
    04-25-2014
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: switch to same sheet same cell in different workbook

    can anybody help me how to use below code for two different workbooks ,
    which is my original question .


    In a standard module, include the single line:

    Public addy As String

    In the Sheet1 code area, include the following event macro:

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    addy = ActiveCell.Address
    End Sub

    In both the Sheet2 and Sheet3 code areas, include the following event macro:

    Private Sub Worksheet_Activate()
    If addy <> "" Then
    Range(addy).Select
    End If
    End Sub

+ 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. [SOLVED] Shortcut key to switch between worksheets within a workbook?
    By BeginnerVBA in forum Excel General
    Replies: 1
    Last Post: 05-22-2014, 10:50 AM
  2. Replies: 0
    Last Post: 04-22-2014, 10:59 AM
  3. [SOLVED] Switch between IE and Workbook using macro
    By plasma33 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-25-2012, 08:32 PM
  4. Replies: 2
    Last Post: 06-06-2011, 05:45 AM
  5. How to switch to different tab in same workbook using VB code
    By bhagwat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-03-2009, 07:33 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