Search results

Hi i have the below code to sort by multiple columns but for some reason it is not working. I do not get an error message but the code doesn't work. What am i missing? Thanks for your help With ActiveSheet.Sort .SortFields.Clear .SortFields.Add Key:=Range("D9:D700" _...

Hi, i have the following fixed path and would like to extract the numbers from the text string. For instance, for below, i would like to extract: 97357 and 2203 without using Text to Columns but formula. Totals for 97357 Westhills Village Health Care Totals for 2203 GL - Prairie Hills Thank...

I agree there is a shorter way to write the code but i will have to play with it next time. your code is okay but it will not filter correctly. i just don't have time to mess with it to understand the syntax becuase the project is due on monday. i will play with it when i have more time even...

Everything works but the field will not filter. The filter doesn't recognize the date parameter and skips it. For example i have 10-2016 filtered but it will not filter. I think it is best to do multiple if statements. If Range("b7") = vbNullString Then 'it is blank dataWB.Close...

The filter field is field 15 not 11. it was wrong in the code.

I think i found the issue. I replaced .columns(B:AC) with .ListObjects("CJR_TBL").Range.AutoFilter Field:=15

Thank you but i am getting this error message: If Range("b7") = vbNullString Then 'it is blank dataWB.Close SaveChanges:=False Else With ActiveSheet .Unprotect "ops" .AutoFilterMode = False...

Hi vlatem. could you explain why the cv string? Thanks

Thank you for the syntax. i believe this will work. It is much apprecaiated

Thanks vletm but i don't think that addresses my issue. I appreciate your help. i will see about another alternative.

Thanks for the response vletm but that is not the issue. There are two issues, if you look at the table, i have a column for month and year that is formatted based on column O. So if a the timeframe is Year, then column 2 is filtered. I want to know if there is a way to filter the timeframe only...

Hi, From a dropdown user selects the following date format for months (09-2016, 10-2016, 11-2016, etc.) and for years they select (2016, 2017, etc.) I have a macro that filters for the specified date but I believe there is a more efficient way of doing this. The way i am doing this now is...

Hello, I have a macro that a message box opens and the user selects "yes", or "no". If the entry is "no", i want it to populate the next empty cell in a column. How do i accomplish that? For example in the image below, if a user selects "no", then i would like the macro check the adjacent...

Thank you guys. i fixed the syntax. i had the below code before the End If statement and therefore with the multiple nest statements, it did not compute. I replaced the code after the END If loop and it worked. 'copy filtered data Set tbl = ActiveSheet.AutoFilter.Range...

below is the full vba code Sub Consolidate_DOR() Dim strListSheet As String, sh As Worksheet, TargetSh As Worksheet Dim DestCell As Range, LastRow As Long, i As Integer, strFileNamePath As String Dim strFileName As String, currentWB As Workbook, dataWB As Workbook, filecount As...

Hi and thanks for the response. Let me clarify because i think i am not clear. From the image below, the user select which months, year, etc. they would like to generate the reports for. The nested if statement works if the user selects the individual months but doesn't work if the user selects...

Thanks Marc. I understand "All Months, 2016 or 2017" is not in the code. I meant to say if the selection is All Months or 2016 or 2017. These are individual selections in a dropdown list. Hope that helps

I am trying to write a nested if statement where a user select a timeframe and then the workbook is filtered based on the timeframe and copied to another workbook. Everything works fine except for some reason if the selection is "All Months, 2016 or 2017", then it skips the section where it...

How would i extract the regions from this path string without using text to column feature. I am needing the formula to extract as: Region 1, Region 2, Region 3 or Region 4 S:\SPandA\Aegis\Clinical\DOR CJR Logs\Reports\Region 3\4063 - DOR CJR Tracking Log.xlsm S:\SPandA\Aegis\Clinical\DOR...

Thank you all for your help. i appreciate it. all work. As far as the countifs, it is not as simple as that. can you please write your formula so we can evaluate. Thanks

Hi all, I have the below solutions i need help with. i have a table structure setup similar to below. I need to know how to count the number of occurences in each stage by the respective person. I know it requires a combination of offest and countif or counta and i am not that savy to do that...

Hi all, please see below i am trying to sumif an hlookup. Column b is the formula and column a is the lookup and rows d1:l10 is the data table any help would be appreciated.

Thank you both for your help

I need a formula that will provide me the trailing 4 quarters based on current quarter. So if we are in Q3-2016, then i need formula that will spit out Q4-2016, Q1-2017, Q2-2017 and Q3-2017. Thanks for your help.

Thank you.