Results 1 to 3 of 3

copy a range of data based on one entry

Threaded View

  1. #1
    Registered User
    Join Date
    11-13-2007
    Posts
    9

    copy a range of data based on one entry

    This may be simple, but I cannot figure it out.

    - On worksheet one, I have 3 columns of data in columns A, B and C.
    - There are about 2600 rows of data in these columns.
    - Column A in these rows all contain serial numbers

    - On worksheet two, I have 3 columns for potential data in columns A,B and C.
    - In the rows in column A of worksheet two, I will type in one of the serial numbers that is already in one of the cells in column A on worksheet one.
    - When I type in that serial number in column A, I would like the data in columns B and C, in the same row as that serial number in worksheet one, to automatically populate columns B and C in the row that I just typed the serial number in worksheet two.

    These serial numbers are for items that will arrive at different times. After the data automatically populates B and C, I will put the date it arrives in column D. The data in columns B and C are long strings of alphanumerics. I know they are correct in worksheet one, I want to make sure they stay that way in worksheet two. Thanks in advance for any help you may be able to give me.
    Last edited by armyguy; 04-08-2009 at 01:29 AM.

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