Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
program new worksheet
I have a workbook with Weekly sales linked to another workbook Monthl
sales . When i get a new month i have to insert new worksheet for tha month then link it is there anyway this can be done with a macro . any help would be great thanks Phi Attachment filename: 3651h_weeklysales.xls Download attachment: http://www.excelforum.com/attachment.php?postid=55934 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
program new worksheet
Hi,
Why don't you just setup the monthly workbook with all the months and the weekly sales should be setup with a sheet per week. A macro then can add the weekly sales to each months sheets then a totals sheets canthen collate the information gathered. I have a utility that can add sheets and rename them anything you want. Having to rename sheets week1, week2, etc to week52 can be a chore. Download it from http://au.geocities.com/excelmarksway If you would like me to create a utility that does all the work, then send dummy info.xls (up to 1mb) to Yes it's free. regards mark -----Original Message----- I have a workbook with Weekly sales linked to another workbook Monthly sales . When i get a new month i have to insert new worksheet for that month then link it is there anyway this can be done with a macro . any help would be great thanks Phil Attachment filename: 3651h_weeklysales.xls Download attachment: http://www.excelforum.com/attachment.php?postid=559340 --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro orVB Program to email a worksheet | Excel Discussion (Misc queries) | |||
In Office 2003 program worksheet can't be renamed due to .xls add. | Excel Discussion (Misc queries) | |||
How can I paste worksheet to an other program through a HYPERLINK | Excel Discussion (Misc queries) | |||
How can I paste a worksheet to an other program through a HYPERLIN | Excel Worksheet Functions | |||
Unable to edit a worksheet from an OLE program | Excel Discussion (Misc queries) |