Previous Topic Next Topic

Create new worksheet with data

Closed
romiljpr - Dec 20, 2011 at 07:24 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Dec 22, 2011 at 09:37 AM
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 replies

Answer 1 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 545
Dec 20, 2011 at 09:31 AM
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
0
Answer 2 / 2
romiljpr
Dec 21, 2011 at 03:43 AM
http://speedy.sh/mpuQt/demo-file-by-romil.xlsx
uploaded ..... pls check
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 545
Dec 22, 2011 at 09:37 AM
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
0