Copy data from cells in one workbook to another based on the cell headings

**life42** · 02-02-2012, 02:39 PM

I need to copy the data from one workbook into another. I would like to copy the data by identifying the column headers. I have several tabs of information in the source workbook but I only want one tab for the destination workbook. I do not want to copy everything over from the source workbook. What would be the best way to do this. I have worked with VBA but it has been years, I know there is a way to do this. ga

Thanks in advance.

Jamie

**FDibbins** · 02-02-2012, 07:06 PM

Did you mean copy (physically copy/paste) or reference?

**life42** · 02-02-2012, 07:59 PM

I would like to copy the data.

**arlu1201** · 02-03-2012, 06:37 AM

It will be better if you attach your sample workbook with a expected output sheet so we know which columns need to go to the destination file.

**life42** · 02-03-2012, 08:37 AM

Here is an example of what I need I need the content from the JAMA spreadsheet into the sample load form.

**arlu1201** · 02-03-2012, 08:51 AM

There are several tabs of data in both files. So which tabs should be copied into which tabs of the destination file? You said you do not need all the data? So which columns should be copied?

**life42** · 02-03-2012, 05:03 PM

In the sample load form I need the Author field populated from the responder field in the Jama workbook, the comment field populated from the response field, the commentstatusid field populated from the status field. I need to parse the tab name of the source workbook to get the volume issue and page fields. I have a different workbook for each tab in the sample load form but I want all the tabs of the source workbook to be on the corresponding tab in the sample load form. I will run each source workbook separately. Thanks again for the help.