Create rows from Excel file

Hi All,
I'm trying to make a report that creates rows based on Emp #s that are on a seperate tab in the my workbook. Currently, I have the formulas pasted down far past the number of Emp #s so that as Emp #s are added to the other tab the data I need will pull in. I've heard this can be done by creating an array. Any advice would be appreciated.

Thank you!!!

Example:
Column A = Emp #'s…..Colunm B= Hire Date (pulled in using jet)
Row 1= 006236…………………………6/1/2013
Row 2= 006237…………………………6/1/2013
Row 3= 006238…………………………6/1/2013
Row 4= 006239…………………………6/1/2013
Row 5= (blank)…………………………1/0/1900

Jet Reports Historic Posts July 20, 2013 11:46

Using NL("Rows";A1:A6) should do the trick.
Any worksheet range can be used as the table argument.

rmw

Jet Reports Historic Posts July 23, 2013 15:10

Thanks for your response. I didn't have any luck. Once I input A1:I1 in the table filed I either receive an error from jet or my excel freezes.

Create rows from Excel file

2 comments