Create new worksheet with data [Closed]

Report
-
Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
-
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

Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
462
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
Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
462
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!