+ Reply to Thread
Results 1 to 3 of 3

Add Data to another Sheet with VBA

  1. #1
    Registered User
    Join Date
    12-10-2012
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    6

    Add Data to another Sheet with VBA

    Hi guys,

    Im having an issue with some code ive been working on - Im not the most advanced VBA coder but I know my way around.

    Basically its a sheet for managing overtime which users do from a Frontend - They simply add thier overtime, hit send and it adds it to the backend database (currently using Sheet1 for testing purposes)
    The frontends 'sendable' data is in Range B17:L36 and the idea is it adds it on the first available empty cell.

    Ive got it working but it wont let me fire the Macro more than 3 times if there is no data in the sheet, and comes up with a Runtime error 1004 - Cells not found. If there is already data in there and ive used the macro 3 times already it will come up with the error again. Maybe im missing something? Any help would be greatly appreiciated.

    Code Below:
    Thanks

    Please Login or Register  to view this content.
    Last edited by tnttnt; 10-29-2014 at 04:28 AM.

  2. #2
    Registered User
    Join Date
    12-10-2012
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Add Data to another Sheet with VBA

    Ive figured out after a bit of testing that it must be something to do with the Frontend as it always stops/errors on/around row 36 on Sheet1.
    Which is how many rows are allowed on the Frontend.

  3. #3
    Registered User
    Join Date
    12-10-2012
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Add Data to another Sheet with VBA

    I figured it out, But thought I would add my solution for anyone else with the same issue.

    NEW CODE:

    Please Login or Register  to view this content.

+ 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] Need data from sheet A to appear in sheet B based on data posted in a column in sheet A?
    By Firebird77 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-02-2014, 06:27 AM
  2. Replies: 0
    Last Post: 05-21-2013, 03:09 PM
  3. Replies: 0
    Last Post: 04-16-2013, 07:29 AM
  4. Copy Data from Multiple weekly Sheet to Monthly sheet and filter the data
    By santhoshjoseph in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2012, 07:07 AM
  5. As user fills out data sheet, then fill out a results sheet based on data sheet entry
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-13-2012, 03:57 PM

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