Macro to Export data into another worksheet

**Khafez** · 10-12-2016, 02:49 PM

I am looking to create a macro that enables me to first create a sheet based on a template and import data from the current sheet (Sheet A) into the newly created sheet (Sheet B) and import data from multiple data ranges. I have attached 2 photos: the first shows what would be considered the active sheet (Sheet A) with colored ranges (Section 1,2,and 3) and the second photo displays the created sheet (Sheet B) (which is created from a template sheet) with the same colored ranges where I'd like the information pasted from the original active sheet (Sheet A).

I know that this is possible but I'm not sure about how to do this. I am particularly confused about how you would write the macro so that it will pull data from each section in Sheet A and stop when it reaches a blank, then move on to the next section until the new sheet (Sheet B) has collected all the data from the original active sheet.

See the attached photos for reference.
Please help!

Capture 1.PNG
Capture 2.PNG

**alansidman** · 10-12-2016, 03:55 PM

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

**Khafez** · 10-12-2016, 04:08 PM

Hello,

Sorry for the mis-use of the forum. I am new to this. I have attached a sample file of what I am trying to do as well as the current code I am using. This code is very basic as it simply copies a set number of cells from the first sheet to the newly created sheet. What I would like to have is a smarter macro that uses named ranges to fill the new sheet with the appropriate information, assuming that the cell destinations may change.

Current code I am using:

Please Login or Register  to view this content.

Hope I did this correctly. Thanks for the reply.

Moderator Comment: I have added code tags for you. Please take the time to read all the forum rules and abide by them in the future.