Copy row based off entry in either of two columns

[hambly]

I'm trying to alter the below code slightly. It currently looks at column M (13) and if it has an entry, it will select that row (from A:AE) and copy to clipboard.

I'd like to change it so it would look at either 19 (column S), or 32 (AF) and select/copy to clipboard A:BS if either cell has an entry

For example AF6 has data, the macro will copy A6:BS6
If AF6 has nothing, but S6 has data, it will also copy A6:BS6

It could also be the other way round. S6 is blank, but AF6 has data, it will copy A6:BS6

Please Login or Register  to view this content.

[natefarm]

Please Login or Register  to view this content.

[hambly]

Thanks Natefarm. Works great. Just one thing, it needs to start at Row 6, not before. I have headers and totals in Rows 1-5 that should not be selected.

[natefarm]

Just start with rw = 4 instead of 1.

[hambly]

Perfect! Thanks again.

[hambly]

Hi Nate - I'm trying the above but changing it to only Select the rows. I simply changed .Copy to .Select.

It seems to highlight, but then if I go to a Data Sort it says it can't as multiple selections are chosen, even though it appears it's only one selection.

Should the above VBA work the same ending with .Select?

Thanks.

[natefarm]

The code is selecting the rows one at a time, rather than as a block, just as if you selected several rows one at a time using the Ctrl key, and in theory, there could be blank rows in-between, so I don't think you'll be able to sort on the selection the way it's coded.

[hambly]

Ok. Makes sense.

Is it possible to change it so it selects as a block for the Select VBA. The Select option is only used when the rows are confirmed as having data in blocks.

[natefarm]

This should do it.

Please Login or Register  to view this content.

[hambly]

Perfect. Thanks again! And sorry, that was probably not the correct way of asking for further help on a closed thread...