Macro that copies new data from the bottom of a range to another sheet

**yeetboygenius** · 06-21-2017, 11:42 AM

I am a newbie to macros and know nothing

I have two workbooks with the same data ranges. One of them updates with new rows of data constantly which then needs to be copied and pasted into the other workbooks data. I need to create a macro that copies the data from where the new data starts (in the workbook that updates) and pastes it in the other workbook sheet at the end of the old data.

Is it possible to create macros that grab from one workbook and paste in another?

If this macro is possible could I add a function that drags down a vlookup formula at the far right of the data to the bottom of the new data (just for maximum efficiency)

Thanks

**xladept** · 06-21-2017, 01:05 PM

Seems rather straightforward

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**yeetboygenius** · 06-21-2017, 03:33 PM

Attached is a sample version of the type of process I need

for ease I included the auto-update data in the same workbook in a different sheet even though it would be an entirely different workbook.

what I need is
-the new data from auto-update sheet to be pasted to the bottom of the unupdated sheet and then I need the vlookup in the furthest column to be extended down to the bottom where the new data has been pasted

- I need to do this because the actual data I get updates frequently in mass and the reason I cant just directly use the auto updated workbook is because a program actually has to be run in
order to generate that sheet for one time use. (also why I cant just use any functions I know of)

Any help is appreciated thanks

**xladept** · 06-22-2017, 12:47 PM

Hi YeetBoyGenius,

Try this:

Please Login or Register  to view this content.

*Thanks for the rep!

We'll have to be more specific when setting the sheet names when they're in different books
but, if you already know how to do that, you're all set else give me some book names and
I'll add the code

**yeetboygenius** · 06-22-2017, 01:11 PM

It works but the only problem is that the whole entire autoupdated sheet copies to the bottom of the unupdated sheet when I only want the new data starting from project ID 16 in autoupdate to be copied to the bottom of the other. EDIT I FIXED THE COPY LENGTH PROBLEM

The actual data has to go from "Book1" in sheet "Project Requests Updated (64)" into "New PSFs Approved" in sheet "Project_Requests_Updated (37)"

**xladept** · 06-22-2017, 02:07 PM

Replace the Set line with these two Set lines and let me know:

Please Login or Register  to view this content.

*See if you fixed the copy-length the same way I did

**yeetboygenius** · 06-22-2017, 03:00 PM

yup I did it the same way. Thanks so much for your help!!!

**xladept** · 06-22-2017, 03:02 PM

You're welcome and it was fun!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Macro that copies new data from the bottom of a range to another sheet

LinkBack

Thread Tools

Rate This Thread

Display

Macro that copies new data from the bottom of a range to another sheet

Re: Macro that copies new data from the bottom of a range to another sheet

Re: Macro that copies new data from the bottom of a range to another sheet

Re: Macro that copies new data from the bottom of a range to another sheet

Re: Macro that copies new data from the bottom of a range to another sheet

Re: Macro that copies new data from the bottom of a range to another sheet

Re: Macro that copies new data from the bottom of a range to another sheet

Re: Macro that copies new data from the bottom of a range to another sheet

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro that copies a formula to another sheet and copies data at same time

Macro that selects a range of data from one sheet and copies to another

Macro assigned to button in Cell A3 copies data in range B3:Z3 to another sheet...

Need autorun Macro that copies data from Master sheet to second sheet based on condition

[SOLVED] Macro for copying work sheet and renaming copies after a range

Creating a MACRO that copies data from one work sheet, and 'appends' to another sheet.

How to make a macro that copies only the data within a range to another sheet?

Bookmarks

Bookmarks

Posting Permissions