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,
Bookmarks