Hello,

I have two questions that I need to ask and I really need help with them

1) I import data into a template worksheet every morning. Column F contains hyperlinks, so when I remove them the border disapears to.

Is there a way that I can code it so that it looks down column F, and puts a border around any cell that contains a value.

2) I have to reconsile weekly results - I have 7 work sheets - 1st one is called Totals and contains all the weekly data and the other 6 are Monday throught to Saturday (no work is done on a Sunday) containing daily data. All the sheets have the same headings and column widths. Each sheet has a customer and item id and other details. I want to insert a new column in the weekly worksheet and create a macro that will check each item id in the weekly worksheet, and it will check the other 6 worksheets and when it finds the unique customer id it returns the worksheet as the value it found it in....

e.g So If it checked the first customer id and it matched in Tuesday's worksheet, it would return Tuesday as the value.....

I hope this is possible.....also, would it be possible that if it couldnt match the customer id data in the weekly worksheet against any in the daily worksheets that it returns a value of not found........

I would really appreciate every bit of help I get with these problems.....

Thanks in advance

Ran.