archive

Hi, im pretty new to excel and vba so please bare with me. I want to create an archive workbook where I can keep adding tabs every month for reporting purposes. I only want to copy one particular tab every month from my master workbook into the archive document. This being named as the current...

i am having trouble finding a solution to archiving. i have a excel spreadsheet with columns that have product information and when it was rented out and returned. the list doesn't change just who rents it out and date out and in. i was wondering if there was a way to archive each row when a...

I have an excel worksheet (Sheet 1) thats shows the amount of electricity used over an entire 8 hour shift. The electricity is monitored and updated every 1 min so Sheet 1 also refreshes every min (60 sec) to update to the new electricity usage. Sheet 1 refreshes entirely at the beginning of a...

Hi, Is Access a viable option for archiving small datasheets? I have a subset of data (<100 rows) coming in every week, and I need to archive the data for future reference. My manager insists on using Access, but my gut feeling is that this probably is not the best practice. Any help is...

Hi, I have this code that works fine for majority however the way people access the folder from different offices is causing an issue. Basically if I use the direct path as shown in the code, it doesn't work, so I wondered if there is a way for the code to identify current path and then place...

Hi, I've got this code that allows me to create a backup copy of my workbook however I can't find any code that I can include that will save the copy to defined folder location e.g. "G:\My Documents\Temp\AMP\Archive" I'm sure it's easy but I can't find anything that seems to work with this code...

Hello, I am a long time forum user but have never had to post before (lucky me!). I am reasonably good with excel but have zero macro/programming knowledge. I have a excel sheet that details pricing information for some raw materials. These are updated daily. I would like to schedule this...

Hello, Im wanting to take the entire row of data logged and move it to another sheet called "SR_Archive" after the word "Yes" is selected in the cell. I have 32 rows that span down from A3 to S3, I would like this to be a running archive so each time i select "Yes" it moves the data to the next...

Hi! First time poster and neophyte VBA user. I am attempting to copy and paste a row from worksheet "REGISTER" to the next available row in worksheet "ARCHIVE" whenever "Yes" is recorded in Column O of REGISTER. I have used the following code, taken from another forum, which manages to copy the...

I have a spreadsheet that has data input into it every day to track daily completions and hours of projects. I am looking for a way to be able to archive (I think that's the right term) the data every day at a certain time (say 11pm) so I can come back and see how much of the project was...

Hi all, I have been looking around but i cannot quite find something that fits what i need. Let me explain. I need to copy all rows and data from a table (table1) in a worksheet and paste them at the end of another table (table2) in another worksheet in the same workbook. But i would like the...

I am really new to Macros. I have devised a workbook which I would ideally like to archive a hardcoded version of at a particular time every Monday and to a particular network path. Is this possible to do? I am not sure how to write macro codes and seem to be struggling with finding the...

My work has a very large schedule they work from and is causing opening times of up to 45min for some. I am looking for a macro to archive older rows to a separate workbook on the server based on the "completed date" column. the workbook is xls but some use 2010 office. I am currently using...

The code I have below is a major overkill but It works except there is a couple of bugs. The first is when I run the code, on the last line((Set rngfil = Range("A20,B20,C20,D20,J20,R20,U20"))) it puts in the "-" in the Range of cells, I dont need that. Each line may not always have data in it...

Does anyone no were some post are describing and showing some code examples of how to make a Archive Book ? I have about 15 workbooks that are opened everyday with a material Inventory list. I would like to possibly have a maro that will copy all data and copy it to a main workbook(archive...

Hi All, I've been working on this for while, i'm sure its quite simple for some of you. The challenge is to have a macro which copies a range from an input worksheet and pastes it onto an "archive" worksheet into the appropriate month's column. The size of the range will be standard. I...

Hi, I'd like some assistance to automatically archive a calendar mths worth of data via VBA. In col "A" I have the criteria and from "B" to "AE", in the case of November, the dates. I need to copy and paste "A" to "AE" into a new sheet and then come back and delete the months data, ie "B" to...

Good Morning! I have an upload sheet which contains the following Column A will contain either Y or N, Y if the file is to be copied upon run macro or N, if needs to be ignored Column B - path and file name to be copied Column C - destination path I've been trying to figure out how to code...

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

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". So basically this code, (if that's the best method) "Save as" and enter a random name, perhaps a date as the file name. and open an...