1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Sync sheets of a workbook

Discussion in 'Business Applications' started by LindaStough, Jul 6, 2014.

Thread Status:
Not open for further replies.
Advertisement
  1. LindaStough

    LindaStough Thread Starter

    Joined:
    May 19, 2013
    Messages:
    175
    First Name:
    Linda
    I have a workbook with several pages. I want to keep them in alphabetical order by the client name. I add names every day.

    I use the Name field from the first sheet for all consecutive sheets.

    As I add names and sort the first sheet, it will sort the name field for all consecutive sheets.

    How do I sync all of the sheets so when I sort the first, it will sort the entire row from the first?

    I had a program through my company for tracking customer calls - date, time, conversations, etc. It also allowed for scheduling future calls, etc.

    The program had to be pulled and we are all on our own. I would like to use Access but I am a novice and don't have time to figure it all out.

    Do you know of any free programs that tracks customers?

    I would appreciate any help you can give.

    Thanks,
    Linda
     
  2. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    Can you upload n example workbook, without providing confidential data, please.
     
  3. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    My first comment is that you need a nice little macro written for you. I stopped doing macro's years ago, otherwise I would help you.
    I am sure somebody can help you.
     
  4. LindaStough

    LindaStough Thread Starter

    Joined:
    May 19, 2013
    Messages:
    175
    First Name:
    Linda
    If I sort sheet 1 by date, sheet 2 is incorrect. Below the actual data on sheet 2, I show what the sort would look like if the entire sheet was sorted by date.

    I hope you can help me.
     

    Attached Files:

  5. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    You need a macro
     
  6. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    Can anybody help this lady please
     
  7. CodeLexicon

    CodeLexicon

    Joined:
    Oct 15, 2013
    Messages:
    503
    Here's a macro which will loop through all sheets and sort in name order, assuming your headers are in the first row


    Code:
    Sub SortNamesAllSheets()
    '
    ' Sort Macro
    '
    Dim w As Worksheet
    Dim UR As Range
    Dim NameCol As Range
    
    
    
    'loop through worksheets
    For Each w In Worksheets
    
    
    
    'find "Name" Column Header
        For Each c In w.[1:1]
            If c.Value Like "Name" Then
            Set NameCol = c.EntireColumn
            Exit For
            End If
        Next
    
    
    
    'determine used range of worksheet
    Set UR = Range(Cells(1, 1), Cells(w.UsedRange.Rows.Count, w.UsedRange.Columns.Count))
    
    
    'sort each sheet according to "Name", in ascending order
    w.Sort.SortFields.Clear
    w.Sort.SortFields.Add KEY:=NameCol _
            , SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
        With w.Sort
            .SetRange UR
            .HEADER = xlYes
            .MatchCase = False
            .Orientation = xlTopToBottom
            .SortMethod = xlPinYin
            .Apply
        End With
    Next
    End Sub
    

    There are Access superstars on here, so if you do have the time to explain what you are trying to do, you might find someone willing to assist you in setting it up. I would suggest starting a new thread if that is the case. :)
     
  8. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    Thanks there David. Can you take over this now, then, please.
     
  9. CodeLexicon

    CodeLexicon

    Joined:
    Oct 15, 2013
    Messages:
    503
    Sure, happy to handle any queries. :)
     
  10. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
  11. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1129130

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice