Putting a border around a column of text and weekly reconsiliation

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.

I don't know if this extra info might help for part 2, it might explain things better...

Every day I receive a sales report showing customers who have purchased some of our products.

At the end of every week I receive a weekly report. The data in the weekly report must be matched to the data in the daily reports. The only problem is, the weekly report has no order to it and the files are all mixed up. This is making it very difficult and time consuming to match all the entries.

I need a macro/script that looks through the weekly figures worksheet and takes the customer id number and then matches it with the corresponding customer id record in one of the daily worksheets. When it finds the exact matched record, I want the day it was found on, put in the first column of the weekly figures w/sheet in the first column.

e.g if Mr Smith has purchased 2 products (A & B) on Wednesday he will be in Wednesdays daily worksheet, because the weekly worksheet is just a collection of records in no order, he could be at the top, middle or bottom of the list in the weekly worksheet and I would like the value Wednesday returned to the weekly worksheet in the first column. I can then do a count at the end on the all the separate days of the week and make sure the figures match. If they don't I can do further investigation.

Basically I'm trying to exactly match rows in the weekly worksheet with rows in the daily worksheets and when the match has been found the DAY value is returned to the Weekly Figures worksheet in the 1st column.

I can then do a count on the Day figures returned in the weekly w/s and hopefully that will match the records in the daily w/s.
If a match is not found, in the daily worksheets, I would like the value Not Found returned. This way I can investigate why the figures are not in the daily worksheets.

I don't know if this is possible but if an error has occurred in one of the reports and the customer is shown on mutliple worksheets or has duplicate entries can it be possible to return these day figures to ? I don't know if you can return 2 or more results to a cell……..

anyone have any ideas on this ?

does anyone know how I can do a vlookup in a worksheet I have called totals(to match some item id's and customers), that will look through 7 worksheets named Monday to Friday(column B range 1-65536) in the same spreadsheet and return the position of an exactly matching item id, and the worksheet it was found on ?

I have used a basic vlookup and it does give me the row of where the match was found but only if it were in the monday worksheet.....how do I make it look through the rest ?

And if it does not find a match is there a way you can set it so that it states that no item id was found ?

cheers

Ran.