archive

  1. P

    Simple macro to shift updates to an archived cell

    I have a worksheet with 2 columns. Column 1 is Latest update. Column 2 is Archive update. I want to write a macro that would detect the cell I've selected, copy its contents, and paste it into the top of the archived update cell. BEFORE: CELL A1 CELL B1 Update 5 Update 4...
  2. C

    Archive from a table

    Hi, I want to archive some items which are in a table when I set their status to "complete". In my test workbook it orks fine using this code. Private Sub Worksheet_Change(ByVal Target As Range) Dim Changed As Range Const YesCols As String = "M" '<- Your 'completed' columns...
  3. R

    Transferring data from one sheet to another based on cell drop down at the end of any given row.

    I am currently looking over some code that was created by a staff member that has now left. The code is basic and works okay for what we need, however, there is one piece I would like to add in but cannot work out how do it. Private Sub Worksheet_Change(ByVal Target As Range)...
  4. W

    Please help!! Formula crisis!!

    Hi guys, I have set of Data which contains 91 lines, I want to group them into 6 groups but I only want 2 items from the same category to go into each group. Can someone help me archive this? Many thanks, Wazza:confused::confused:
  5. W

    Group Data into Piles

    Hi guys, I have set of Data which contains 91 lines, I want to group them into 6 groups but I only want 2 items from the same category to go into each group. Can someone help me archive this? Many thanks, Wazza.
  6. E

    Copy data to archive

    Hello. I need help. I have a file named ARCHIVE. It has only headers. I need a VBA script to copy contents of another workbooks to Archive ranged "B2" to Lastrow "Z" and it should be inserted to next free row in Archive. Couple ppl will work on some files and at the end they should add...
  7. H

    VBA cannot move this file to a folder. Weirdness

    I have a process that is processing and then moving about 60 files to an archive. For some reason this one file cannot be moved. The files name is: (very long I know, can't help it) 1 2 2018 - xOpen Line Report for y and AVOCENT Product POs RMAs as of 01 02 2018 - x Backlog Report as of...
  8. F

    VBA creating an Archive

    Hi guys, I am trying to create an archive tab for my data using VBA. The aim is each day when I run this code the rows with "Daily" in the Archive column copy over to the Archive tab. Archive "Monthly" would copy over only one a month e.g. on the last working day of the month. Data Sheet...
  9. F

    Moving data from Excel to Access

    Hi guys, I have created an "Archive" sheet which will hold 60 rows per day. The sheet is likely to get very big very quickly so I'm considering using Access DB as a way of storing the data. Is there a neat automated way of moving the archive data into an Access DB e.g. VBA? Thanks!
  10. K

    Help with sorting rows by date and moving to archive sheet when cell marked "yes"

    :eeek::confused:Hello! I have a spreadsheet I am working on from work with will contain lost of rows of data and users will continue to add to it daily. I am needing the rows to sort by date oldest to newest on both the "regular Call Backs" and the "Escalation Call Backs" sheets. I currently...
  11. X

    moving duplicates to a new tab

    I am wanting to create an archive sheet where old records (full row) needs to be added. I have a list of invoices which can contain duplication based on a product number, the only unique reference is the date. What I am trying to do is to move all duplicate entries with the exception of the...
  12. K

    Solution for archiving invoices

    Hi guys and girls! I am a kind of a self taught newbie to excel. I created an excel worksheet to help me work with my invoices that looks (and works) pretty cool. However i need help creating an archive sheet that will include all the data from every invoice i issue. I would need a button to...
  13. D

    Problem with filepath

    I have created a tool which generates letters from a userform. The structure of my directory is app main folder and within this there is two folders one called templates and one called archive and the main xlsm file is there to. I am trying to create the filepaths so that no matter where the...
  14. D

    Setting up an archive (VBA)

    Hey guys, I've been trying to set up an archive where you enter in values on Sheet 1 and then press the button so that it moves it into Sheet 2. All existing rows with their stored data in Sheet 2 would move down one to accommodate what was entered on Sheet 1. Here's the snippet I cooked up for...
  15. B

    Archive file if filename does not exist

    Each week I load CSV data into my Workbook from a USB stick. I have recently chosen to archive the CSV file with the date that the data is accessed. The source file, no matter what the date, is always the same name. I can successfully archive the CSV using this statement: ActiveWorkbook.SaveAs...
  16. N

    Help with IF Statements...

    Hi All, Please could you help - I have got myself in a muddle with my IF statements. In cell A1 I have an end date. If the date in A1 is more than 21 days ago from today then I was B1 to return "Archive". If A1 is blank I want it to leave cell B1 blank. Eg: A1 17/11/2017 B1 "blank"...
  17. 2

    Macro to archive and delete data question

    Hello, As many other posts I am a beginner and not sure where to start. I have a spreadsheet for process pH values that is setup as follows: <colgroup><col><col span="4"></colgroup><tbody> Date 8/1/2017 8/2/2017 8/3/2017 8/4/2017 PH PH PH PH PH Sump1 7.85 7.52 7.46 7.38 Sump2 7.54...
  18. J

    Copy and paste row to closed workbook

    I want to be able to select a row and copy & paste it (With a command button) to a closed workbook that remains closed. The code below copies everything below a range. I just want to copy the row I have selected. These are the lines that need to be changed: With...
  19. S

    Archive data from one worksheet to another based on the value of a cell using a macro linked button.

    I have a database for recruitment within my company. There are four outcomes based on a person's application, attested, deferred, not interested and rejected. Candidate information is written from cells a5 to s5, the last column, t5 is "archive status", once a candidate has reached one of the...
  20. M

    Archive Macro That I can Assign to a button

    I am not very good with Macro and have been trying to use the record macro and then edit for a selectable range to create an archive button that I can then select my row. What I want to do is hit an archive button that will archive a row that I select from the active sheet to my "archive" sheet...

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