archiving

  1. P

    Need some suggestions about archiving data

    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...
  2. A

    Macro for 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...
  3. Lampshade54321

    Archive linked workbooks with links intact

    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...
  4. A

    auto archiving excel doc

    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...
  5. H

    Archiving Help? :D

    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!
  6. R

    Stock Control/Data Archiving

    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...

Some videos you may like

This Week's Hot Topics

Top