View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Add Names of First Sheet and Automatically Add to Second Sheet

Just select all the desired sheets before adding. It will be added to the
SAME cell in each sheet. Or, create a macro to do it for you in the next
available row of each sheet.

--
Don Guillett
SalesAid Software

"Jorge" wrote in message
...
I am trying to create a Workbook to contain Names and Amounts donanated for
a
year. I have to keep a Sheet to represent every month of the year. And at
the
end on the year make a combined total. The problem I am coming into is if
I
Add a New Customer in February and continue to use the same customer name.
I
have to add it everytime to the next Sheet. I want to be able to
automatically add it to one sheet and then add it to the remaing sheets in
the workbook. Can this happen.

Thanks in Advance for the input.