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

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 the template again, the invoice number would show as 6. would appreciate your help on this.

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 8 Answers

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

Powerpoint 2007 cannot open .pps file created in Powerpoint 2003


I would prefer guide below or another methods are proposed from different sources over Internet, but in case the guide from MS Corporation can't handle the problem

https://www.openfiletool.com/pptxopen.html PPTX Open File Tool
http://itknowledgeexchange.techtarget.com/itanswers/how-to-open-powerpoint-file/
http://community.office365.com/en-us/f/172/t/268740.aspx

  1. Open PowerPoint 2007.
  2. Click the Microsoft Office Button and click Open.
  3. In the File name: box, enter the text in bold to display a list of the automatically saved files (if any).You can also copy and paste this text into the File name: box.

    PowerPoint 2007: %temp%\ppt*.tmp
  4. Click the Open button.
  5. Click the name of the file that you want to recover, and then click Open.

    Note : The automatically saved files may not be named in a descriptive way. Continue to open files until you find the one you are looking for.
  6. After you find the file, click Save. Then save the file to your My Documents or other location.

Oct 23, 2015 | Microsoft PowerPoint for PC

Tip

How to Render YouTube-Capable 720p HD Videos in Sony Vegas


Welcome to my tutorial on rendering or exporting videos in 720p high definition that you can upload to YouTube. [NOTE: Entire tutorial is available in video format at the bottom of this article]<br /> Required tools: <ul> <li>Sony Vegas HD video editing software - <a href="http://www.sonycreativesoftware.com/vegassoftware">http://www.sonycreativesoftware.com/vegassoftware</a></li> <li>K-Lite Video Codec pack - <a href="http://www.codecguide.com/download_k-lite_codec_pack_full.htm">http://www.codecguide.com/download_k-lite_codec_pack_full.htm</a> (install this codec pack after you've installed Sony Vegas and before you begin editing your video)</li> <li>Video file(s) you wish to edit</li></ul> Once you have Sony Vegas installed and the codec pack installed, open Sony Vegas. You will have an empty project window similar to this one: <img src="d3m0l1sh3r.jpg" /><br /> <br /> Now find your video files and drag them into the Project Media tab in Sony Vegas. <img src="d3m0l1sh3r_0.jpg" /> Next, drag all of your videos onto the video timeline at the bottom of the Sony Vegas window and align them in the correct order. <img src="d3m0l1sh3r_1.jpg" /><br /> Next, right-click all of the video files on your timeline, go to "Switches," and uncheck "Maintain Aspect Ratio" and click "Disable Resample." Your "Switches" menu should look like below. <img src="d3m0l1sh3r_2.jpg" /><br /> Last step of the editing process! Next, drag the yellow triangle <img src="d3m0l1sh3r_3.jpg" /> at the top-left corner of your video triangle all the way to the end of your video clips. This tells Vegas to only render that much of the timeline. Click File -&gt; Render As... and type in your final video name and choose the location you wish to save it to, but do NOT click Save yet! Click the drop-down menu next to "Save as type" and select "MainConcept AVC/AAC (*.mp4)". Next, click the "Custom" button, next to the "Template" drop-down menu. For each tab in this window, make your setting match exactly how they do in the pictures. "Video" tab: <img src="d3m0l1sh3r_4.jpg" /><br /> "Audio" tab: <img src="d3m0l1sh3r_5.jpg" /><br /> "Project" tab: <img src="d3m0l1sh3r_6.jpg" /><br /> Finally, type in a template name, next to "Template:" at the top, like "YouTube 720p HD" and click the save icon. This saves your template for future use. Then click OK at the bottom. Back at the Render As menu, make sure the template you just made is selected, and click save. Depending on the length of your video and the speed of your computer, this can take anywhere from a few minutes to a few hours to complete, so make sure your computer stays awake and has power to complete this job. Once it's done, Ta-Da! You have a YouTube-ready HD video ready for you to upload and share! (Or to FaceBook, or other popular sites, as well.) <br /> I hope you enjoyed this tutorial and it was helpful. <br /> Here's a video tutorial for further aid, however it also includes information for recording PC video games as well. <utube src="YFbuFM2HH3w">Adam Taylor, D3M0L1SH3R <p><br />

on Jul 10, 2011 | Sony Vegas Pro 9 Full Version for PC...

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

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

2 Answers

Powerpoint template downloading


You can first enlarge the template size using photoshop and don't fail to save the file as jpeg.
better use latest adobe photoshop version which will be give better result on the picture quality

Apr 11, 2009 | Microsoft PowerPoint for PC

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

2 Answers

Excel - Automatically update invoice numbers


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

May 14, 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:

379 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

18298 Answers

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

Answer questions

Manuals & User Guides

Loading...