+ Reply to Thread
Results 1 to 2 of 2

Updating existing data in Spreadsheet from UserForm

  1. #1
    Registered User
    Join Date
    04-23-2010
    Location
    Berkshire
    MS-Off Ver
    Excel 2003
    Posts
    4

    Updating existing data in Spreadsheet from UserForm

    Hi, Looking for some help. I have a spreadsheet which is populated from a userform. I also have a userform which I use to retrieve the data from a drop down list - which works find (if coding a bit clunky!)

    I now need for the retrieved userform with the information to be able to update the information that is already in the spreadsheet. The spreadsheet is constantly updated with new input but need to update/add to ones already there. Any help would be appreciated.

  2. #2
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: Updating existing data in Spreadsheet from UserForm

    I doubt anyone is going to be able to help if you aren't willing to post a sample workbook or at least a snippet of the relevant code.

    You can most likely update the data by mostly reversing the method used to get the data into the userform.
    Is your code running too slowly?
    Does your workbook or database have a bunch of duplicate pieces of data?
    Have a look at this article to learn the best ways to set up your projects.
    It will save both time and effort in the long run!


    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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