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...
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...
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)...
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:
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.
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...
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...
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...
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!
: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...
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...
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...
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...
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...
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...
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"...
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...
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...
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...
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 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.