Results 1 to 5 of 5

Transfer data from Userform to multiple spreadsheets

Threaded View

  1. #1
    Registered User
    Join Date
    09-12-2014
    Location
    ON, Canada
    MS-Off Ver
    2007
    Posts
    24

    Transfer data from Userform to multiple spreadsheets

    Hello wonderful Exel Champions,

    I have a spreadsheet that uses two "if then" criteria to transfer data to the correct sheet. I am now looking to add a third. The user specifies a month and a category for the data in the userform to transfer to. I would like to add a "recurring" option. For expenses that stay the same every month. So when you check the "recurring" checkbox you wouldn't add any information in the "month" option. The data flows to all of the months in that category. Userform.GIF. The macro is already so long that I had to separate the info into two 6 months userforms. Is there an easy way to do this without adding another 1000 lines of code.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Transfer data to multiple spreadsheets - Accounting
    By KLG519 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-02-2014, 02:17 PM
  2. transfer data between multiple spreadsheets
    By ravidhiman in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-26-2014, 07:03 PM
  3. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-04-2014, 07:11 AM
  4. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-03-2014, 12:28 PM
  5. [SOLVED] VBA for Option Button on Userform to send data to Multiple Spreadsheets
    By rcfrench in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-08-2013, 11:43 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