Autofill rows from Master worksheet to other Divisional worksheets in same book

[Wolfpack13]

Not sure if this is possible but - I have a Master worksheet with different division info on it - would like to keep that but also have
separate worksheets for each division and have each division sheet automatically filled in when keyed into the Master worksheet.
Is this possible? It is a really simple Master worksheet with just three columns - probably making this more difficult than it is!
A B C
Nashville 4/22/2013 Get Bob on goal

[Mumps1]

Are the division names listed in column A? Does a sheet for each division already exist or do you want the sheets added automatically based on the division names?

[Wolfpack13]

Yes - A will have the division name, B the date and C the "Goal" - and there are 9 divisions (and I have their separate worksheets) -

[Mumps1]

Place the following code into the code module for Sheet 1 (not into a regular module). This assumes that the division names in column A of Sheet1 correspond exactly to the other worksheet names. After you enter the "Goal" in column C, the data will be copied to the corresponding sheet.

Please Login or Register  to view this content.

[Wolfpack13]

Sorry Mumps1 - hate to be a pain but I did the F11 and pasted the code into it and nothing? Just decent in Excel basics - I'm sure I'm supposed to change something in that code to the separate page names - and will it just automatically activate?

[Mumps1]

Hi Wolfpack. The code has to go into the worksheet code module. You don't have to make any changes to the code. Right click the tab for the worksheet, then click 'View Code' and paste the code into the window that opens up. Close the window. Give it another try and let me know how it works out. If you're still experiencing problems, post a copy of your file and I'll have a look. Remember that the last entry for each division must be in column C. That's what triggers the macro.