Add specific column data to a sheet
I have seven (7) sheets that track dates for activities in our facilities. Not all seven sheets have the exact same columns but they all have certain columns that I would like to consolidate onto a master sheet for reporting and metrics. The copy row automation, as you already know, copies the data for all of the columns. Based on the status change of a particular column I want to copy only a few of the columns into a single sheet as a new row in that sheet. How can this be done if there is nothing to do an index match on.
When the Status = Shipped copy the required columns and dates to a new sheet
Screen shot 1 is the source that has more columns than I need in the destination sheet
Screen shot 2 is the destination sheet I want to copy data to
Help Article Resources
Check out the Formula Handbook template!