+ Reply to Thread
Results 1 to 3 of 3

Copy data from one worksheet to the alternate line in another workseet

  1. #1
    Registered User
    Join Date
    09-16-2011
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    52

    Question Copy data from one worksheet to the alternate line in another workseet

    I would like to copy the data from one worksheet to the alternate row in another worksheet as follows. I've attached a file showing the source file and the desired output.

    1. Copy column B's data in worksheet "Working" to worksheet "Upload file" Column V. B2's data goes to V1, B3's data goes to V3, B3's data goes to V5, so on and so forth.
    2. Copy column H's data in worksheet "Working" to worksheet "Upload file" Column F. H2's data goes to F1, H3's data goes to F3, H3's data goes to F5, so on and so forth.

    The number of rows with data in worksheet "Working" varies. It could be 30 lines one time and over 100 lines another time.

    Can anyone give me a hand? Many thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Copy data from one worksheet to the alternate line in another workseet

    In column V, i see that the data is duplicated every 2 rows, but its not the same with column F. Should it be this way?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    09-16-2011
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    52

    Re: Copy data from one worksheet to the alternate line in another workseet

    Thanks for your reply, arlu1201.

    Yes, it should be that way. Actually, I'll fill the same text "210207" in the blank cell under those VXXXXXX in column F. I know how to fill it (by VBA code). So, I think I shall not bother you guys with them and only asked for those I don't know how to code. Of course, it would be great if you could also include the action (fill the text "210207) in the VBA code.

    Actually, as long as I have the code to do point 1 or 2 above, I shall be able to work out the code and fill the cell V2, V4, V6 etc. I'm not sure if it's the most fastest way to do it. That's why I didn't remove the duplicate cell since I would like to see how the others will do it with VBA codes.

+ Reply to Thread

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