adding worksheets
i devote a worksheet for each employer, listing personal details,
salary addresses,etc, the headings are common, so i fill in the first sheet , then i need to add similar blank worksheets for the rest of the employees. how do i create a macro to automatically add sheets and delete certain cells therein . appreciate your help..thks - sorab |
adding worksheets
First, I find that keeping my data in one worksheet (with additional columns
that indicate key fields) and then splitting it up, much easier than merging worksheets together. In fact, Ron de Bruin has an addin that is made to separate data into other worksheets: http://www.rondebruin.nl/easyfilter.htm But he also has tons of sample code to combine worksheets into one gian worksheet: http://www.rondebruin.nl/copy2.htm sorab wrote: i devote a worksheet for each employer, listing personal details, salary addresses,etc, the headings are common, so i fill in the first sheet , then i need to add similar blank worksheets for the rest of the employees. how do i create a macro to automatically add sheets and delete certain cells therein . appreciate your help..thks - sorab -- Dave Peterson |
All times are GMT +1. The time now is 08:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com