PDA

View Full Version : Copy data from one sheet to another based on a certain criteria



shina67
12-28-2016, 04:27 AM
Hi,
Hope someone can help. I have a excel sheet sent to me on a daily basis, this sheet changes daily. I alter this sheet over the course of the working day. I have upload the sheet17912 The following sheet is what it looks like after I have altered things 17911 If the numbers in column F & G on sheet "Book 1" can be found in columns F & G in "Doorsets Open Order" then I need the colour coding copied from "Book 1" to "Doorsets Open Order". The numbers in column F & G will eventually disappear as the order is shipped out to my customer. Basically the sheet "Doorset Open Order" is a sheet with all my outstanding customer orders and sheet "Book 1" is what I save to let myself know where we are as a department with the order.
Hope someone can help as this will save me hours of work everyday transferring data from "Book 1" to "Doorsets Open Order".
Hope I have enplained correctly what I require.

Regards
Sean

p45cal
12-28-2016, 10:33 AM
cross posted without links:
http://www.excelguru.ca/forums/showthread.php?7155-Copy-data-from-one-sheet-to-another-based-on-a-certain-criteria
http://www.mrexcel.com/forum/excel-questions/982649-copy-data-one-sheet-another-based-certain-criteria.html

Anywhere else?