+ Reply to Thread
Results 1 to 2 of 2

Making Sheet on excel need help for auto link

Hybrid View

  1. #1
    Registered User
    Join Date
    05-19-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2012
    Posts
    1

    Making Sheet on excel need help for auto link

    I am trying to make an account sheet on excel and need help in linking process like i have create a sheet of my daily work and i want link it with other sheet of single account
    automatically so don't have to entries again and again manually (Like i want toc create my whole account on excel)

  2. #2
    Forum Contributor
    Join Date
    12-28-2012
    Location
    Mumbai - India
    MS-Off Ver
    Excel
    Posts
    145

    Re: Making Sheet on excel need help for auto link

    It is based on the Sheets format you have

    if all the sheets you want to modify are having same format... that means all the required cell are at the same places use following code

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
     Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
    End Sub
    ELSE - if all the cells are in different different location - just use "=" formula

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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