Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-28-2016, 04:31 AM
shina67 shina67 is offline Copy data from one sheet to another based on a certain criteria Windows 8 Copy data from one sheet to another based on a certain criteria Office 2013
Novice
Copy data from one sheet to another based on a certain criteria
 
Join Date: Dec 2016
Posts: 1
shina67 is on a distinguished road
Default Copy data from one sheet to another based on a certain criteria

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
 



Similar Threads
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
Copy data from one sheet to another based on a certain criteria copy cells from a worksheet into other worksheets based on Criteria 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
Copy data from one sheet to another based on a certain criteria Excel VBA Macro - Deleting Specific Data based on criteria MD011 Excel Programming 3 12-10-2014 02:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft