Copying data in a row into a sheet with the same name.

[EsoTerik11]

Hello, I am fairly new to VBA and am struggling to get one thing right in my workbook. I have the macros written that reads a cell in column D on my main data sheet and it creates a new sheet tab with that number. I want to copy the data from the row with the same identifying number and paste it into the sheet with the same name as the identifying number since some of the identifiable numbers have many duplicates on the main data sheet. The number I want checked and compared to the sheet name is in column D and the data starts on D2 under the header. The data in the row I want copied and pasted goes from A2:W2. I don’t need it to update when new information is added since this document will serve as a template to convert the data given to it.

 

[OaklandJim]

This sounds doable. I'll try to assist. But you'll have to help the helper a bit so that the helper does not have to imagine your data and worksheet.

Might we see the code?

Also, post some data using Mr Excel's excellent XL2BB which enables you to post a portion of a worksheet. See HERE for details.