archived

  1. M

    Row archived, moves it to another tab

    Someone has asked if the following is possible; - Rows of data in excel - when a row is "archived" it moves that row to another "archived" tab, below existing data - the "archived" tab therefore grows as rows move across over time - the original now-blank rows get deleted They initially...
  2. Y

    macro to archive unused sheets

    I have a workbook that is updated in ~30-90 feet intervals, over a period of 10,000 feet. The workbook becomes quite large and ideally I would like to have a macro to archive all but the 5 left most tabs, hidden sheets, and the first sheet in the workbook named Logs. Would it be possible when...
  3. sharky12345

    Delete entire row if cell value is equal to

    Can someone show me how to delete an entire row if a Cell.Offset value is equal to a specific value? I have this so far but don't know what else I need to specify the row number; If cell.Offset(0, 10).Value = "Archived" Then
  4. K

    PLEASE HELP... trying to move a row to a archived sheet when a certain cell is marked YES and delete it from the main sheet once moved

    :confused: I really need help with this, I have tried for 3 days now and cannot figure it out. :mad: I have a spreadsheet named "Regular Call Backs" which contains several rows of data (A-O) I need to move a entire row to "Archived" sheet when column O is marked YES. I also need to delete the...
  5. D

    Create a unique dynamic List on separate worksheet (based on CF)

    I have a list of all our projects (they run as sequential numbers 0100 to 9999) in column A. In column B I enter the same project number when it has been archived and in Column C I have a formula which subtracts B from A - the answer is 0 when the 2 numbers match (I just use this as a check so...

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