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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How do I change the size of the print on the label


Using the software that came with it modify the font settings.
Changing the Default Font Settings in DYMO Label Software Answer 299 ' Applies To DYMO ' Published 07/20/2005 10:16 AM EDT ' Updated 08/31/2010 05:05 PM EDTHow do I change the default font settings in the DYMO Label Software (DLS)?

Font settings can be adjusted for individual label templates and for the DLS application. Please note, changing the font settings for the DLS application will only affect the creation of new label templates. It does not change the font settings of any previously created and saved label templates.

Changing the Default Font Settings for Individual Label Templates in DLS

  1. Open DLS.
  2. In DLS, click and highlight the text on the label template.
  3. The tool bar above the label template allows you to change various font and justification settings. To change font type and font size you must click on the Font Settings icon: f_f.jpg
  4. Make the necessary changes to the font settings. The Sample field indicates how the text will appear on the label. Please note, the text will automatically shrink to fit if you select a font size that is too large for the address or text object on the label to accommodate.
  5. Click OK after making the necessary changes.
  6. Save the label template. Click on the File menu in DLS and select either Save or Save As. Selecting Save will save the label template with its existing name. Selecting Save As will allow you to enter a new name and create a new label template.



Mar 01, 2011 | Dymo LetraTag QX50 Thermal Label Printer

2 Answers

What is exel sheet extension in office 2010 ?


Excel Workbook

.xlsx

The default Excel file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Workbook

.xlsm

Uses the same basic XML format as the Excel Workbook, but can store VBA macro code. Users saving an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are prompted to use this file format.

Excel Template

.xltx

The default file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Template

.xltm

Can contain a VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0). Workbooks created from this template inherit the VBAProject part or Excel 4.0 macro sheets that exist in the template.

Excel Add-In

.xlam

A supplemental program that runs additional code. Excel add-ins use the Open XML file format to store data, and they support using VBA projects and Excel 4.0 macro sheets.

Feb 21, 2011 | Computers & Internet

2 Answers

Date change


If you are using Excel 2007 ...Open Excel ... Click the Office button ... select Open ... highlight the file you wish to open ... then at the bottom of the dialog box click the downarrow next to Open and choose "Open-Read Only".
or
Before opening your old document(s), right-click the file ... select properties ... place a check mark in the box Read-only ... Select OK. Your application should open the file in Read-Only mode and will not be able to make changes or save the file.

Mar 30, 2010 | Microsoft Office Professional 2007 Full...

1 Answer

Invoice & Order Minimize Data Entry - Especially Name and Address


Do you have Microsoft Access? If so, you could use that to create a database and an invoice form. You could also use Access to "dump" the info into Excel to track and record.

Otherwise, try searching for "Import Data" in the Excel help. It would be very difficult to walk you through the whole process, but if you have specific questions about certain steps, that would be more manageable.

Jan 06, 2009 | Microsoft Excel for PC

1 Answer

Minimize Data Entry


I will suggest you to create small application in .net for ths which will add some value and process your data;If you want to use Excel only make a master sheet with details and use it in other excel sheets

Jan 02, 2009 | Microsoft Excel for PC

1 Answer

Increment a number per record in Microsoft Excel


For what you are talking about doing, Microsoft Access would probably be a better option. With Microsoft Access, you can create a custom form and have it automatically give a number.

More information about Access:
http://www.bcschools.net/staff/AccessHelp.htm

Dec 18, 2008 | Microsoft Excel for PC

1 Answer

Excel-template


Open a blank workbook in Excel and click "save as" option select "Template" from the drop-down list and save it

Hope this helps,

CynosureboY

Sep 13, 2008 | Microsoft Excel for PC

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

1 Answer

LINE 100


If Sale Line 100 is an Excel Template then it is simple.

The Templates are just preformatted spreadsheets which are edited just like any other spreadsheet.

If you mean that you are using the Template to create another document but wanting all the fields to be the same as the Invoice then I suggest the following method:

Copy the Template fron Worksheet 1 onto Worksheet 2.

Add and remove any fields that you wnt to add or remove (Prices would be deleted on this copy and the title would be changed from Invoice to Delivery Docket, etc)

Then (on Worksheet 2) in the fields that you want to be the same - click on the cell you want the same Data in and hit the = sign. Then go to Worksheet 1 and Click on the cell that you want the data to be the same. Hit Enter. This will send you back to Worksheet 2 and you will see that any data entered into the cell in Worksheet 1 will now also appear in Worksheet 2.

Repeat this process for all the cells you want copied from worksheet 1.

When you complete the data in Worksheet 1 (the Invoice) all the data selected will automatically appear in the cells selected on Worksheet 2.

Try this on worksheet 2 select cell A1, type =, then open worksheet 1 and select B1. You will be returned to worksheet 2 and the formula in cell A1 will now read =Sheet1!A1. Enter anything into Shhet 1 A1 and you will see that it appears in the appropriate cell on Sheet 2.

When you want to print off the Invoice and the Delivery Docket - you only have to open each Worksheet and hit Print and a copy of each worksheet will be printed giving you an Invoice and a Delivery Docket with the appropriate info on each printout (eg if you exclude prices from the Del. Docket then after completing all the details in the Invoice will create a Del Docket with all the relevant information other than the prices.

Does this answer your question?

Apr 25, 2008 | Computers & Internet

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

Related Topics:

382 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18375 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...