Question about Microsoft Windows Vista Ultimate Edition

1 Answer

Invoice i want to do one invoice , in were in one colomn i write the code of the product and automaticly in the second column is write the product how to do

Posted by on

  • arongoldzwei Sep 11, 2008

    i'm using excel 2007 .

    I have one invoice to do and i want to write in one coloumn only the code number of the product and them ,that all the information of this product appear automaticly , is means that all the details information of this code stay in other file or other excel page

  • David Leahy May 11, 2010

    Sorry but you will need to explain a little better as to what you want to do and with what program you are using


1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert that gotĀ 5 achievements.


    An expert whose answer gotĀ voted for 20 times.


    An expert who has answered 20 questions.

  • Contributor
  • 32 Answers


Posted on Sep 14, 2008

Add Your Answer

Uploading: 0%


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



Related Questions:

1 Answer

My computor wants a product key and i haven't got one serif didnt include it with this order had the programme a few years as i have a library of programmes

Serif normally put the Co code on the invoice. If you haven't got it, sign into your serif account at serif com and it will be there. If all else fails phone them on

Apr 13, 2014 | Serif Operating Systems

1 Answer

Office word is asking for a product key, it has frozen my invoice template. can you help with a product key that works for office2007 microsoft

You forgot to mention which version of Office. Heres a key for Office Pro 2007 QBKCF-2VXQM-CQJBC-3D4PB-2X9QY if its another version message me with an email address and i'll send you the keycodes for all...... Cheers from Scott

May 17, 2011 | Operating Systems

1 Answer

I have posted an invoice on sage instant with VAT and it should have been VAT free, can you tell me how I can change it as it won't let mee edit it thank you

It Should allow you edit it but if not post a credit note for the same amount and the incorrect Vat on the same date to the same nominal code, then reenter the invoice without the vat

Jan 25, 2011 | Operating Systems

1 Answer

Hi; I purchased MS Office Home and Student online back in May. Use Word almost exclusively for writing. However, now I wangt to use Publisher and Access and find neither the trial products code nor the...

Like other scams there are many sites on the internet that are selling you counterfeit software (as well as other products). You should purchase Microsoft products as well as other software only from the authorized dealers online and offline. You should also know that the websites that are certified by "Verisign" company can be identified by a certificates so that the site can be reached back if there is any fault in the products you buy. To find out whether a site is certified or not download and install AVG anti virus free edition from the following site.
You can contact Microsoft through Microsoft customer support but I personally think that Microsoft can't do anything about it.

Aug 22, 2010 | Microsoft Operating Systems

1 Answer

Just install new HP Officejet Pro 8500 printer I cannot print invoices in my Quick Books Pro 2009 program. Will print Purchase orders but not invoices

contact the developer or programmer of invoicing system. i believed the problem is in hard code in which your newly installed HP printer not supported with the invoicing system application.

Mar 25, 2010 | Operating Systems

1 Answer

I purchased my genuine Microsoft XP Home/ Pro editions as 3 paks from Edirect Software in 2006. I even have the invoice number but I don't have the product key. How to I get the correct product key code...

Ok - contact your local Microsoft office, explain to the tech support guys your problem... they will ask you a couple of questions about the CD to make sure you have an authentic disk... once they are happy they will issue you with a brand new Key free of charge there and then... It will only take you about 5 mins to get a new key.

If this helped you then please help me and vote

Oct 11, 2009 | Microsoft Windows XP Home Edition

2 Answers

All programs colomn is blank

hi windows 7 is still not stable it is trial version, try using your backup to restore your system.

Jul 10, 2009 | Operating Systems

2 Answers


I am assuming that you want your date column to run daily - not updating itself with todays date over previous data....

In which case your column will run a daily date, You can achieve this by typing a date in the format you choose = 01/05/09, 1 May 09, etc hit return. scroll on the bottom corner of the cell you have typed the date in until it changes from a large white cross to a smaller cross and drag this down the column.

For the totals that need to subtotal autmoatically you will need to select a range - so is this total a weekly/ monthly total - How large is your range.

Once you have decided on the above - for example the in Column A the date ranges from 1st May - 31st May for a calendar month, the subtotal will need to include 31 cells - so in the Column B which is the subtotal = SUM(B2:B32)

You can copy and paste the sum into adjoining cells if you are seperating income from expenses etc.

Hope this helps.

May 21, 2009 | Operating Systems

1 Answer

Flex Grid

The most common multidimensional array, the two dimensional array table, is best presented to your users in row and column format. The grid control offers a convenient way for you to display table data to your users. The users can navigate the table's values using scrollbars. Therefore, the grid control does not have to be as large as the table, because the grid control automatically displays scrollbars.
To add the flex grid control to your toolbox, select project and components. Add the flex grid control:
lesson97-1.jpg Once it is added, you will see the yellow flex grid control in your toolbox:
lesson97-2.jpg When you place the grid control on your form, you will have to resize it before the control takes on a tabular appearance. As you expand the size of the control, it does not look to much like a table. The problem is that the table's default number of rows and columns are two. To fix this problem, you must configure the rows and columns in the properties window:
lesson97-3.jpg lesson97-4.jpg lesson97-5.jpg The grid control supports fixed rows and columns. These refer to rows and columns in a grid control that do not scroll when the user clicks the scrollbars. The fixed rows and columns provides labels that describe the data. The fixed rows and columns are often called row and column headers.
lesson97-6.jpg When working with the grid control, much code is needed to provide the grid with functionality. Call statements are used to break the code required by the grid control into smaller, more manageable procedures. This is referred to as modular programming (which refers to the practice of placing code with a single purpose in a general subroutine procedure and then calling the code from a second procedure.)
Here is the code for the form load procedure (this example is based on the computer disk example used in the last lesson)

Private Sub Form_Load()
Call SizeCells
Call CenterCells

grdGrid.Row = 0
grdGrid.Col = 1
grdGrid.Text = "Single Sided; Low Density "
grdGrid.Col = 2
grdGrid.Text = "Double Sided; Low Density"
grdGrid.Col = 3
grdGrid.Text = "Singled Sided; High Density"
grdGrid.Col = 4
grdGrid.Text = "Double Sided; High Density"

grdGrid.Row = 1
grdGrid.Col = 0
grdGrid.Text = "3 1/2 inch"
grdGrid.Col = 1
grdGrid.Text = "$2.30"
grdGrid.Col = 2
grdGrid.Text = "$2.75"
grdGrid.Col = 3
grdGrid.Text = "$3.20"
grdGrid.Col = 4
grdGrid.Text = "$3.50"

grdGrid.Row = 2
grdGrid.Col = 0
grdGrid.Text = "5 1/4 inch"
grdGrid.Col = 1
grdGrid.Text = "$1.75"
grdGrid.Col = 2
grdGrid.Text = "$2.10"
grdGrid.Col = 3
grdGrid.Text = "$2.60"
grdGrid.Col = 4
grdGrid.Text = "$2.95"

End Sub
Notice how the form load procedure is used to populate the cells in the grid control. To control cell size and cell alignment, two smaller procedures are created and each procedure is called by the form load procedure.

Private Sub SizeCells()
Dim intColumn As Integer

grdGrid.ColWidth(0) = 1100

For intColumn = 1 To 4
grdGrid.ColWidth(intColumn) = 2200
Next intColumn

End Sub

Private Sub CenterCells()
Dim intColumn As Integer

For intColumn = 1 To 4
grdGrid.ColAlignment(intColumn) = flexAlignCenterCenter
Next intColumn

End Sub

Notice that the size and alignment procedures are only applied to columns 1 through 4. Column 0, which is a fixed column reserved for labels, is not formatted using either of the above two procedures.
Here is the final result:

Mar 26, 2008 | Operating Systems

1 Answer


You know, you really should have said it's an Excel problem, because it is; also your invoice and receipt numbers should probably be 10-12 digits long (yes, even if you do a mere 20 deals a year).

Add error checks and alerts to your spreadsheet, for starters; second, state the version etc. of the spreadsheet program you use, and how much memory is available on your system. VLookup often bombed or just gave the last result forever if it didn't have 130MB to play with. Other times it behaved if you ran certain initializations for it....

Mar 23, 2008 | Operating Systems

Not finding what you are looking for?
Microsoft Windows Vista Ultimate Edition Logo

Related Topics:

37 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Operating Systems Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Scott Fryer

Level 2 Expert

80 Answers

Carlos L. Burgos
Carlos L. Burgos

Level 2 Expert

508 Answers

Are you a Microsoft Operating System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides