400 Error - Copying table data into copied worksheets

**carsonic** · 06-25-2010, 04:00 PM

I've never programmed in Excel before, but I tried cutting and pasting code from the internet plus use basic from my high school days in the late 80s.

I have data in a table on one worksheet in rows. I have a "document" on a second worksheet that has some empty cells that I want to populate with the data from the rows. I am trying to copy the second worksheet and give it the name of one of the cells, "CatNo", in each row. Then I want to move data from each row into different cells on the worksheet to complete the document.

As soon as I run it, I get a 400 error. I would appreciate any help that I can get.

Please Login or Register  to view this content.

**Leith Ross** · 06-25-2010, 04:24 PM

Hello carsonic,

Welcome to the Forum!

We can help you better if you post your workbook. It is easier to troubleshoot code problems with the original data and code.

**carsonic** · 06-25-2010, 04:59 PM

Thanks, Leith.

Attached is a sample of the file data.

**Leith Ross** · 06-25-2010, 05:12 PM

Hello carsonic,

Thanks for posting the workbook. You have two worksheets "List" and "BOM". So, I understand this you want to copy data from "List" over to the "BOM" sheet starting at row 10. How do you select which cells on "List" are to be copied over?

**carsonic** · 06-26-2010, 05:24 PM

I want to start on row 4, the first with the data. Then, for each row, I want to copy the sheet 'BOM' and give it the name in the CatNo. column. Then, I want to put the data from 'List' Row 4 into the new copied sheet - the PartNo goes into the new sheet under part number and print number; the description goes into the next cell over and in the cell above and the Cat No. goes below that one.

Then I want to repeat all over again with each row after that until all of the rows are complete and there is a sheet for each Catalog Number (CatNo).

Thank you