Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add Names of First Sheet and Automatically Add to Second Sheet
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying information (contained in defined names) on a summary sheet, in different row numbers? | Excel Discussion (Misc queries) | |||
automatically making a copy of a sheet | Excel Worksheet Functions | |||
can entered data in sheet 1 be automatically pasted in sheet 2 | Excel Discussion (Misc queries) | |||
how do i set up a list of names on a sheet frm various sheets in e | Excel Discussion (Misc queries) | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions |