Search results

Nevermind there must be a left over corruption of value/formula in my original duMmy WB.... Used your code there and was receiving missing clinic... downloaded the one you graciously modified and checked... EVERYTHING WORKS! :-)

Sorry, I am not getting results from all the WS, when I was looking at the code it was only in the first cell, I'm examining the code where it stops adding values from other WS, so I can see where it deviates.

I was afraid it would be a long one... I tend to get lost in the code... miss a ")" or a comma... If you can follow along below.... It is easier to run the reports by month, related to the auto highlighting of what has changed in each cell or clinic added when the shared WB is merged. If you...

Good catch, that WS is from a different WB. The dynamic tables are draw from the 'Details' WS.. Either way, the original problem exist. I can not copy all of the information from the dynamic tables listed on the 'Follow up' WS. Only what is visible. Thanks again

Sorry, I didn't solve it... still working on a solution... it's a slid a bit down on my priority list... Thanks for your assist

Thanks, it works! A tweak if I may... upon showing this to one other person who would be using the shared book... It will be easier if I copy all the clinic info from all WSheets onto the 'Schedule' WS. Can the code be adjusted to gather all the clinic ID's from all the WS, The other fields I...

Thanks for replying... sirjb7 You are correct. What I was attempting to do is copy all the information from the scrollable tables. Table6 contains 37 records with only 10 showing. when I use the macro it only saves the 10 visible rows in table 6.

This code is designed to search multiple worksheets and display the clinic ID number based on a dropdown box (cell B2) value the user selects... If they select 'June' then it will search WSheets 'June', and 'JuneFlu' Code (vb)...

Lets try another approach..... This code is designed to search multiple worksheets and display the clinic ID number based on a dropdown box (cell B2) value the user selects... If they select 'June' then...

Designing a workbook to schedule staff to 2 different types of clinics, clinic parameters (date, time in, time out, number of staff required) update frequently. The clinic schedules are generated by a corp sales team, I can run a query and export into excel, it contains columns/data that aren't...

So I have been busting my brain to find a work-around... Haven't found it yet... I attempted to store the array as an object or string, so it would copy to the clipboard, and be accessible to 'ctrl + V' for other applications... no go What I don't understand is; The info is already on the...

Yes I have seen and read and used... Chandoo save range as text VBA I have been using this method however, it provides me with different options. Here is the code Sub ExportRangetoFile() 'Update 20130913 Dim wb As Workbook Dim saveFile As String Dim WorkRng As Range On Error Resume Next...

quick look, yes absolutely! Thanks! I may need a decoder ring though...I will not have time to dig into it until later... Is the [#All] a regular built in function? I don't think I have seen it used before. I ran through a quick evaluation of the code, I don't think I would have come to that...

worksheet 'calculations', In column 'W' I want to check the table on WS 'training details' tbl 'emp_detail' for criteria (basic mod completed>0,LTV mod completed>0, Comped="") and they must be active - WS 'Details' tbl "Employees'. I was using the Index(Match()) so the information/values in the...

Sorry for the delayed response... I haven't had a lot of time to test out the last adjustments, but it looks promising... Thank you for taking the time to assist with this adventure in formulas'

Forgive me but am I missing something?? It still shows all the records. The summary you provided is correct and the conditional for mating on the training details table... but the table created on the 'Follow up' sheet continues to display all the records, and scroll through them. I am...

Thanks I have modified the formula in Follow Up column in 'Training Details' to better capture which records I wish to display.. =IF(AND(([@ID]>0),([@[Basics Mod Completed]]>0),OR([@[LTV Mod completed]]>0)),FALSE,TRUE) But I still cannot adjust the list formulas in the 'Follow up' sheet. It...

Thanks for your help. I have a few questions if you please... The COUNTIFS is looking for ID >1 and BASICS MOD with no date and LTV MOD with no date... correct? The logic test of the SMALL function is searching for the same thing? I think so even though it is displaying rows with dates and no...

Hello everyone and thanks in advance. I have been receiving some assistance from eibi, thanks again... on worksheet 'Follow up' I am attempting to create a scrollable list. The first example is with offset, which simply copies everything. My attempt to create it based on criteria is below it. I...

Complete noob here... something to aspire to!