+ Reply to Thread
Results 1 to 24 of 24

Copy & Paste the data Conditionally

  1. #1
    Forum Contributor
    Join Date
    05-10-2020
    Location
    india
    MS-Off Ver
    2013
    Posts
    221

    Copy & Paste the data Conditionally

    Hi,
    I am looking for a macro that does the things mentioned below

    Copy & Paste the data from 1.xls to Book1.xlsx

    macro will be placed in a macro.xlsm so the path should be hardcoded in the macro for both the files, so that i can change it as per my needs

    Note there may be a data in book1.xlsx so in that case paste the data below that data (plz see the sample file for this)


    Thnx For the Help
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Copy & Paste the data Conditionally

    have you ever coded before? look into the workbook, worksheet, and pastespecial objects and methods:

    https://docs.microsoft.com/en-us/off...e.pastespecial

    https://docs.microsoft.com/en-us/off...xcel.worksheet

    https://docs.microsoft.com/en-us/off...excel.workbook

  3. #3
    Forum Contributor
    Join Date
    05-10-2020
    Location
    india
    MS-Off Ver
    2013
    Posts
    221

    Re: Copy & Paste the data Conditionally

    No Sir, I am learning & I tried to make the same but due the logic condition, I am unable to make Sor

  4. #4
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Copy & Paste the data Conditionally

    so what kind of assistance would you like? the entire code routine to be written for you?

  5. #5
    Forum Contributor
    Join Date
    05-10-2020
    Location
    india
    MS-Off Ver
    2013
    Posts
    221

    Re: Copy & Paste the data Conditionally

    I am looking for the macro for the same Sir

  6. #6
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Copy & Paste the data Conditionally

    can you see my signature? is says: ""don't call me 'sir'"". I will take a look at your file.

  7. #7
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Copy & Paste the data Conditionally

    I looked at your files, and the first question I have is:

    why do you want to do this? you are duplicating data between 2 books. what's the purpose of that? I mean, I know this is trading data, but that doesn't justify what you want to do.

  8. #8
    Registered User
    Join Date
    05-10-2020
    Location
    INDIA
    MS-Off Ver
    2013
    Posts
    92

    Re: Copy & Paste the data Conditionally

    by mistake

  9. #9
    Forum Contributor
    Join Date
    05-10-2020
    Location
    india
    MS-Off Ver
    2013
    Posts
    221

    Re: Copy & Paste the data Conditionally

    I want to copy past the data bcoz its is important & i have to do it daily so i am looking for the macro for the same

  10. #10
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Copy & Paste the data Conditionally

    Quote Originally Posted by dumdumbum View Post
    I want to copy past the data bcoz its is important & i have to do it daily so i am looking for the macro for the same
    that doesn't answer the question. are you doing it because your manager told you to? if you don't have an answer that's fine. I just ask because so many technology workers are asked to do things by their managers and it makes absolutely no sense. If you simply need to get it done and you're not even told why, that's fine. I, or someone else, will more than likely be able to give you a solution.

  11. #11
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,489

    Re: Copy & Paste the data Conditionally

    Hi Mr dumdumbum/quirkybox/moldybread/Zaeguzah, sir ... why do you start threads under so many user names? Do you have any other alter egos?

    I ask/make the point because you have a very distinctive way of asking your questions and the topics and requirements are all somewhat similar

    Pretty sure you have other names on other forums, for example, MrExcel (hdgfss) and Excelfox (fixer) .
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  12. #12
    Forum Contributor
    Join Date
    05-10-2020
    Location
    india
    MS-Off Ver
    2013
    Posts
    221

    Re: Copy & Paste the data Conditionally

    I ask bcoz, If I post all question from one account then everyone will think how much I ask (I ask many questions, & now I ask less bcoz my work is almost completed

  13. #13
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,489

    Re: Copy & Paste the data Conditionally

    This seems to be a very similar requirement on MrExcel: https://www.mrexcel.com/board/thread...tches.1141101/

  14. #14
    Forum Contributor
    Join Date
    05-10-2020
    Location
    india
    MS-Off Ver
    2013
    Posts
    221

    Re: Copy & Paste the data Conditionally

    Yes Sir but it's different, I tried to edit but I was unable to do

  15. #15
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,489

    Re: Copy & Paste the data Conditionally

    There's no limit to the number of questions any user can ask. I know at least one user who has asked hundreds of questions over many years. No one has a problem with that ... it's what forums are for.

    What people do get annoyed about is being asked the same or similar questions many times on different forums ... especially if you try to conceal the fact by using multiple user names.

  16. #16
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,489

    Re: Copy & Paste the data Conditionally

    If you link all your threads under one user name, people will start to get an idea what you are trying to achieve instead of everyone starting from scratch every time.

  17. #17
    Forum Contributor
    Join Date
    05-10-2020
    Location
    india
    MS-Off Ver
    2013
    Posts
    221

    Re: Copy & Paste the data Conditionally

    Correct Sir

  18. #18
    Forum Contributor
    Join Date
    05-10-2020
    Location
    india
    MS-Off Ver
    2013
    Posts
    221

    Re: Copy & Paste the data Conditionally

    I have no issues with it & now I will use only 1 account to ask question

  19. #19
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,489

    Re: Copy & Paste the data Conditionally

    I have no issues with it & now I will use only 1 account to ask question
    Which one?

  20. #20
    Forum Contributor
    Join Date
    05-10-2020
    Location
    india
    MS-Off Ver
    2013
    Posts
    221

    Re: Copy & Paste the data Conditionally

    This one dumdumbum

  21. #21
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,901

    Re: Copy & Paste the data Conditionally

    Quote Originally Posted by dumdumbum View Post
    This one dumdumbum
    It appears that these are also yours?
    quirkybox/moldybread/Zaeguzah

    If so, I will delete them so you can use dumdumdum, please advise?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  22. #22
    Forum Contributor
    Join Date
    05-10-2020
    Location
    india
    MS-Off Ver
    2013
    Posts
    221

    Re: Copy & Paste the data Conditionally

    Do not delete all account bcoz I asked the question & all the post I made is important for me
    I will use dumdumbum

  23. #23
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,901

    Re: Copy & Paste the data Conditionally

    You are only permitted to have 1 account on this forum

  24. #24
    Forum Contributor
    Join Date
    05-10-2020
    Location
    india
    MS-Off Ver
    2013
    Posts
    221

    Re: Copy & Paste the data Conditionally

    Sure No problem Sir, Do one thing just make that account that i cant post question but the post that i posted that should not be deleted Sir, its a request

+ 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] Conditionally copy paste the data
    By dumdumbum in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-11-2020, 09:52 AM
  2. Copy and Paste Conditionally formatted rows
    By theTaoJones in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2019, 07:32 AM
  3. Macro to Conditionally Copy and Paste
    By jaggiej in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-24-2015, 02:31 AM
  4. [SOLVED] Insert new column and conditionally copy and paste values
    By kriahnadas.oo7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2013, 10:07 AM
  5. Conditionally Copy/Paste Data from one Workbook to another
    By justin19 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-02-2013, 04:48 PM
  6. conditionally copy formulas and paste their values based on columnA
    By cmmchick in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-29-2013, 05:02 AM
  7. Macro to Conditionally Copy-Paste Certain Cells
    By succel in forum Excel General
    Replies: 4
    Last Post: 08-10-2010, 09:37 AM

Tags for this Thread

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