Autofilter for Unique values - changes paste location issue

I would like to start by saying i am pretty much a novice on this stuff so the coding is pretty clunky.

I have a workbook with multiple tabs. Each worksheet can have 2 or many rows and 1 or many values in the invoice number field. In each worksheet, I need to document each invoice number and the amount to be paid. I have the below 2 macros that can do the job but I haven't been able to figure out how to make the paste location dependent on the location of the last populated row.

Thanks in advance.

Please Login or Register  to view this content.

Hi bk77

If you want a tested solution, post your workbook (with code) so we can "see" what's going on. Before and after is always helpful. You're apparently using a recorded macro which is always a good starting point. However, recorded macros always leave a lot of detritus around...like "select".

Now, looking at your code I see that you're defining "LastRow" as

Please Login or Register  to view this content.

but I don't see "LastRow" used in the code.

You may wish to explore code like this

Please Login or Register  to view this content.

and/or

Please Login or Register  to view this content.

Let me know how I can help.

Hi bk77

I don't see AutoFill in your code and I can't tell by reading your code what it is you're trying to do. I'll be glad to help you trouble shoot if you'll share a sample file of what you have and what you'd like it to be.

Hi bk77

This code is in the attached...it appears to do as you require.

Please Login or Register  to view this content.

Let me know of issues.

Hi bk77

Ha...well you had THAT working before. Easy enough to fix...I'll back this afternoon.

Hi bk77

See if this does better

Please Login or Register  to view this content.

Let me know of issues.

You're welcome.