Help adding to existing code

**Jrykiss** · 12-02-2010, 12:52 PM

Hello,

I currently have code that will copy certain cells to another worksheet when a certain case is entered in column V. Here's the working code I have right now:

Please Login or Register  to view this content.

It turns out that I am going to need 7 columns that have the possibility of having the availabe case's, columns V, W, X, Y, Z, AA, and AB. I need to rewrite this code so that this script will run on all 7 of these columns, but totally seperate instances. For example, if OC01 was triggered in column Z, I need it to do all the copying that is above, except the the first "range" line needs to be for the column that was triggered. Right now the code is exclusive for Column V having the triggers.

I hope I explained this well enough.

Thanks!

**Cutter** · 12-02-2010, 01:38 PM

As per the Forum rules you'll need to put code tags around your code.
Then you'll get some help.

**Jrykiss** · 12-02-2010, 01:47 PM

thanks for the heads up. The code tags are now around the code. I tried to attach my file as wel, but I keep getting an error.

Thanks again!

**JBeaucaire** · 12-02-2010, 03:38 PM

Reduce the file size by eliminating sheets/data not pertinent to this issue, or zipping the file.

**JBeaucaire** · 12-02-2010, 03:41 PM

Maybe this:

Please Login or Register  to view this content.

**Jrykiss** · 12-02-2010, 03:57 PM

Ok, I managed to get the file attached in a zip file. The code I'm working on is for the "Jan. Paid" worksheet. JBeaucaire, the code you supplied is in there right now. It is working for all columns except I still haven't resolved the copying of the trigger code from the respective column to column B on the "Details" sheet.

Thanks again!

**JBeaucaire** · 12-02-2010, 04:22 PM

Your zip is unreadable.

**Jrykiss** · 12-02-2010, 04:26 PM

got the actual file to upload this time. If that doesn't work, I'm lost

**JBeaucaire** · 12-02-2010, 04:32 PM

It worked for me as is. Shut down your Excel and restart it, just to be sure.

**Jrykiss** · 12-02-2010, 05:40 PM

The issue is when the code is triggered, it is transferring certain information to the "details" page. So, if the code was in column V, then everything is fine. But then if another code needed to associated with that, I would put that in column W. When it creates the entry in the "details" page, I need column B in details to have the same code that triggered the copying of information.

Does that make sense?

I've attached some screenshots trying to illustrate what I'm talking about.

**JBeaucaire** · 12-02-2010, 06:01 PM

Probably just change this:

Please Login or Register  to view this content.

....to...

Please Login or Register  to view this content.

**Jrykiss** · 12-02-2010, 06:11 PM

Genius!

That works.

Thanks so much. You guys are awesome

Help adding to existing code

LinkBack

Thread Tools

Rate This Thread

Display

Help adding to existing code

Re: Help adding to existing code

Re: Help adding to existing code

Re: Help adding to existing code

Re: Help adding to existing code

Re: Help adding to existing code

Re: Help adding to existing code

Re: Help adding to existing code

Re: Help adding to existing code

Re: Help adding to existing code

Re: Help adding to existing code

Re: Help adding to existing code

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions