transfer a selected range of data on one sheet to another workbook

**Ask Steve** · 08-22-2013, 06:40 PM

Hi, I am new to this trying to learn. My goal is to transfer a selected range of data on one sheet to another workbook as many times as needed, and place the data in succession. i.e. skip a row every time the data is transferred to the other workbook. (It can't be copy/paste) I am trying to send the worksheet titled "end of week" to the workbook titled monthly1.

I need help finishing my code. I have been watching several videos and reading through different forums but i can't figure it out.

Please Login or Register  to view this content.

thank you for the help

**jaslake** · 08-22-2013, 07:27 PM

Hi Ask Steve

Welcome to the Forum!

So, Ask Steve, I'm going to ask...why not?

It can't be copy/paste

**Ask Steve** · 08-22-2013, 07:49 PM

hello! thank you.

I guess it can be copy paste inside the macro if that is what you are asking. I just don't want to go to the trouble of copying and pasting the range of data inside the other excel workbook every time the data is updated. Using the record macro button, I came up with something similar to that, however the problem with doing that is, I am not sure how to modify the code to include an if statement to put the data into a cell range other than "A1" every time the macro is executed.

**jaslake** · 08-22-2013, 07:55 PM

Hi Ask Steve

Well, the recorded Code can be cleaned up to automate the process. Post your recorded Code (be sure to use Code Tags)...one of us will assist.

To use Code Tags, copy your code and click the # icon at the top of your post window...paste the Code between the

Please Login or Register  to view this content.

symbols.

**Ask Steve** · 08-22-2013, 09:04 PM

Please Login or Register  to view this content.

Very simple code as you can see. What I would like for it to further do is this; automatically paste into cell destination "A1:I9", then when the macro is run a second time I would like for it to then skip a row and paste in the exact same fashion except this time into "A11:i19", and continue doing this in a similar fashion every time the macro is run.

(I hope i put my code in correctly)

**jaslake** · 08-22-2013, 10:15 PM

Hi Steve

If no one gets back to you tonight I'll get back to you tomorrow...late here.

**Ask Steve** · 08-22-2013, 10:50 PM

Alright sounds good.

**JBeaucaire** · 08-23-2013, 01:49 AM

Like so:

Please Login or Register  to view this content.

**jaslake** · 08-23-2013, 09:47 AM

Hi Ask Steve

Try this

Please Login or Register  to view this content.

**Ask Steve** · 08-23-2013, 11:51 AM

Jaslake the code you provided does exactly what I wanted. I greatly appreciate your time and effort thank you very much.

JBeaucaire I went through the code you provided and it was similar to what I had in mind, but not exactly. Thank you for your input.