How Do I Copy a Row to Another Sheet in Workbook Based on a Value in Column?
I've looked at the Google machine and have not found an answer to my situation.
Situation: I have a master sheet (source sheet) that is used for tracking ordering information (date of order, date shipped, sequential order number, number of items, and the item code). This sheet is cleared every year and the order numbers restart at 1. The other sheets in the workbook are the tabs for each item code (target sheets) where I track the ordering information for that item. Those tabs are used to track over multiple years.
Goal: Copy data in source sheet row from columns C,D,E,F,H,I,J,K to the item code sheet (target sheet) if column G contains the item code. I would like it to search all of the source sheet so that if a line in the source sheet gets added above the last line, it pulls it into the target sheet, but I would like to avoid it pasting duplicate lines if possible. I would also like it to not erase what was copied to the target sheet once the source sheet is restarted at the beginning of the year. Does anyone know if this is possible?
I tried using =filter, but that erased the data when the source sheet was erased and it would be a lot of work to copy and paste as text everything in each target sheet before restarting the source sheet. I then tried a VBA script for each target sheet, but it only copied the last line of the relevant source, which was not helpful when there is prior info already logged. Example of what my workbook is like
[link] [comments]
Want to read more?
Check out the full article on the original site