Hello,

I'm very new to any sort of programming and the process right now is not as streamlined as it should be. Any help would be great. This is a 2-parter.

There are 2 workbooks, MASTER LIST and ITEM LIST. The ITEM LIST copies certain columns from the MASTER LIST. One person is in charge of the MASTER LIST and another looks after the ITEMS LIST.

These 2 workbooks are very much reliant on each other.
A) When new items are added to the MASTER LIST, there's a button which copies all of the data within the specified columns into the ITEM LIST. See below for the code that's used:
Private Sub CommandButton1_Click()
Dim sourceColumn As Range, targetColumn As Range

Set sourceColumn = Workbooks("MASTER_LIST.xls").Worksheets("MASTER").Columns("A:F")
Set targetColumn = Workbooks("ITEM_LIST.xls").Worksheets("ITEMS").Columns("A")

sourceColumn.Copy Destination:=targetColumn
End Sub

B) The ID is initially listed as tbd and is the only thing that needs to be updated in the ITEM LIST. The other columns are needed info in order to set up the ID properly. When the ID is changed to a number in the ITEM LIST, e.g. 1001, it's then manually updated in the MASTER LIST.

What I need
For A) it currently copies everything in the columns but note that some rows contain a value of "n/a". I would like to exclude these rows when the data is copied over to the ITEM LIST. I would also like to add columns that are not consecutive in the range, like columns A:C, E, L (I've actually tried entering this but get a "Run-type error '13': type mismatch")

For B) once the ID numbers are assigned in ITEM LIST I want to have a button that will update these ID numbers in the MASTER LIST


Here's a sample of the ITEM LIST

RELEASE# ID SERIAL DESCRIPTION
01 1000 item1 item1description
01 1001 item2 item2description
01 tbd item3 item3description
01 tbd item4 item4description
01 n/a item5 item5description
01 n/a item6 item6description


Thanks in advance