Autopopulate print tile/print area by locating 2 reference cell locations within an array

[cgtx82]

Question says it all. I cannot figure out how to automatically populate the print area / print tile section by referencing 2 dates.

I’m using pay period dates. Start date is in cell A2 and end date is in cell B2. I need a formula to find these exact dates within column A, then return the row number and auto populate the print tile/print area section within page layout.

This will create the array for the print area. Here is the problem. The row number is dynamic, but the column letters it will print will stay the same always.

It will always print data with columns A-J. The row numbers it prints will be based on the pay period dates.

For instance, if there are 356 rows of data, and the pay period date ranges are located between rows 215-220, I need a formula to locate the row numbers 215-220 by finding the matching dates (date 1 is on row 215 and date 2 is on row 220) and then attach the row number for date 1 to column A, and the row number for date 2 to column J.

Thus, creating the range A215:J220. I need this range auto populated on the print tile/print area section of page layout.

Any ideas how to accomplish this?