i have created a workbook, that contains my home income and expenditures. it contain for every month, i want, it create a new worksheet for next month and copy all formats including cell reference e.g., balance forward amount to carried forward... (value of cell A1 to next sheet in cell which is defined). please help.
Could you upload (a sample of) your workbook to a filesharing site like www.speedyshare.com and post back the link.
Then explain which data to keep and which to clear, basicly to show how it is now and how you foresee it.