+ Reply to Thread
Results 1 to 2 of 2

How does it work [custom Ribbon buttons specific to my file]

  1. #1
    Registered User
    Join Date
    12-25-2017
    Location
    UK
    MS-Off Ver
    MS Office 13
    Posts
    4

    How does it work [custom Ribbon buttons specific to my file]

    Hi,

    I've got a spreadsheet file 1. There is a cell called File name and if I put a name of a file 2 (e.g. Financial Performance Report) and press the button on the panel called Longview Community of spreadsheet 1, then the data from Financial Performance Repot will populate automatically a Tab in spreadsheet 1 called Longview Community. Before that I need to make sure that the spreadsheet 1 and the file 2 saved in the same location.

    Please, anyone knows how does the automatic population work?

    image1-2.jpeg
    Last edited by 6StringJazzer; 12-25-2017 at 01:56 PM. Reason: enhanced title

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,150

    Re: How does it work

    First, welcome to the forum.

    There are a couple of issues with your question that you should be aware of. First, as a new member, please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good thread titles. Your title does not say anything about your specific question, or help us decide if we should open your thread. I have updated it for you since it's your first post.

    Second, a photo of your screen doesn't tell us anything about your problem in this case. Instead you should attach your Excel file. The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

    Now, as to your file, the buttons you are referring to (Longview Community, etc.) are custom buttons that are created by macros. So nobody here is going to have any idea how they work without seeing the macros. The answer might be in the code in your file, which we will see if attached as above.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. populate a list on one work sheet from multiple work sheets that meet a criteria
    By Kelly Linton-Selkirk in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-21-2015, 03:56 PM
  2. [SOLVED] Macro Doesn't Work Through Button, Does Work Through Developer ->Macros Option
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-27-2013, 11:55 AM
  3. Macros stop to work when work sheet is protected. Run time error 1004
    By sellim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2012, 01:14 AM
  4. Replies: 4
    Last Post: 11-04-2011, 12:37 PM
  5. Replies: 5
    Last Post: 06-24-2010, 06:21 AM
  6. Copy rows from work sheets to combine to one work sheet based on cell value
    By joemcmillen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2008, 05:04 PM
  7. Replies: 2
    Last Post: 07-11-2006, 11:15 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1