Hi,

I am new to this and fairly seasoned with coding and macros in Access and Excel. I have a database that is in an excel spreadsheet. I am running a macro to create a report as simple and fast as possible.

I have a few different columns and I am looking for a macro or code to copy and create a table for data.

Basically what I want is if the data in columns L, O, R, U, X, AA, AD, AG, AJ contain the value "Concern" then copy and past the the column H and two fields that follow, into a new cell.

Example: If say L2 has the work "concern" in it, then we want to copy H2, M2, and N2 into a seperate area of the table, or even a seperate sheet would be ok.

If you have any suggetions or assistance with this it would be great.

Also, if it is code, I need to be able to run it from a macro if possible.

Thanks,