Create new worksheet with data

Closed
romiljpr - 20 Dec 2011 à 07:24
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 22 Dec 2011 à 09:37
Hello,

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.

2 responses

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
20 Dec 2011 à 09:31
Hi Romiljpr,

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.

Best regards,
Trowa
http://speedy.sh/mpuQt/demo-file-by-romil.xlsx
uploaded ..... pls check
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
22 Dec 2011 à 09:37
Hi romiljpr,

Forgot to mention that I'm using excel 2003. Could you resave your file as .xls and reupload it.

Sorry for the inconvenience.

Best regards,
Trowa