Closed Thread
Results 1 to 2 of 2

Copy data from a Userform to multiple worksheets in same workbook

  1. #1
    Registered User
    Join Date
    03-21-2014
    Location
    Pittsburgh PA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Copy data from a Userform to multiple worksheets in same workbook

    All,
    I posted my first inproperly so here is my repost. I am a new member and very basic VBA user but getting better each day. I have a userform which loads the data into a worksheet named "Data" which is being used as a database for an event scheduler. I also load a calendar from a worksheet named "Month" so I need the information from the userform "UForm01" added to 2 worksheets.

    The userform adds a series of textboxes to worksheet "Data" in the first open row. I also need certain textboxes from the Userform to be added to another worksheet to populate the calendar.

    See the code below. Thank you for your help in advance.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Copy data from a Userform to multiple worksheets in same workbook

    No need to repost. Just add code tags around your code in your first post as you did here.So.

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy data from userform to multiple worksheets
    By kx1bn7 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2014, 12:36 AM
  2. Excel VBA multiple worksheets with pivot tables need to copy data to new workbook.
    By UseItOrLoseIt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-03-2013, 10:29 AM
  3. Copy/Paste Range of Data from Multiple Workbooks/Worksheets to Master Workbook/Worksheets
    By NumberCruncher311 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-19-2013, 08:21 PM
  4. Copy Data From Multiple Open Workbooks to Another Workbook with Separate Worksheets
    By lupitenis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-23-2012, 05:36 PM
  5. [SOLVED] copy data from multiple worksheets into master workbook
    By geordz in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-10-2012, 07:03 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