Question about Microsoft Excel 2000 Step by Step (1572319747) for PC

2 Answers

Excel - Automatically update invoice numbers

I would like my excel invoice template to automatically update the invoice number each time I open it....can you help me out?

Posted by on

  • Patrick Singh Nov 19, 2008

    i want to create an excel template that can automatically update the invoice number once i save it. say i have the excel template open with the curent invoice numbe as 5. once i save this file and i open the template again, the invoice number would show as 6. would appreciate your help on this.

  • cornella Jan 05, 2009

    I have just updated to Windows 2007 from 2003, but I can't figure out how to number my invoices so that each time i open the template a new number is generated.

×

2 Answers

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 2 Answers

Private Sub Workbook_Open()
With Range("A1")
.NumberFormat = "00000"
.Value = .Value + 1
End With
End Sub

Posted on Feb 14, 2013

  • prosedna962
    prosedna962 Feb 14, 2013



    Private Sub Workbook_Open()

    With Range("A1")

    .NumberFormat = "00000"

    .Value = .Value + 1

    End With

    End Sub

×

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Yes but You need to tell your exact requirements eg. from where you would like to update your Invoice Template i.e from A Separate Database or from a Dropdown List etc

Posted on Jun 24, 2008

1 Suggested Answer

  • 8 Answers

SOURCE: i want to create an excel template that can

Is it in a single-user environment? You can save the current invoice number to a text file then ope that and +1 (which is the way that the demonstartion Invoice in Excel 97 / 2000 used to do it ).

Posted on Apr 13, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I want to copy an Excel chart as a Image onto a PowerPoint Slide (Office 2007). What is the sequence of APIs to apply?


Copy worksheet data to a PowerPoint presentation
  1. In Excel, select the worksheet data that you want to copy to a PowerPoint presentation.
  2. On the Home tab, in the Clipboard group, click Copy za006044679.gif.

za010165428.gif

Keyboard shortcut You can also press CTRL+C.

  1. Click in the PowerPoint presentation where you want to paste the copied worksheet data.
  2. On the Home tab, in the Clipboard group, click Paste.

Keyboard shortcut You can also press CTRL+V.

  1. Click Paste Options za006043532.gif next to the data, and then do one of the following:
    • To use the original format of the copied data, click Keep Source Formatting.
    • To use the document theme that is applied to the PowerPoint presentation, click Use Destination Theme.
    • To paste table data that you copied as text, click Keep Text Only.

Notes

  • If you don't see the Paste Options button, you may have to turn it on. Click the Microsoft Office Button za010077102.gif, and then click PowerPoint Options. In the Advanced category, under Cut, Copy, and Paste, select the Show Paste Options buttons check box.
  • If you paste the data into a PowerPoint table, the Paste Options button is not displayed.
Tips
  • To paste the data in another format (such as a worksheet object, HTML format, bitmap, picture, or to text format) or to paste a link to the source data in Excel, on the Home tab, in the Clipboard group, click the arrow on the Paste button, and then click Paste Special. In the As list, click the format that you want to use.
    • If you want to edit the entire worksheet later, click Microsoft Office Excel Worksheet Object. Clicking Microsoft Office Excel Worksheet Object provides access to the entire worksheet in the presentation, including data that you may want to keep private. To automatically update the table in the presentation when changes are made to the source data in Excel, click Paste link. Both of these options also preserve the Excel formatting, even when the formatting features that are used are not supported in PowerPoint. If you saved the source workbook before you copied the data, you can also click Attach Hyperlink to insert a hyperlink in your presentation that directs you to the source data in Excel.
    • To paste the content as an Object Linking and Embedding (OLE) (OLE: A program-integration technology that you can use to share information between programs. All Office programs support OLE, so you can share information through linked and embedded objects.) PowerPoint application icon (rather than pasting the actual content), click Microsoft Office Excel Worksheet Object, and then select the Display as icon check box. You can click the icon to open the application and then view the content.
    • If you want to use HTML to copy the data to PowerPoint into a PowerPoint table, click HTML format.
    • To paste a static picture, click Device Independent Bitmap or Bitmap, or to paste a picture that can be ungrouped, click Picture (Enhanced Metafile) or Picture (Windows Metafile).
    • To paste the data as formatted or unformatted text, click Formatted Text (RTF) or Unformatted Text.
  • To paste the data as a hyperlink that directs you to the source data in Excel, click the arrow on the Paste button, and then click Paste As Hyperlink. If the workbook that contains the source data has not been saved yet, this option is unavailable.
  • If you want the range of data that you paste as a Microsoft Excel Worksheet Object into a PowerPoint presentation to expand when the corresponding data expands on the Excel worksheet, you can define a name (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) for the range of data in Excel before you copy the data. You can then paste a link to the named range by using the Paste Special command. On the Home tab, in the Clipboard group, click the arrow on the Paste button, click Paste Special, and then click Paste link. This works only when you copy data that is not in table format in Excel.

Mar 09, 2011 | Individual Software Professor Teaches Word...

2 Answers

What is ms-excel


ms excel is a program that you can make graphs and set up all sorts of things like prices at a petrol station on the front neon sign you can set it up that each time the price rises it will automatically increase that rise in dollars and cents
hope this helps

Feb 15, 2011 | Broderbund Learn MS Windows XP and Excel...

1 Answer

How i recover my demages excell files


Close down Excel, re-open it and try to open the file again.
If this doesn't work, restart the computer, open up Excel and try to open the file again.
If this doesn't work, delete the contents of your c:windows emp directory then reboot. Try again
If this doesn't work, open Excel in Safe Mode. This will disable VBA and Add-ins.
  • Click on Start then Run then enter (including the quotes and the /s extension): "C:Program FilesMicrosoft OfficeOfficeexcel.exe" /s ["C:Program FilesMicrosoft OfficeOffice10excel.exe" /s (for Excel 2002, Office XP, click cancel if the MS Office Installer starts, Excel in safe mode will still start)].
  • Try to open the file.
If this doesn't work, be sure to scan the file for viruses. If you don't find a virus, find the file in Explorer, right click on it and rename it, replacing the .xls extension with the .doc extension. Try to open it as Word document.


If this doesn't work, try to determine if the file is unrecoverable on the disk. Open the file in Explorer and try to copy it to another location.
  • If you can copy the file to another location, skip to step 9. If not, the actual sectors on the disk may be corrupted.
  • If the data is valuable enough to you, seek professional services as a damaged hard disk file recovery is not for the faint at heart.
If the recovered file won't open or you could copy the file to another location, try to open the file in a more recent version of Excel. As the version numbers increase, their ability to recover corrupt files increases. If this doesn't work or such a version of Excel is not available, see if some other spreadsheet application is and try to open the file in that program.

If Microsoft can't help you (see the tips section) and you've exhausted all the free methods above for damaged disk recovered or copyable files there are a number of excellent commercial applications which will recover your files almost immediately.
http://www.repairmyexcel.com/

Dec 10, 2010 | Educational & Reference Software

1 Answer

Before occuring this problem I was run Scan DIsk & Defregment also after that I am facing this message "Microsoft Excel for Windows has encountered a problem and needs to close. We are sorry for the...


left click start, left click control panel, left click add/remove programs, locate microsoft office highlight it and left click change, once the window opens click on repair. This should perform a repair on your Microsoft Office Application. Restart the computer if necessary, also be sure to pull down any Windows Updates left click start, left click Windows Updates, there could very well be an update your Excel application is missing. The Microsoft Updates have been known to resolve some of the known issues with office applications.

Jun 16, 2009 | Microsoft Excel Version 2002 Step by Step...

2 Answers

Excel wont calculate when changes are made to an existing file.


Looks like you will have to re-install Excel from original CD again.

May 28, 2009 | Microsoft Excel 2000 Step by Step...

1 Answer

Excel spread sheet asking password automatically


Its very simple,
simply save your file using save as with the same name, and in options select password to open.
or

open file
tools --> options --> password to open
type here the password

Zulfikar Ali

Mar 08, 2009 | Educational & Reference Software

1 Answer

I want to create an excel template that can automatically update the invoice number once i save it. say i have the excel template open with the curent invoice numbe as 5. once i save this file and i open...


Is it in a single-user environment? You can save the current invoice number to a text file then ope that and +1 (which is the way that the demonstartion Invoice in Excel 97 / 2000 used to do it ).

Feb 26, 2009 | Microsoft Excel 2000 Step by Step...

1 Answer

Microsoft Excel Calculation


for example if your numbers are in cells A1, B1 and C1
=MIN(A1:C1)+MEDIAN(A1:C1)

only works for 3 numbers as you requested.

Sep 01, 2008 | Microsoft Excel 2000 Step by Step...

2 Answers

Microsoft Exel


Go here and downlad a Template:

http://office.microsoft.com/en-us/templates/CT101172551033.aspx?av=ZXL000

Either use the Template or use it to design your own (reverse engineer it).

This is much easier than trying to tell you step by step what you have to write and where.

Good luck.

May 12, 2008 | Microsoft Excel Version 2002 Step by Step...

Not finding what you are looking for?
Microsoft Excel 2000 Step by Step (1572319747) for PC Logo

Related Topics:

1,315 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Educational & Reference Software Experts

k24674

Level 3 Expert

7987 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Are you a Microsoft Educational and Reference Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...