Hi Ninerref,
Of couse this is possible:
In the VBA editor double click on the sheet name you are using (not the
ordinary modules) to open the private module for that sheet,
Click the left hand top dropdown box and select worksheet.
The shell for a macro called Worksheet_Selection Change(ByVal Target As
Range) is automatically generated by default.

Insert inside code which includes :
If Target.address is "$A$1" Then
(or whatever your cell is) then copy and paste to your two locations
Use for .. next to loop through your range of cells

hope this helps.

"Ninerref" wrote:

I am currently creating an excel based estimating software and have
hit a brick wall.

Two-Fold Problem:
My current database format utilizes drop down items under each
estimate sub-item.

First I want to be able to, once an item is selected, have another
line automatically self-insert in the next row with the same drop down
list from the previous line.

Secondly, as an item is selected I also want to have the selected item
copied over to anoth existing worksheet. I am not sure if this needs
to be a pivot table or what because there needs to be some logic to
where it shows up on the second worksheet.

Any and all help would be greatly appreciated. Or if this is just not
possible then a slap on the hand for posting this may be needed.