correctly 'wording' a for/next loop using a variable counter and variable filter

**DBoyd121** · 07-14-2016, 04:27 PM

Hello,

I'm not sure any of this is correct.

I want to copy the 4 cells[B:E] in every row that is > than my target date[J75], to a new range[K3:N60).

Daterange1 is a user defined variable from another sheet.
Countervalue1 is an automatic variable to limit the number of times the loop occurs.

Please Login or Register  to view this content.

Any assistance would be appreciated.

Thanks.

DBoyd

**Norie** · 07-14-2016, 04:30 PM

What do you actually want to loop through?

**DBoyd121** · 07-14-2016, 05:01 PM

Maybe I don't need to loop through anything.

I want to copy all rows with a date > a customer-defined date, to a new location/table.

Please Login or Register  to view this content.

**Norie** · 07-14-2016, 05:15 PM

What sheets are involved? ie which sheet is E3:E60 on and which sheet does Daterange1 come from

**MrShorty** · 07-14-2016, 05:34 PM

The help file for the Range object https://msdn.microsoft.com/EN-US/lib.../ff838238.aspx includes sample code that uses the built in Advanced filter tool to copy data the meets a criteria (unique values in the example's case). I expect that, if you figure out how to formulate the "criteria range" criteria, the advanced filter could be used to extract the desired data from the table and enter it into another range.

**DBoyd121** · 07-14-2016, 05:59 PM

Excellent. This might be part of my problem.
I am working with two workbooks, so my cell designations might be wrong.

Daterange1 originally comes from workbook2, but I have it copied to workbook1 sheet2 cell J75
E3:E60 is in workbook1 sheet 2.

I'm might be making this too complicated.
If a row has a date after my daterange1, I want to copy some cells, from that row to a different row on a different sheet. (Or directly into workbook2, I don't care which.)
Done.

**Norie** · 07-14-2016, 06:13 PM

Looping through a range is pretty straightforward.

Here's one example.

Please Login or Register  to view this content.

correctly 'wording' a for/next loop using a variable counter and variable filter

LinkBack

Thread Tools

Rate This Thread

Display

correctly 'wording' a for/next loop using a variable counter and variable filter

Re: correctly 'wording' a for/next loop using a variable counter and variable filter

Re: correctly 'wording' a for/next loop using a variable counter and variable filter

Re: correctly 'wording' a for/next loop using a variable counter and variable filter

Re: correctly 'wording' a for/next loop using a variable counter and variable filter

Re: correctly 'wording' a for/next loop using a variable counter and variable filter

Re: correctly 'wording' a for/next loop using a variable counter and variable filter

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to set a variable in combination with a looping x counter

[SOLVED] VB Loop different variables and stop variable to find a new variable..

Require a counter with more than one variable

Adding a counter variable to code

VBA Loop, Find & Copy run-time error '91': Object variable or With block variable not set

Vba to select variable fields in table and filter by variable criteria and display result

[SOLVED] Counter variable in For Loop

Bookmarks

Bookmarks

Posting Permissions