+ Reply to Thread
Results 1 to 11 of 11

Master data copy to another sheet

  1. #1
    Forum Contributor
    Join Date
    12-27-2008
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    235

    Exclamation Master data copy to another sheet

    Hello there,
    Last time I got help to get data in Master file by nankw83 forum contributor.

    I modified the my master file, and I want now send back data to particular sheet.

    Attached dummy file, here I would like data copy from Master file to Data 1 tab.
    Condition only before paste data should ask which tab to paste data.


    & how could be data copy is given in the "Result tab" to understand.

    Regards, Rahul
    Attached Files Attached Files
    Last edited by rr1050; 06-05-2020 at 12:12 PM.

  2. #2
    Forum Contributor
    Join Date
    12-27-2008
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    235

    Re: Master data copy to another sheet

    Can anyone have a look at my request?

  3. #3
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,709

    Re: Master data copy to another sheet

    Hi rr1050,

    So this is the opposite of the previous code ? Try the below code

    Please Login or Register  to view this content.
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

  4. #4
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016, 2019
    Posts
    833

    Re: Master data copy to another sheet

    Hi, I made a somewhat clumsier solution, but the outcome is the same:
    Please Login or Register  to view this content.
    Cheers
    Erwin
    I started learning VBA because I was lazy ...
    Still developing.... being more lazy...

  5. #5
    Forum Contributor
    Join Date
    12-27-2008
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    235

    Re: Master data copy to another sheet

    Many thanks once again nankw83 & Eastw00d.

    Code works perfectly.

    But I would like to say nankw83 you'r coding thinking of every corner if error exits...
    I like it and appreciated your time.

  6. #6
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,709

    Re: Master data copy to another sheet

    Glad to help

    You can thank those who've helped by adding Reputations by clicking the star under their usernames

  7. #7
    Forum Contributor
    Join Date
    12-27-2008
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    235

    Re: Master data copy to another sheet

    It seems that copy and paste change the format of cell, is it possible paste without changing format.

  8. #8
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,709

    Re: Master data copy to another sheet

    Try now …

    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    12-27-2008
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    235

    Re: Master data copy to another sheet

    Awesome it works very perfect as I required, I am very thankful to your support.

  10. #10
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,709

    Re: Master data copy to another sheet

    Glad to help

  11. #11
    Forum Contributor
    Join Date
    12-27-2008
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    235

    Re: Master data copy to another sheet

    Congrats I think you have gained Valued Forum Contributor.

+ 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. Replies: 19
    Last Post: 10-16-2017, 12:34 PM
  2. Replies: 1
    Last Post: 09-15-2014, 01:03 PM
  3. Replies: 1
    Last Post: 11-14-2013, 09:24 PM
  4. Copy Data from a fixed form of data sheet into a master excel sheet.....
    By sirimhk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2012, 08:48 AM
  5. [SOLVED] macro to auto copy data from multiple sheet to one master sheet
    By roger556 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2012, 01:52 AM
  6. Macro to copy data from one sheet to a master sheet with running totals
    By gmi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2012, 10:53 AM
  7. [SOLVED] Search for heading in data sheet and copy range to corresponding sheet in master workbook
    By sans in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-07-2012, 10:02 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