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 December 27, 2022 - 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 responses

Answer 1 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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 December 27, 2022 552
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

Similar discussions

Yahoo account reactivation
Senkumba -
kitkat55 -

2 responses
How to specify macro for current active sheet
seo5906 -
Dave -

18 responses
Why can't I bridge connect?
ryno -
Qiqi -

15 responses
AMD data change update new data to DMI
Luis -
dwebb -

1 response