Hello all!
I am working on a file that needs to auto update (or by button push) multiple worksheets based on a cells value. For example: If, in Sheet1 Cell B2 has an "X" then Cell A2 needs to copy to Sheet2. If Cell B3 and C3 have an "X" the Cell A3 needs to copy to Sheet2 and Sheet3.
I have worked out a macro that copies the rows based on cell value but I only need the cells in Column A not the entire row.
Capture.PNG
Any help would be greatly appreciated!
Bookmarks