nmccracken12
New Member
- Joined
- Oct 8, 2020
- Messages
- 37
- Office Version
- 365
- Platform
- Windows
Hopefully someone can help me with this.. I have been googling for hours. I have a sheet named Master Import List. I would like to copy only certain cells from this sheet to another inside the workbook based on the cell value. Here is the layout.
Sheet 1 = Master Import List
Sheet 2 = Items to update
Cell Values - in column Z
Done = do not copy to Items to update sheet and if this item is on that sheet remove it. Hopefully that makes sense
Quote = Copy certain cells from Master Import List to Items to update and Highlight that row red. Delete from Items to Update sheet when value changed to DONE
Update = Copy certain cells from Master Import List to Items to update and Highlight that row yellow. Delete from Items to Update sheet when value changed to DONE
Sheet 1 = Master Import List
Sheet 2 = Items to update
Cell Values - in column Z
Done = do not copy to Items to update sheet and if this item is on that sheet remove it. Hopefully that makes sense
Quote = Copy certain cells from Master Import List to Items to update and Highlight that row red. Delete from Items to Update sheet when value changed to DONE
Update = Copy certain cells from Master Import List to Items to update and Highlight that row yellow. Delete from Items to Update sheet when value changed to DONE