![]() |
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. |
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. |
All times are GMT +1. The time now is 01:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com