By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,824 Members | 2,410 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,824 IT Pros & Developers. It's quick & easy.

Find several data from one excel file in another one and highlight cells

P: 1
Hi all,

I need to create a macro to get specific data from column A, from excel file "A" and find that value in another excel file "B" and fill that cell with a blue colour. The values on column A from File "A" are picking storage locations and the file B is a visual representation of the Warehouse plan with its locations. The idea is to have a picking location list (File A)and with the macro fill with colour the locations on File B that are listed on file A.

Appreciate your help,
Jan 2 '14 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,397
1) Don't do that with two seperate files if possible, instead use a new worksheet within the same file.

2) IN the same file use conditional formating on the cell in question. IF you must refer to another workbook then the cell reference can include the entire qualified path to the dataworkbook.
Jan 2 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.