![]() |
#1
|
|||
|
|||
![]()
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 sheet to the following link https://www.dropbox.com/s/zrmcxnbey5...rder.xlsx?dl=0. The following sheet is what it looks like after I have altered things https://www.dropbox.com/s/risd3d4bbh...%201.xlsx?dl=0. 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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Want to return a value from my pricing table into my raw data sheet given criteria in the data sheet | mcronin | Excel | 1 | 05-09-2016 09:43 AM |
![]() |
Elton Wolter | Excel Programming | 4 | 04-16-2016 08:44 AM |
a macro that can copy data from copy.xls to our current excel macro.xls based on criteria: | udhaya | Excel Programming | 1 | 11-12-2015 10:12 AM |
need VBA to Transpose the Data from excel to word based on given criteria(status) | winmaxservices2 | Excel Programming | 1 | 12-19-2014 10:21 PM |
![]() |
MD011 | Excel Programming | 3 | 12-10-2014 02:15 AM |