+ Reply to Thread
Results 1 to 1 of 1

Moving Data from one worksheet to another worksheet

  1. #1
    Forum Contributor
    Join Date
    Atlanta, GA
    MS-Off Ver
    Excel 2010

    Exclamation Moving Data from one worksheet to another worksheet

    I want to copy data from a worksheet and then paste into the first blank cell in a particular column on a different worksheet. How can I create code to do this?

    I also want to code to copy a particular cell and then paste into a different worksheet based on 2 criteria.


    The TDC Out Workbook is where I am copying data from and then pasting to New Main RSA 2012 Workbook. The TDC Out Worksheet(which gets created new everyday by that day's date), gets filtered by RSA smallest to Largest and then Part(or Item) from A to Z. Then the manual process is...Copy the serial number listed in column C from the TDC Daily Out from the first Item listed and find the RSA on the New Main RSA 2012 workbook and then find the corresponding item number and paste the serial number in the first blank for that item number in Column C of the New Main RSA 2012 workbook. This workbook is formatted to highlight red if is duplicated in column B(which is good). Then repeat this process for every record on the dated worksheet from TDC Daily Out workbook.

    I would like to also add coding that would highlight or flagged the serial number on the TDC Daily Out workbook if it does not highlight red or if it highlights green(which means that it was already added to this column.

    I have attached the test workbooks(which are identical to what I am working with except in size of file) to this post. These workbooks are completely virgin! They have no code with them...yet:-)

    I believe I have explained the process well, but if you need further explanation, please let me know! I look forward to seeing what your masterminds can do!!!!

    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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