I've been searching around for some macro that can auto populate data based on a search value I enter into a cell with the raw data coming from another sheet. Here's a sample of what my sheet will look like:
ID# (Search Cell) <~User will enter a number here in C2
Cells B3 C3 D3 E3 F3 G3 H3
Statement # ID # Bill Date Rent Amount Late Fee Past Due PMT


I would then want the code to reference back to a sheet named Rental Ledgers and search in column B based on what is entered in cell C2 for statement #, column C for ID#, etc. The sheet should auto generate as many rows as there are data such as the amount of statement #'s for that particular ID#. Can anyone please help??