archiving

Hey guys I was wondering if I could get some suggestions or opinions on the best way to do this. Currently I have some code written that archives all data from the day's work into another workbook. These workbooks are only used to store old data. I'm thinking about changing the way I'm archiving...

Dear Excel Community, Suppose I have a table that looks like this, whereby column B contains the months, columns C & E contains specific values. Above Column B there will be a date function that captures the dates daily. <colgroup><col><col span="3"></colgroup><tbody> Column B Column C...

This issue relates to automating with VBA code the archiving of upto 40 linked workbooks whilst maintaining the integrity of the workbook links.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I manage a large project and have six cell teams...

I am working on a multi-sheet workbook that captures data over a one year span. After the new year I would like a script that backs-up the current workbook, saving it with a specific file format, something like: "string cell reference"," ","old year". The tricky part is when it is finished...

Hello, i want to know how it is possible to have an automated routine that will archive the workbook and will create a new workbook ready for entering the new data. Any method of doing this would be greatly appreciated! Thanks!

Ok. I am using Excel 2007, and am currently compiling an invoice system for my business. I have an invoice on which the user enters the list of stock numbers of items being purchased in one column (which trigger information about the items to be displayed through v-lookups) and a second column...