archiving

  1. D

    Using a button, move data from one worksheet to another based on a text value ("Closed" or "Archive") in one column.

    I created a trading journal for my investments with data related to planning, monitoring and closing positions. If Closed or if Archive is selected in a Status column, I want to move (copy then delete or cut) the entire row in the "Acct1" worksheet that contains either of those two words AFTER...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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!
  7. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top