[SOLVED]Help with VBA Macro - Returning Entire Row

Wats up,

I'm trying to return an entire row of data based on the values in one column.

Attached is what I have so far. This is all being done via Button 1.

User is to input a min and max value, which is then searched in Column E. If it is found, the row is to be returned in addition to the adjacent row, which is located above or below it. One row has the date in Column A, and the other row has the time in Column A.

The below code was given to me by jaslake, but currently all it does is put an asterisk next to the two rows.

Please Login or Register  to view this content.

The code actually checks to see if the row has a DATE or TIME in column A. The DATE is always in the first row and the TIME is always in the 2nd row. Based on Column A (After column E is searched), it determines which is the adjacent row.

Now I just need the data for both rows to be extracted to Sheet 2, each value receiving its own column.

Ex:
A B C D
2-6 Wed 3:00 2a 8
2-6 Wed 3:00 2b 9

*Adjacent rows share the same date and time.

Thanks for reading and for the help if possible.

Hi BamBam,

Try this:

Please Login or Register  to view this content.

Hello BamBamMoneyBags,

This revision of the macro will copy the rows to "Sheet2" column "A:D". The macro has been added to the attached workbook.

Please Login or Register  to view this content.