Results 1 to 7 of 7

find 2nd blank row in WS2 and paste data

Threaded View

  1. #1
    Registered User
    Join Date
    04-12-2008
    Posts
    28

    find 2nd blank row in WS2 and paste data

    Hi everyone,
    I am trying to create a workbook that would work as follows:
    I enter values in worksheet 1 that calculate a comparison of 2 items.
    I recorded a macro that pastes these 4 rows into worksheet 2 and clears data entered in worksheet 1.
    So far - easy.
    What I would like to do is find some code that would let me enter new values in worksheet 1, and when the macro is executed, it would find the first blank row on worksheet 2, skip a row, and paste the info.
    By doing it this way, I would be able to keep adding new items, compare them and add them to worksheet 2.
    Can anyone help?
    Thank you in advance…
    Last edited by RPOD; 09-27-2009 at 12:32 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