Hi!

I am quite new to writing macros, so go easy with me. I get data that shows number of calls to a particular line during one week from a server, but the lines that receive the calls are never in the same position as the previous week, so I need to sort them out. Here are what I want to do:

1. Copy data from the server to work sheet "Sheet1". This is done manually and has to overwrite the previous week's data.
2. In another work sheet "raw_data", I want to display all the data according to the line and week. I have created a hlookup:

Please Login or Register  to view this content.
Where column A in both work sheets display the date and the lines are shown in row 1 starting in column B.

I have a button in raw_data with a macro that, when clicked, adds the next date in the sequence. All I need to do now is get a permanent copy of the data now.

Can anybody help?

Many thanks!!