Huge sheet into smaller sheets
Hi,
In my workbook, I must have as many sheets as there are days in a month. In each sheet I have about 20 tables filled with different types of data: text, dates, currency, etc. The entire workbook then contains a month of daily data. Every time I add a row/column, I split other tables on the same sheet. The guy before me liked absolute references, so you can imagine it's a nightmare to deal with. Can anyone think of a way to optimize this ordeal? Ideally, I want each table on a separate sheet, but then I'd have to save the whole workbook as one day, and create a new workbook every day - ****er. Thanks, Mia |
All times are GMT +1. The time now is 02:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com