I am trying to Create a Macro that will find a specific word in a column (on active TCP BOARD spreadsheet) and copy that word and associated cells (about 10 additional cells in the same row - both to the left and to the right of the the "trigger" word) to a seperate sheet- BILLED. The sheet (ACTIVE TCP BOARD) that the data is originally input to will be changed, and the data input will be removed eventually. The sperate sheet BILLED needs to be an ongoing list, that compiles and keeps the data that was mined. This list will only get larger as time passes.
I PLAN SCHEDULE TEST.xls
I have attached my workbook, Currently I have three spreadsheets ACTIVE TCP BOARD (ATB), BILLED, SHEET 3. ATB is the place where my data is input, changes are made and ultimately the inputs are discarded. Billed is where I would like my historical list to to be compiled and kept (this will be a protected sheet) The list will take the inputs as the status changes the status will always change in this sequence, NOTES, OFA, APPROVED, BILLED. Once the data is moved to this sheet the data will be removed from ATB.
Specifically, ATB column I, once the status becomes billed i need the infomration from the same row (COlumns C-L) to be copied to billed spreadsheet. This spread sheet needs to be able to keep the data (This will become a historical list). SHEET 3 is a shet that contains a bunch of conditional formatting that is necessary but can be transferred to ATB, since the information is redundant.
I am not sure if what i would like to do is even possible. But i do greatly appreciate and and all information/help.