Results 1 to 2 of 2

Cant copy form data to worksheet, new row.

Threaded View

  1. #1
    Registered User
    Join Date
    04-30-2010
    Location
    Fairmont,WV
    MS-Off Ver
    Excel 2007
    Posts
    66

    Post Cant copy form data to worksheet, new row.

    I have a form (Timesheet) that is filled out daily with dropdown boxes in some cells and formulas in others and just data in yet others. What I am trying to do is create a VBA and button so that once my form is filled out, I can click the VBA button and insert the data from certain cells in my form (Timesheet), into the first empty row of DestSheet, all in one row. The empty row has no formulas or anything in the cells. Each column will have a unique header label.
    I fill out two and sometimes more forms a day, each day, so I need the information saved and added to each time I finish a form and click the VBA button. The form is saved after in another location.
    Seems simple enough but it has me stumped.
    Attached Files Attached Files
    Last edited by kwik98; 05-14-2010 at 05:30 PM.

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