+ Reply to Thread
Results 1 to 12 of 12

copy data from one spreadsheet to other based on data

  1. #1
    Forum Contributor
    Join Date
    01-28-2013
    Location
    Rugby
    MS-Off Ver
    365
    Posts
    205

    copy data from one spreadsheet to other based on data

    Good Afternoon

    Im looking for a macro that will copy a column from one spreadsheet to ther based on the data in the top cell

    Any help with this would be much apreciated

    Thanks

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,776

    Re: copy data from one spreadsheet to other based on data

    What is the data in the top cell?
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Forum Contributor
    Join Date
    01-28-2013
    Location
    Rugby
    MS-Off Ver
    365
    Posts
    205

    Re: copy data from one spreadsheet to other based on data

    Quote Originally Posted by Mumps1 View Post
    What is the data in the top cell?
    Hi
    It is a date ie: 23/12/2014

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,776

    Re: copy data from one spreadsheet to other based on data

    How do you decide which date? Do you want to be prompted for the date or would it work for you if you simply double clicked the date to copy that column to another sheet?

  5. #5
    Forum Contributor
    Join Date
    01-28-2013
    Location
    Rugby
    MS-Off Ver
    365
    Posts
    205

    Re: copy data from one spreadsheet to other based on data

    I was thinking if in the spreadsheet that i want to copy the values to i have a cell with a specific date and match with the date in the other sheet

  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,776

    Re: copy data from one spreadsheet to other based on data

    Just to clarify .... In the destination sheet you have a cell with a date. In the source sheet you have dates across row 1. You want to find the date in the destination sheet cell in row 1 of the source sheet and copy that column over to the destination sheet. If this is correct, it would be helpful to know the names of the source and destination sheets and the cell location of the date in the destination sheet.

  7. #7
    Forum Contributor
    Join Date
    01-28-2013
    Location
    Rugby
    MS-Off Ver
    365
    Posts
    205

    Re: copy data from one spreadsheet to other based on data

    That is correct
    if you highlite in the macro where i will need to put this information i think i can do it myself, is just that my spreadsheet are too big and im not able to upload them

  8. #8
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,776

    Re: copy data from one spreadsheet to other based on data

    It would be helpful to know the cell location of the date in the destination sheet. Do you want to copy the column at the end of any existing data on the destination sheet?

  9. #9
    Forum Contributor
    Join Date
    01-28-2013
    Location
    Rugby
    MS-Off Ver
    365
    Posts
    205

    Re: copy data from one spreadsheet to other based on data

    the cell location will be B4 and will be a clean colum to be copy into
    Quote Originally Posted by Mumps1 View Post
    It would be helpful to know the cell location of the date in the destination sheet. Do you want to copy the column at the end of any existing data on the destination sheet?

  10. #10
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,776

    Re: copy data from one spreadsheet to other based on data

    Try:
    Please Login or Register  to view this content.

  11. #11
    Forum Contributor
    Join Date
    01-28-2013
    Location
    Rugby
    MS-Off Ver
    365
    Posts
    205

    Re: copy data from one spreadsheet to other based on data

    sorry can you just add coments in here like what is refering the workbook 1 and 2
    Thanks
    Quote Originally Posted by Mumps1 View Post
    Try:
    Please Login or Register  to view this content.

  12. #12
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,776

    Re: copy data from one spreadsheet to other based on data

    Please Login or Register  to view this content.
    Use this macro instead of the previous one. I've made a small change in the code. Change "Sheet1" and "Sheet2" to match the actual names of the sheets that you are using.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy data from One Spreadsheet to another based on a particular reference
    By filbert83 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-20-2012, 02:38 AM
  2. Replies: 4
    Last Post: 02-27-2011, 03:58 PM
  3. Exporting Data to a spreadsheet based on matching data
    By randell.graybill in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-08-2009, 01:58 AM
  4. copy data based on cell entry to different spreadsheet
    By kinad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-13-2008, 11:43 AM
  5. Replies: 5
    Last Post: 07-28-2008, 09:45 AM

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