This should be possible, but your post is a little vague to answer completely.

-How can you tell which of the 5 region sheets needs populating once the
division sheet is populated- is there a particular cell on the Division sheet
with this information?
- How are the individual region sheets identified- are the sheet tab names
e.g. North, South etc.?

The easiest solution may be to make a new copy of the entire Division sheet
once it has been populated, then rename it for the appropriate region-
something like this:
Thisworkbook.Sheets("Division").Copy
after:=ActiveWorkbook.Sheets(ActiveWorkbook.Sheets .Count)
ActiveSheet.Name = "South Region"

It may also be useful to post the relevant bits of your existing code as well.

Cheers,
Dave

"M3Cobb" wrote:


I have a sheet ("Division") that is fed by a macro on an application
form. The user hits the macro button and the "Division" sheet is
populated. However, I need this to then feed 5 other sheets depending
on the geographical Region . Is there anyway of either getting the
macro to populate the main "Division" sheet and simultaneously one of
the geopgraphical regions, or Getting the Division sheet to feed the
regions sheet.

I'll post the code I've already got for populating the "division" if
that helps.

Thanks


--
M3Cobb
------------------------------------------------------------------------
M3Cobb's Profile: http://www.excelforum.com/member.php...o&userid=24986
View this thread: http://www.excelforum.com/showthread...hreadid=385172