+ Reply to Thread
Results 1 to 7 of 7

I'm looking for a quick way to copy data from one worksheet to another

Hybrid View

  1. 11-09-2012, 06:31 AM #1
    robjbc
    robjbc is offline
    Registered User
    Join Date
    11-08-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    4

    I'm looking for a quick way to copy data from one worksheet to another

    Hi all,

    I need to transfer data from one worksheet layout to another (with a different header ordering) on a regular basis - the original worksheet is an export from a bookings website, the receiving worksheet is a template for upload to our database. It's a regular process so I'm wondering if there's a formula, macro or piece of code that can be written to bypass doing this manually each time and quickly populate the sheet.

    Attached: Original export worksheet headings.xlsxDatabase template.xlsm
    Last edited by robjbc; 11-09-2012 at 06:33 AM.
    Reply With QuoteRegister To Reply
  2. 11-09-2012, 07:15 AM #2
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: I'm looking for a quick way to copy data from one worksheet to another

    Both the workbooks dont have any columns in common. Which data should go where?
    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]
    Reply With QuoteRegister To Reply
  3. 11-09-2012, 08:00 AM #3
    robjbc
    robjbc is offline
    Registered User
    Join Date
    11-08-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: I'm looking for a quick way to copy data from one worksheet to another

    Hi Arlette,

    Very good point - part of the nightmare!

    I'm looking for the data sets to transfer as follows:

    Origin column | Origin column header -> -> -> Destination column | Destination column header
    B | Name -> -> -> B | Surname
    C | Email -> -> -> M | Email Address
    E | Contact Number -> -> -> N | Work Number
    G | Organization -> -> -> C | Organisation name
    H | Position -> -> -> Q | Job Title
    I | Contact Address -> -> -> G | City
    J | Mobile -> -> -> O | Mobile

    Hope that makes sense!

    Many thanks,

    Rob.
    Reply With QuoteRegister To Reply
  4. 11-09-2012, 08:07 AM #4
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: I'm looking for a quick way to copy data from one worksheet to another

    Will this format be the same for all the input files?
    Reply With QuoteRegister To Reply
  5. 11-09-2012, 09:01 AM #5
    robjbc
    robjbc is offline
    Registered User
    Join Date
    11-08-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: I'm looking for a quick way to copy data from one worksheet to another

    In reality no they won't (unfortunately!) although I am hoping to standardize in future. However, for the sake of this exercise let's assume that it will always be set out as above.

    Many thanks,

    Rob.
    Reply With QuoteRegister To Reply
  6. 11-09-2012, 02:01 PM #6
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: I'm looking for a quick way to copy data from one worksheet to another

    If they wont be the same when it comes to your original files, its no use in assuming its standard, because the solution will differ for both.

    Let me try and work out a solution considering that the format will not be standard.
    Reply With QuoteRegister To Reply
  7. 11-13-2012, 11:58 AM #7
    robjbc
    robjbc is offline
    Registered User
    Join Date
    11-08-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: I'm looking for a quick way to copy data from one worksheet to another

    Hi Arlette,

    I've attached a few example sheets of headers that show the range and, at times, lack of data that is extracted from the origin database.

    Hope this helps with regard to your last comment and many thanks,

    Rob. Original export worksheet headings 3.xlsxOriginal export worksheet headings 4.xlsxOriginal export worksheet headings 5.xlsx
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1