How to transfer data from one workbook to another workbook using Macro

**kingsdime29x** · 09-17-2015, 12:04 PM

Hello,

I am trying to come up with a solution using a Macro in which I pull data from one workbook (1978 Batting Gamelogs) onto another workbook (1978 Toronto Blue Jays - Batting). I have all the player names with the stats I need in the batting gamelogs. I would like to get that file automatically update the stats in the Blue Jays batting file based off of team that he played and the date. I don't know if this is possible. If someone could let me know how I can make this process easier without having to manually enter all this information in that would be great.

Thanks in advance for your help.

**LJMetzger** · 09-18-2015, 10:41 AM

Hi kingsdime29x,

See the attached file which copies data to the Destination file as you requested. The following code is included in the file and is provided for information purposes only. Other functions in the file are required for the following code to run.

In an ordinary code module such as Module1:

Please Login or Register  to view this content.

If you want to get rid of the #DIV/0! display in the destination file, you may want to use the following formulas:

Please Login or Register  to view this content.

Lewis

**kingsdime29x** · 04-11-2016, 03:16 PM

I just tested this solution again and I have some dates that are double headers, which are indicators with the first game showing a
(1) next to the date and a (2) for the second game. When I go through the solution, it does not correctly carry over the game listed in
my destination file named 1978 Toronto Blue Jays - Batting. An example is looking at Rick Bosetti under the Yankees sheetname. He
played in doubleheaders (i.e. 05/21/78 (1) and 05/21/78 (2)) and the data is blank for these dates. I also attached the Gamelog
spreadsheet as well to show the data in there.

I'm not sure if it didn't pick up the information because it is not an actual date. Is there a way to correct this so that it pulls all
the data for even dates that include a (1) and a (2) next to the date?

Anything that can help resolve this would be very helpful and appreciated. Thanks in advance for your help.

**kingsdime29x** · 04-13-2016, 12:27 PM

Any experts that can help with this? Any help to fix this issue would certainly help me complete my project. Thank you in advance.

How to transfer data from one workbook to another workbook using Macro

LinkBack

Thread Tools

Rate This Thread

Display

How to transfer data from one workbook to another workbook using Macro

Re: How to transfer data from one workbook to another workbook using Macro

Re: How to transfer data from one workbook to another workbook using Macro

Re: How to transfer data from one workbook to another workbook using Macro

Thread Information

Users Browsing this Thread

Similar Threads

Macro to transfer all data from one workbook to a specific sheet in another workbook

[SOLVED] Error 1004 when trying to modify and transfer data from one workbook to a new workbook

Transfer Data from one workbook to worksheets in a closed workbook by criteria

[SOLVED] need help on a macro to transfer data to another workbook

Macro to transfer data from one workbook to another

Transfer data fron one workbook to another using macro

Transfer data fron one workbook to another using macro

transfer data from open workbook to closed workbook

Bookmarks

Bookmarks

Posting Permissions