I am a newbie in areas of the macro and VBA. But I am comfortable with
the normal formulas used in excel.

The problem :

I am getting the report from all the area offices every week. and I do
not have any control over the format they are using. These reports are
in a central compiled sheet where all the offices are adding a raw
every day with date and other data (32 columns) which makes the sheet
with around 1800 raws of data as of now. I need to saperate and copy
the records (raws) of all the offices in another sheet every week.
Presently I am doing it with the auto filter and copy , paste in new
sheet and then renaming the sheet with the office name. There are 48
area offices for which I have to make 48 different sheet in the work
book in addition of the original sheet. This is a time consuming and
very tedius method.

I am sure there must be some other ways easy and time efficient in
terms of a macro or VB Code. Request help from the group please.

Thaks in advance.
shetty