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

2 Suggested Answers

  • 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

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

I have a project going in my company. I want psion teklogic to automatically send the scanned data into Excel. Please help me in understanding how can I do this ?


you may need an ocr to excel software converter
http://www.simpleocr.com/OCR_to_Excel
in excel you would have a work book that you put the resulting scan into as an excel format. Then you have another workbook that is referenced to the workbook and particular cell with part number
then you would have a workbook with a list of cells part number and pdf files .
then lookup function would take part number and use it to lookup from the reference list.

Mar 28, 2014 | Psion Teklogix 7535 G1 WiFi PDA w/Long...

1 Answer

My Microsoft EXCEL 2007 program has folowing behaviour. When I type a number i.e. 4, then coms 0.04. I did not find how to rectify this. Can you help me? My laptop MITAC 8640 has the problem, but also my...


Do this easy instructions on how to change back your numbers on excel.
  • Run/Open your Microsoft EXCEL 2007
  • Click the Microsoft Office Button za010077102.gif, and then click Excel Options
  • Click on Advance
  • In there you will see Editing Options
  • Then uncheck the box "Automatically insert decimal points" Then thats it.
Hope this solves your problem. Good Day.

Jun 21, 2011 | Computers & Internet

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

Create an excel file using VB6.0


Use PDF-in-a-box. Create your file in excell, embedd their given applet code in VB and it will automatically be importedas a PDF file using your excel template.....sodeep

Mar 04, 2009 | HP Pavilion dv6000z Notebook

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

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

3 Answers

Excel password removing


could you please supply us with the version of Excel you are using? it's under Help About Excel

Mar 04, 2008 | Excel (SS8SATAS5128400R)

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

Related Topics:

1,317 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18386 Answers

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

Answer questions

Manuals & User Guides

Loading...