copy certain cells from 1 spreadsheet to other spreadsheet depending on condition

Hi,

I have avoided doing macros before however now I think I need one.
I have noticed that the basic problem I have is a common one on this forum with different varibles for different people.
I have attached a dummy copy of the spreadsheet that I am using.

I need to copy cell information for one spreadsheet to one of 2 other spreadsheets depending on a dropbox condition.
The master spreadsheet is the Issues spreadsheet, and depending on whether the user chooses Transferred Complaints or Transferred Offences (in Column K) I need to transfer certain cells to the Complaints or Offences spreadsheets.

The information I need to transfer from Issues is:
Ref # - (Column A) -> (Column A)
Reported Advisor - (Column C) -> (Column D)
Organisation - (Column G) -> (Column E)
Complainant Name - (Column H) -> (Column F)
Closed Date - (Column L) -> (Column B)

The copy would happen when the user chooses Transferred Complaints/Transferred Offences in Column K. There are other options in that drop box but the do not need to be transferred.

I hope this all makes sense.
Thanks in advance

When you say "transfered to the other sheet" do you mean MOVED or just COPIED?

And I assume you don't want those "links" like you've put in the other sheets, rather just have the actual flat data in there?

1) Right-click on the ISSUES tab and select VIEW CODE
2) Paste in this sheet event macro

Please Login or Register  to view this content.

3) Close the editor and save your sheet.
4) Make a choice in column K and it will COPY to the subordinate sheet

Note, there's nothing to stop you from putting the same row on the subordinate sheet over and over again. We can add that...so that if you attempt to move an item to OFFENCES more than once it notices the column A "REF #" already exists on the sheet and either:

1) Aborts putting it there again completely
2) Enters the values again in the same row, overwriting the old values

This version does #2 above:

Please Login or Register  to view this content.

The macro has no effects for any values other than:

"Transferred Offence"
"Transferred Complaint"


All other values are ignored in my testing. Post up your misbehaving workbook with the macro installed so I can take a look.

Ah, I see, I restructured the macro a little on my final pass through and needed to add a section to specifically cover all other values, something my original macro didn't need to do...here you go:

Please Login or Register  to view this content.

EDIT: I noticed you weren't using the later version of the macro I posted.

Jabryantiii, be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you are not allowed to start questions of your own in someone else's thread...just offer assistance to them.

Start a thread of your own, feel free to include a link in your post to this thread if you find it relevant.

When creating your post, click on GO ADVANCED and use the paperclip icon to attach a sample workbook displaying your data and desired results.

Talk to you in your new thread.