RangeToTable Dynamic dataRange

[AJ Langa]

Hi,

Does anyone know how to make the dataRange in the RangeToTable function dynamic depending on how many entries / rows are in the data?  For instance, if I am trying to send out a RangeToTable of a form that was filled out 5 times this month, but next month it's filled out 50 times, then I don't want to see a bunch of blank rows on the months that it is filled out less often.  I've tried to reference a cell that Joins the initial part of the dataRange info with a 2nd cell that counts the number of entries into the data, but the RangeToTable function does not acknowledge that this is an appropriate dataRange. An example would of this Join function would be =Join("", 'Last Month Data'!A3:I, 6) - I used this to try and mimic the count function assuming that there were only 4 entries (rows 3 through 6), but again the RangeToTable function doesn't like this.

Any thoughts?

Thanks,

AJ

[Joseph Schmidt]

See sheet3 for an example of using a filter.  

=RANGETOTABLE(FILTER('Sample Book Order Data'!A:I,'Sample Book Order Data'!A:A=A2),'Sample Book Order Data'!$A$1:$I$1) 

example of range to table with a filter. 

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

--
You received this message because you are subscribed to the Google Groups "NV Form Mule Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-form-mule-ad...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/905cc84f-a523-420b-8cad-cfcea3b6e494%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[AJ Langa]

Thanks Joe!  That worked perfectly.

Thanks,

AJ

You received this message because you are subscribed to a topic in the Google Groups "NV Form Mule Add-on" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/nv-form-mule-add-on/9vUC0S9oAxw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to nv-form-mule-ad...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/CAPWPTORad3tY0hTpUqnom0e-on%3DLQjertrvSnHD0eYdj5ETAaQ%40mail.gmail.com.