Looping through visible rows in a filtered column and copying to these rows

**vorabj** · 03-09-2020, 09:04 PM

I have data range say A1:G10000 (this varies each month)
Row 1 has column headings
Column E is always blank except for the column heading in E1

Each time I filter column D I wish to copy a certain same text in each of the visible blank rows in the adjacent column E using VBA

Can someone please help.

**alansidman** · 03-09-2020, 10:15 PM

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**vorabj** · 03-10-2020, 07:05 AM

Thanks for your reply. I have attached a demo version for you to review.
regards

Looping through visible rows in a filtered column and copying to these rows

LinkBack

Thread Tools

Rate This Thread

Display

Looping through visible rows in a filtered column and copying to these rows

Re: Looping through visible rows in a filtered column and copying to these rows

Re: Looping through visible rows in a filtered column and copying to these rows

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Filter Visible Rows After Table Was Filtered

[SOLVED] Delete visible filtered rows

[SOLVED] Selecting the first x visible rows of a filtered table

[SOLVED] looping in filtered range by rows

Need some help on dynamic dropdow for filtered row or for visible rows only

Formula in visible rows of filtered column

Looping through visible rows only

Bookmarks

Bookmarks

Posting Permissions