Copy row values to columns based on criteria

**kas.samrari** · 02-19-2016, 02:42 PM

Greetings,

I have this vba code that copies entire row of data from one WS to another, which is working perfectly.

Please Login or Register  to view this content.

However, I would like to change things around where I would like to only copy all values from the last column based on criteria. Please see attached image. Thank you in advance for your help.

Regards,
ExcelCopy.png
Kas

**joe31623** · 02-19-2016, 02:58 PM

The simplest way to modify that code to do that is to probably change For I = 2 to LastRow
...to For I = LastRow to LastRow

...and embed in your criteria so your code will look like:

Please Login or Register  to view this content.

**kas.samrari** · 02-19-2016, 03:24 PM

Hi Joe31623,

I changed my code as follows but now I get "Run-time error '1004': Application-defined or object-defind error"

Please Login or Register  to view this content.

**kas.samrari** · 02-19-2016, 03:25 PM

Hi Joe31623,

I changed my code as follows but now I get "Run-time error '1004': Application-defined or object-defind error"

Please Login or Register  to view this content.

Copy row values to columns based on criteria

LinkBack

Thread Tools

Rate This Thread

Display

Copy row values to columns based on criteria

Re: Copy row values to columns based on criteria

Re: Copy row values to columns based on criteria

Re: Copy row values to columns based on criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Summing values based on criteria across columns?

[SOLVED] Copy/Paste multiple columns as values based on another columns criteria

[SOLVED] Copy Columns based on multiple criteria

Checking a range of columns and copying values to appropriate columns based on criteria

matching values based on criteria and return values from another columns

Lookup values based on criteria in two columns

Copy columns based on criteria

Bookmarks

Bookmarks

Posting Permissions