copy rows between sheets based on a cell value

Hello,
Here is what I am trying to do:
I have a master parts list (workbook a) that has all available parts.
I want to select (using an x as a value in column A of the worksheet) what parts I need (from the master parts workbook).
I then want to copy the selected items (from the master parts workbook (workbook a)) to a project specific workbook/sheet but only columns (B-K) from (workbook a).
The tricky part is that in the project sheet...columns L,M,N cannot be overwritten.
This is clearly a "pull" from the master parts list and would be code in the "project" sheet reffering the to the "master" sheet.

Would this be persistent...since the master parts list is used by multiple users.

I'm new to this VBA thing but find it intriguing....I've done a lot of scripting (solaris/Unix)...this windows stuff is new but I get the logic!

Any help would be greatly appreciated!

Since L,M,N cannot be over written, where is B-K being copied to? Are B-K blank in the project sheet, and it gets copied into the first empty B-K?

How does the code know the name on the project specific workbook?

What you're asking doesn't sound difficult, but providing an example before/after of what you are trying to do would help.

I am trying to copy from a master template (list) of parts. Columns B-K will be populated into a new worksheet.
The new worksheet columns are empty at the start and would be populated based on the next empty section (B-K).
Could I copy from the Master List (Code being called from the new project). That master list name would not change.

Read column A from the master list.
If that value = "X" then copy column B-K to the next empty line (B-K) in the project sheet
The new project sheet also has data/formula's in column L,M,N.

Thanks

You'll have to adjust wb1, ws1, and ws2 names to suit your needs.

Please Login or Register  to view this content.

I will play with this today....thanks!!!!