Macro for copying and duplicating data based on a cell values.

**outthere** · 08-22-2009, 05:25 PM

I am trying to copy two cells from one worksheet to another in the same work book based on the value in Column B of one of the sheets. This is just a building block to a larger script I am going to create.

Below is my attempt but I keep getting an error at Range(Cells(x, 3)).Select.

Any help would be great.

Please Login or Register  to view this content.

**shg** · 08-22-2009, 05:56 PM

Maybe like this:

Please Login or Register  to view this content.

**outthere** · 08-25-2009, 10:22 AM

I tried the code and i get a "Type Mismatch" Error at line:

i = .Cells(x, 2)

Any ideas?

By the way, thanks for the help, I have a lot of learning to do!

**outthere** · 08-25-2009, 10:27 AM

I forgot to mention I am using Excel 2007 on Vista 64 Business, if that matters.

**shg** · 08-25-2009, 10:32 AM

I tried the code and i get a "Type Mismatch" Error at line:

i = .Cells(x, 2)

Chances are the cell contain a non-numeric value.

**outthere** · 08-25-2009, 10:45 AM

You are correct. It contains a count formula, any chance of making it work around that or will i have to paste values in the cell?

**outthere** · 08-25-2009, 11:09 AM

Ok i fixed it, the reference cell for "i" was in the other worksheet:

Please Login or Register  to view this content.

**outthere** · 08-25-2009, 12:31 PM

Thanks for the help. I have posted a new issue in a new thread found here:

http://www.excelforum.com/excel-prog...ml#post2152004

I guess it's a bit of a continuation of this one but any help would be appreciated.