+ Reply to Thread
Results 1 to 16 of 16

Copy data from an entry shet onto a master sheet

  1. #1
    Forum Contributor
    Join Date
    09-25-2011
    Location
    Lenasia, Johannesburg,South Africa
    MS-Off Ver
    Excel 2019
    Posts
    269

    Copy data from an entry shet onto a master sheet

    Greetings

    Currently I am cutting a nd pasting from one sheet to another both of the are in the same directory

    I need a macro that will read the data from the entry sheet and paste it onto the master sheet

    I tried a little but am unable to do so automatically apartf rom doing it manually

    I thank you for all of your help

    Regards

    raj
    Attached Files Attached Files

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Copy data from an entry shet onto a master sheet

    Hi raj

    Some advice...There is no way anybody can do what you are asking...

    Reason...

    Currently I am cutting a nd pasting from one sheet to another both of the are in the same directory
    Cutting and pasting what from where to where?
    I need a macro that will read the data from the entry sheet and paste it onto the master sheet
    Read what data...
    I tried a little but am unable to do so automatically apartf rom doing it manually
    Tried what?

    Unless we are Mind Readers lol...it is humanly impossible to assist...
    You will have to elaborate...I suggest uploading sample files with before | after scenario and explain in detail what the process is you are wanting to achieve...
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    09-25-2011
    Location
    Lenasia, Johannesburg,South Africa
    MS-Off Ver
    Excel 2019
    Posts
    269

    Re: Copy data from an entry shet onto a master sheet

    hi

    many thanks for the advice and guidelines

    I attached the first file which is called kp entry file that has data from under Race 1

    from column a7 to column Q24

    this data I copy onto he sheet Kp master

    in columns a7 to column q24

    I copy the data and paste for each set

    I need help with it to be done automatically

    The length may differ

    Trust that this helps
    Raj

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Copy data from an entry shet onto a master sheet

    Is there always 14 Blocks of 18 rows on each file...

  5. #5
    Forum Contributor
    Join Date
    09-25-2011
    Location
    Lenasia, Johannesburg,South Africa
    MS-Off Ver
    Excel 2019
    Posts
    269

    Re: Copy data from an entry shet onto a master sheet

    Hi

    Thank you for the reply

    Yes the max will be 4 blocks of 18 rows


    Regards

    raj

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Copy data from an entry shet onto a master sheet

    This code for full 14 block set as per sample files....
    Please Login or Register  to view this content.
    Last edited by sintek; 05-11-2020 at 07:02 AM.

  7. #7
    Forum Contributor
    Join Date
    09-25-2011
    Location
    Lenasia, Johannesburg,South Africa
    MS-Off Ver
    Excel 2019
    Posts
    269

    Re: Copy data from an entry shet onto a master sheet

    Hi

    many thanx for the macro

    I copied the macro into the kp entry sheet

    and when I run the macro, it gives me a sunscript out of range

    am I doing something incorrect

    I have both the files in a folder called kp masters

    regards

    raj

  8. #8
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Copy data from an entry shet onto a master sheet

    Are both files not open...are you wanting the code to open the master file
    Please Login or Register  to view this content.
    Last edited by sintek; 05-11-2020 at 07:41 AM.

  9. #9
    Forum Contributor
    Join Date
    09-25-2011
    Location
    Lenasia, Johannesburg,South Africa
    MS-Off Ver
    Excel 2019
    Posts
    269

    Re: Copy data from an entry shet onto a master sheet

    Hi

    many thanx for the correction

    when I run the script it skips race 1 and copies only races 3 and 4 > I entered data in race 7 and that is also not copied over

    Think am doing something wrong

    Raj

  10. #10
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Copy data from an entry shet onto a master sheet

    Think am doing something wrong
    Possibly...see attached after code has run...

    Please Login or Register  to view this content.
    Attached Files Attached Files

  11. #11
    Forum Contributor
    Join Date
    09-25-2011
    Location
    Lenasia, Johannesburg,South Africa
    MS-Off Ver
    Excel 2019
    Posts
    269

    Re: Copy data from an entry shet onto a master sheet

    Hi

    Eureka

    Its working now

    many thanx for your help for which I am really grateful

    the macro is working perfect

    just a question if I may ask

    you follow horseracing


    kind regards

    raj

  12. #12
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Copy data from an entry shet onto a master sheet

    you follow horseracing
    Nope...Not a clue

  13. #13
    Forum Contributor
    Join Date
    09-25-2011
    Location
    Lenasia, Johannesburg,South Africa
    MS-Off Ver
    Excel 2019
    Posts
    269

    Re: Copy data from an entry shet onto a master sheet

    Hi

    I would like to know

    if the destination file has in place of sheets 1 a name like Racemaster will it copy from the entry file "races" to the destination file with sheets name "Racemaster


    regards

    raj

  14. #14
    Forum Contributor
    Join Date
    09-25-2011
    Location
    Lenasia, Johannesburg,South Africa
    MS-Off Ver
    Excel 2019
    Posts
    269

    Re: Copy data from an entry shet onto a master sheet

    Many thanks for your help

    I sorted it out and thank you for your kindness and simple macro that is doing it work

    raj

  15. #15
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Copy data from an entry shet onto a master sheet

    No...Change red part in below snippet to name of destination sheet
    Please Login or Register  to view this content.

  16. #16
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Copy data from an entry shet onto a master sheet

    .........................
    THANKS.gif

+ 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. Compare Columns in Two Sheets. If Match, Transfer data in Cell from Sheet 1 to Shet 2
    By beconajoonu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2016, 12:32 AM
  2. Data Entry check by Master sheet
    By kannan1847 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-16-2015, 11:23 AM
  3. Replies: 1
    Last Post: 09-15-2014, 01:03 PM
  4. Replies: 0
    Last Post: 05-10-2013, 08:08 AM
  5. VBA Script for Transfer Data from Entry Sheet to Master by Using Command Button
    By sgolwalkar4ever in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2012, 07:24 AM
  6. copy data from shet to another based on date
    By kontti in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-04-2011, 07:38 AM
  7. Advice on Pulling from data entry to master sheet
    By Nick_in_Dubai in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2009, 03:49 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