+ Reply to Thread
Results 1 to 2 of 2

Dropbox inquiry

  1. #1
    Registered User
    Join Date
    Cambridgebay Nunavut
    MS-Off Ver

    Dropbox inquiry

    Good evening. I am working on a 52 week file where various sales are entered from different departments on a daily/weekly basis. What I am trying to do is combine annually also. Currently I have a main page that shows a running total for each department annually or I can select the specific week, however I am also trying to create a dropbox to select a specific year also to view that information necessary however I do not know how to make a drop box to view information from a closed book. Alternatively I am curious if it is possible to display a previous year (book)'s data in 1 opened workbook. Essentially if I was viewing 2016 sales to see 2015's sales in a +/- ratio. Any and all help would be appreciated. Thanks.
    Attached Files Attached Files

  2. #2
    Forum Contributor S O's Avatar
    Join Date
    MS-Off Ver
    Office 2010 + 2013 + 2016

    Re: Dropbox inquiry

    You can create a sync folder for Dropbox on your local machine and use it just like any other folder for opening workbooks. You could even use formulas to pull the data from the workbooks without any VBA

+ 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] v-look up inquiry
    By leebird in forum Excel General
    Replies: 2
    Last Post: 01-06-2016, 06:07 PM
  2. vba message box inquiry
    By UMBiii in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2014, 12:24 PM
  3. Excel VBA Code to upload a file to Dropbox using the Dropbox API
    By gb# in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2014, 03:41 PM
  4. Scheduling Inquiry
    By gum605 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-17-2012, 05:55 PM
  5. [SOLVED] IF Statement Inquiry
    By Opus1 in forum Excel General
    Replies: 16
    Last Post: 03-30-2012, 09:59 AM
  6. IF Formula Inquiry
    By Mrgbolee in forum Excel General
    Replies: 3
    Last Post: 10-22-2010, 08:26 PM
  7. Formula Inquiry
    By lilsnoop in forum Excel General
    Replies: 5
    Last Post: 04-02-2007, 09:59 PM


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