Auto-logging worksheets

I am currently using the below formula to auto save invoices for review
Is there a way that as these accumulate (there are many), that 
spreadsheet could log them? I still want them to archive, but i want 
report to be generated on a single sheet daily. Here is the formula 
am using for the archiving:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
ActiveWorkbook.SaveAs FileName:="J:\builders choice completed\" 
ActiveSheet.Range("a9")
End Sub

Thanks in advance, Vato

--
Message posted from http://www.ExcelForum.com

0
8/24/2004 2:52:25 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
598 Views

Similar Articles

[PageSpeed] 3

Maybe you could copy and paste special|Values to a different worksheet (in a
different workbook)--just the cells that are worth saving.



"Vato Loco <" wrote:
> 
> I am currently using the below formula to auto save invoices for review.
> Is there a way that as these accumulate (there are many), that a
> spreadsheet could log them? I still want them to archive, but i want a
> report to be generated on a single sheet daily. Here is the formula I
> am using for the archiving:
> 
> Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
> ActiveWorkbook.SaveAs FileName:="J:\builders choice completed\" &
> ActiveSheet.Range("a9")
> End Sub
> 
> Thanks in advance, Vato.
> 
> ---
> Message posted from http://www.ExcelForum.com/

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
8/24/2004 10:29:51 PM
Reply:

Similar Artilces:

naming a worksheet
i want to control how the sheets are named, for instance how do i ensur that when i click on Insert Worksheet i will get a worksheet with le us say the name 'Prapti' instead of Sheet1,Sheet2 etc. Also can i change the last nos of the sheet, for instance if i creat Sheet3 and then delete it , the next sheet is created with the no Sheet4 and not Sheet3, how can i change tha -- Message posted from http://www.ExcelForum.com Try something like: Sub NameNewSheet() Dim sName As String Dim wTemp As Worksheet Sheets.Add.Name = "wTemp" sName = InputBox("Name of new s...

Rename the worksheet
Is there a possibility to rename the worksheet without using the mouse-rename procedure? I mean using the keyboard only??? Thanks. -- praveen_khm ------------------------------------------------------------------------ praveen_khm's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30364 View this thread: http://www.excelforum.com/showthread.php?threadid=502191 Dear Praveen, Use Alt+O+H+R to rename the worksheet. Regards, Selvarathinam. praveen_khm wrote: > Is there a possibility to rename the worksheet without using the > mouse-rename procedure? I me...

Change background / color of chart worksheet?
Need steps to change the color or backgound of the worksheet that is a chart. Have multiple tabs in workbook that are just the charts. Only option for background is to use Format-Sheet-Background. That changes background of chart, but not the grey areas around the chart on the chart tab. You need to select the Chart Area (what you call the, "grey areas around the chart") and format that. There are 2 separate, "parts" to a chart:- 1. The Plot Area (which you seem to have formatted OK) and the 2. Chart Area. You need to select each of them to format th...

Help with auto height of rows
Hello, I've got Excel 2002. Spreadsheet has over 3400 rows and 6 columns. No merged cells. All fonts are Arial size 10. The first 1809 rows are set to a height of '15.00 (20 pixels)' and the remaining rows are set to '12.75 (17 pixels)'. I've tried selecting all rows and then double clicking on a divider bar to get them all to adjust to auto height, but they stay at the heights listed. I want them all to be at the 12.75 (17 pixels) height when you do the auto height adjustment. Why won't this work on this spreadsheet? Thanks. Mark Nevermind - I fig...

Server-Wide Auto-Reply / Address Change Notice
We are in the process of changing domains as far as email/web addresses are concerned and I wonder if it would be possible to have Exchange reply for each user with a message stating something like, "This is an automated reply letting you know that the email address for User Smith is now usmith@fakedomain.org." I realize that each user could create a rule in Outlook... but we would need the rules to apply for a long period of time and that could be very annoying for senders... getting hit with constant auto-replies. Even if it would be possible for a user to create a rule th...

Auto Filling Fields in Current Record from Previous Record
Hello, I have looked through posts related to Auto-Filling a field from a previous record but am still a little unsure of how to do things. What I would like to do is auto fill a field in the current record with one from a different field in a previous record. What I have is a form that records "engine hours" and "tonnes moved" for a piece of equipment. The operator will record the staring hours and tonnes (at the start of a day) and the hours and tonnes at the end of the day. So in the database, I would like the "Starting Hours" and "Starting Tonnes"...

Moving Exchange logs and database
I am attempting to move the log and database files for Exchange 2003. I have followed all the steps listed here: http://support.microsoft.com/?kbid=821915 However, the log files are still being written to the old log folder. Are there any subsequent steps that need to be followed? Is it just a matter of waiting? Thank you for your help, Nick Are you sure you're looking at the right logs? Did you make the change for all storage groups? -- Ed Crowley MVP - Exchange "Protecting the world from PSTs and brick backups!" <nicenick@gmail.com> wrote in message news:1158769...

How do I set up an out of office auto response?
Hi: I'm a new user to Outlook and I was trying to initiate an "out of office response"/auto reply for one of my colleagues. Can you help me out? Thank you so much. JenniferC <JenniferC@discussions.microsoft.com> wrote: > Hi: > I'm a new user to Outlook and I was trying to initiate an "out of > office response"/auto reply for one of my colleagues. Can you help > me out? Thank you so much. http://www.slipstick.com/rules/autoreply.htm -- Brian Tillman Yet another stupid question what is the OOA & how do I enable it? "Brian Tillman&qu...

Start a file at a defaulted worksheet/cell?
Howdy, Having a few users to a file, can I have the file open to a default worksheet/cell as I have directions I want them to read before playing... Regards, Kevin Kevin, use something like this, put in thisworkbook code Private Sub Workbook_Open() Sheets("Sheet2").Select Range("C3").Select End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 97 ** remove news from my email address to reply by email ** "...

copy data from one worksheet to identical sheet in different workbook
I want to essentially sync the data between 2 identical worksheets in different workbooks. Essentially, I want to import and replace data in the second sheet with data from the first, is there a simple way to do this without deleting the worksheet and then copying the new sheet into the workbook? Thanks You can right-click on your source-sheetname tab, the shortmenu will reflect Copy/MoveSheet.... Select it and make 2 other choices: 1) Check to Create Copy box at bottom 2) From dropdown box at top of screen select an existing open workbook or select new-workbook. OK HTH "a...

Domain name not always needed to log into OWA?
This is something I've wondered about for a while. Why is it that only some of our new Exchange Server installs insist on the OWA login <up to 13 chars. of domain name>\<user name> while others have no trouble with only <user name>? "Julie" <julie@somewhere.org> wrote: >This is something I've wondered about for a while. > >Why is it that only some of our new Exchange Server installs insist on >the OWA login <up to 13 chars. of domain name>\<user name> while >others have no trouble with only <user name>? Probably b...

can send but can receive- event log shows loop within Exchange
Hi all, When I try to send email to my exchange 2003 server from an external email account I never get the email. I get the following error message in my event log. ------------------------ A non-delivery report with a status code of 5.3.5 was generated for recipient rfc822;adrown@[192.168.2.249] (Message-ID <200411090532.iA95WemV015823@gatekeeper.com>). Causes: A looping condition was detected. (The server is configured to route mail back to itself). If you have multiple SMTP Virtual Servers configured on your Exchange server, make sure they are defined by a unique incoming port and t...

Excel macro for copying range to another worksheet
On a monthly basis, I would like to copy the completed range (varies from month to month) of a database (Sheet1) to a master list (Sheet3). Once the data has been copied I intend to manually delete the entries of Sheet1 and start anew for the new month =96 for eventual transfer to Sheet3. The idea is to copy each month=92s data at the bottom of the previous months=92 (Sheet3). I followed Excel=92s record macro command but the macro I ended up with is not capable of placing the new data at the bottom of the existing one; it simply keeps overwriting the previous entry. Unfortunately, I don=92t...

I am trying to get access to display leading zeros and auto numbe
we use a sequential number system that begins new each month but we need it to hold 4 places 0001, 0002. etc. I would like to know if Access will do this. "Donna" <Donna@discussions.microsoft.com> wrote in message news:484176CC-EFDE-48BB-BF18-C5BEFD695710@microsoft.com... > we use a sequential number system that begins new each month but we need > it > to hold 4 places 0001, 0002. etc. I would like to know if Access will do > this. Yes, but ... You can't use the built-in autonumber field to do what you want. Therefore you'll need so...

worksheet appearance
Hey, I create worksheets in VBA, then delete them again and create them again. One worksheet always stays in my workbook, but when I create such a new worksheet with add it appears the first in line. I want it to appear it after the worksheet stat is always visible. How can I solve this? From XL/VBA Help: > Add Method (Worksheets Collection) > > Creates a new worksheet. The new worksheet becomes the active sheet. Returns > a Worksheet object. > Syntax > expression.Add(Before, After, Count, Type) > expression Required. An expression that returns a Worksheets object....

Searching a Differnt worksheet in the same workbook.
So what I need to do is have a colum D that searches Sheet1, column E for a certain text string entered in a different sheet (either 2 or 3) column D. If they match I want the cell in column E, sheet 2 or 3 to return a text of "Found" and if there is no match I want the cell to be blank. I've been looking in these forums and have a feeling it can be done, I just can't figure out how. Thanks. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ Dear Cre...

vlookup help linking data between worksheet
hi, I have a master list of students (about 200+ )in one worksheet. On the succeeding worksheets are the attendance for seminars. We have more than 20 seminars in a year. Because of the large no of attendees per seminar, I usually type out a list of the students who came for each seminar, so there will be 20 +attendance worksheets. Not all students will come every time and there are new ones for each session. To update on master list, I will sort each sheet by surname, print it out and type in separate column (date) for each session and typed "P" for present and &quo...

Excel VBA
Hi, Is there any way to freeze (prevent) a number of worksheets from recalculating when a VBA macro is running? I have a spreadsheet with about 10 worksheets, most of which are linked to each other in some way. One of my macros only needs to use the formulas (and related results) from about 7 of these, so the other 3 are updating all the time but since the results from these are not needed then they are slowing down my code. Is there some VBA function for temporarily disabling a worksheets calculation function? I would need my code to look something like this: Code: -------------------- ...

Linking items GREATER THAN O on another worksheet in the same Work
I have a workbook that has about four worksheets … I want to create a list of items that will automatically be included on worksheet tab 4 from Worksheet tab 1 if the quantity for the item listed on the first worksheet has been changed from 0 to any other number (i.e. 1 or 10 etc). I have a list of equipment with pricing on worksheet tab 1 and the list is long. Many of the items will have quantities of zero and will not increase as they will not be selected for the project being created. We have additional columns for cost, extended cost, labor hours etc. If the quantity changes for a...

Auto Empty Deleted Items on Exit OR after X days or X Items accumulated?
In Outlook 2003 is there a way to Auto Empty the Deleted Items Folder, either on Exit OR after X days since deletion or when X number of Items accumulated? -- "J. J." Go to "Tools" : "Options" : "Other" First option is "Empty Deleted Items folder upon exiting" You can set it to delete after x number of days for certain e-mail account types. Go to: "Tools" : "E-Mail Accounts" : Select, "View or change e-mail accounts" Select account to chnage and click "Change..." : Click "More Settings" Se...

Start-up worksheet!?
Hello basically I would, each time i open my spreadsheet model for the worksheet i wont to pop up, and from there i can navigate easily to the other worksheets by buttons, how can i make a worksheet to pop up like this everytime i open the file....? Thanks From John -- Neo1 ------------------------------------------------------------------------ Neo1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30329 View this thread: http://www.excelforum.com/showthread.php?threadid=515098 Private Sub Workbook_Open() Worksheets("Sheet1").Activate End Sub ...

Auto delete stopped functioning in Outlook 2000
Hi, I have a single install on a user PC which although the option to auto empty the waste bin is checked it is not deleting or even asking whether she is sure she wants to delete. Advice appreciated, Sam ...

Auto copy emails btw 2 mailboxs
Hi All, I have 2 email accts A , B. 1)What ever sent to acct A will auto copy to Inbox B. 2)What ever sent from acct A will auto copy to Sent Items Box B. How do I define this email rule in MS exchange server? Thanks & Regards, Steve 1) In AD Users and Computers, select the profile properties, go to the Exchange General tab and select Delivery Options - here you can specify mailbox B to get a copy. 2) not sure if this is possible. S. <foozhiqin@gmail.com> wrote in message news:1116902957.014076.300440@g44g2000cwa.googlegroups.com... > Hi All, > > I have 2 email...

Allowing rules for auto-forwarding mails over OWA
Hey guys! I want to allow OWA-users to make a rule, which auto-forwards mails. But the users always got an error and the message to try it again in a few minutes. Facts: - it doesn´t mather if the recipient is an domain-user or not - users can create such a rule over desktop-outlook, but not over owa - users can create all rules except auto-forwarding! - Exchange version: 2003 sp1 And the error message is ... ? dOcToR bEaT wrote: > Hey guys! > > I want to allow OWA-users to make a rule, which auto-forwards mails. > But the users alway...

Smart Profit Research Report
Bajaj Auto Ltd, the second largest manufacturer of two-wheelers in India, has reported a lower growth compared to its peers. Due to its production constraints, decreasing brand image, market acceptance, and inability to achieve target sales, the stock seems to be struggling. It seems probable that within the next 6 months Bajaj may downgrade to the 4th position from its second position in the two wheeler segment, giving way to Honda and TVS Motors to up their positions in the Indian market. For the month of November 2010, total sales for Bajaj Auto dropped by 20% to 2.99 lakh units compared t...