+ Reply to Thread
Results 1 to 3 of 3

how can I make a button that manipulate table in two ways?

  1. #1
    Registered User
    Join Date
    05-12-2013
    Location
    Tel Aviv, Israel
    MS-Off Ver
    Excel 2019
    Posts
    87

    how can I make a button that manipulate table in two ways?

    hello ,

    I've added excel file explaining it easily . basically trying to build a button to sort dates in one column, and then number all rows by order. constraint - if you relocate table+button the button'll still work, but if that isn't possible It's still gonna be awesome and bery useful also,

    I'll attach this button to 100's tables - will do this proccess 5-30 times a day, everyday ,it'll be so much nicer to just click a button instead of sorting, and give numbers to all rows - and mistakes rate are high.

    thanks for sharing skillful tools !!!

    THANKS.xlsm
    Last edited by netanel99; 08-03-2013 at 07:58 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,783

    Re: how can I make a button that manipulate table in two ways?

    If all you want is row number in first column, regardless of it's original position, so fifth row is always labelled 5 then just use a formula.

    =ROW([@DATE])-ROW(טבלה534[[#Headers],[DATE]])

    you will need to change the table name reference,
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-12-2013
    Location
    Tel Aviv, Israel
    MS-Off Ver
    Excel 2019
    Posts
    87

    Re: how can I make a button that manipulate table in two ways?

    much appreciated andy.
    thanks for precise and quality help.

+ 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] Ways to make my code run faster
    By JazzyBear in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-03-2013, 03:59 PM
  2. [SOLVED] How to make macro work two ways?
    By Taislin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2013, 02:15 PM
  3. [SOLVED] fastest ways to make a search
    By yberf in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2012, 11:08 AM
  4. Linking a table across 2 workbooks, both ways
    By Dula in forum Excel General
    Replies: 3
    Last Post: 05-28-2012, 06:49 AM
  5. [SOLVED] Can't manipulate pivot table
    By Grrffin in forum Excel General
    Replies: 1
    Last Post: 11-17-2005, 01:15 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