to filter rows by current month and 2 Criteria and include hyperlink to url

**Shamz41** · 10-06-2019, 01:50 AM

Hi

On the attached file there is a VBA code which filters data from a sheet named "report" and extract the required rows to an another sheet named "Extract". I need some help on this VBA for 2 criterias

1. To add in a function to only extract the rows for the current month based on the dates that are indicated in column I on the "Report" sheet which shows
-Status Completed in column P
- and submission blank in Column T

2. To include a hyperlink on the extract sheet in column G, with the hyperlink starting with www.testing + the number in column A + .com for each rows that are extracted

I've placed a sample sheet on the worksheet
to show this example

Do let me know if further elaboration is needed.

**madhumadhan** · 10-13-2019, 05:59 AM

Hi,

You can do this with out VBA and just using If Formulas. Here i am not able to upload Sample file. Please sent your mail id and I will forward sample file.

-
Madhan

**madhumadhan** · 10-17-2019, 12:51 AM

Hi,

Now Herewith attached Sample File as you requested..

**Pepe Le Mokko** · 10-17-2019, 02:35 AM

@madhumadhan
Administrative Note:

Don't ask members for information to continue threads privately

All questions and answers will benefit other posters like yourself when discussed in public threads. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.

**madhumadhan** · 10-17-2019, 02:43 AM

Originally Posted by Pepe Le Mokko

@madhumadhan
Administrative Note:

Don't ask members for information to continue threads privately

All questions and answers will benefit other posters like yourself when discussed in public threads. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.

Sorry for the inconvenience. At the time of Replying thread failed to Upload a file. I Promise that, Further Violation of forum rule, will not happen again.

to filter rows by current month and 2 Criteria and include hyperlink to url

LinkBack

Thread Tools

Rate This Thread

Display

to filter rows by current month and 2 Criteria and include hyperlink to url

Re: to filter rows by current month and 2 Criteria and include hyperlink to url

Re: to filter rows by current month and 2 Criteria and include hyperlink to url

Re: to filter rows by current month and 2 Criteria and include hyperlink to url

Re: to filter rows by current month and 2 Criteria and include hyperlink to url

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Edit Macro To Include Current Month and Year In File Path

[SOLVED] Amend message box text to include current Month and Year

VBA - Filter on the First of Current Month

VBA code adjustment to include only current month and previous month automatically.

[SOLVED] Set PivotTable Filter to Current Day, Current Week, Current Month, or Current Year

Use Inputbox to filter for current month

Exclude values with specific criteria in an array and include for only month of Jan

Bookmarks

Bookmarks

Posting Permissions