Question about Microsoft Excel for PC

1 Answer

If function in exel

I have a workbook in which i want to copy date and contract no at the time of writing without copy/paste. how it works/

Posted by on

  • Anonymous Jul 18, 2008

    have a workbook in which i want to copy date and contract no at the time of writing without copy/paste. how it works/

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Sniper:

    An expert who has posted more than 50 answers, of which 90% or more were rated as helpful.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 53 Answers

For Current Date - you can use the =Now() function in your cell where you want the date.

For Contract #, I don't know what you're using, but you can link to a database of contract #s (see below), or you can name a range like current contract #, which gets updated by 1 each time you add another contract, which then is automatically posted on your EXCEL



DGET(database,field,criteria)
Database is the range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
Field indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
Criteria is the range of cells that contains the conditions that you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Posted on Jul 15, 2008

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 link a chart from one spreadsheet to another


Paste Link a chart from one workbook to another within Excel

Select first chart - click Copy - click new location - HOLD DOWN THE SHIFT key and click Paste. This pastes a link between workbooks.

Feb 05, 2014 | Computers & Internet

1 Answer

Excel 2003 cell is highlighted, font color is selected, but the color on the screen remains black. When printing the color prints out correctly while showing black on the screen


to remove all formats....
i.e.
open another workbook....
copy all data from the present sheet to the new work book....
present workbook
select data/edit/copy

new work book
select cell edit/paste special/values

now do the formating/color/font/size etc in the new workbook and check if they work here

Dec 14, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

When i open remote management showing a error message''error:1004'' please help me to solve this problem.


his problem can occur when you give the workbook a defined name and then copy the worksheet several times without first saving and closing the workbook, as in the following sample code: Sub CopySheetTest() Dim iTemp As Integer Dim oBook As Workbook Dim iCounter As Integer ' Create a new blank workbook: iTemp = Application.SheetsInNewWorkbook Application.SheetsInNewWorkbook = 1 Set oBook = Application.Workbooks.Add Application.SheetsInNewWorkbook = iTemp ' Add a defined name to the workbook ' that RefersTo a range: oBook.Names.Add Name:="tempRange", _ RefersTo:="=Sheet1!$A$1" ' Save the workbook: oBook.SaveAs "c:\test2.xls" ' Copy the sheet in a loop. Eventually, ' you get error 1004: Copy Method of ' Worksheet class failed. For iCounter = 1 To 275 oBook.Worksheets(1).Copy After:=oBook.Worksheets(1) Next End Sub

Nov 18, 2009 | Computers & Internet

1 Answer

When copying and pasting pages from certain excel workbooks files are corrupting. It states that part of the file is unreadable. How do I solve this problem?


you are opening template files and attempting to copy the format information which most programs dont like and this is why it corrupts at a guess.

or else you are running office 2007 and opening older format files and attepmting to copy & paste info from excell into word or vice versa without first settign compatability mode for older versions of office.

Sep 14, 2009 | Computers & Internet

1 Answer

Copy and paste between different workbooks


There should be 2 paste options when you right click in the new workbook - 'paste' and 'paste special'

choose 'paste special' and make sure that 'All' is selected not 'values'

Apr 24, 2009 | Computers & Internet

1 Answer

Tools protect workbook& sheet


Open the protected sheet... Go to edit and click select all. Go back to edit and click on copy. Open a new excel sheet, go to edit and click on paste. Now you have the copy of the protected sheet without the protection.

Jan 23, 2009 | Steinberg Cubase Studio 4 Upgrade Version...

1 Answer

Excell workbooks


You need to learn how to use the, "Paste Link," function. If you copy the spreadsheet and paste the information into a new tab in the same workbook, using the 'paste link' feature, the information on the linked pages will update automatically each time you update the page the links are based upon.

Jul 14, 2008 | Microsoft Computers & Internet

1 Answer

Exel 2003


You can refer to cells that are on other worksheets by perpending the name of the worksheet followed by an exclamation point (!) to the cell reference. In the following example, the AVERAGE worksheet function calculates the average value for the range C1:C10 on the worksheet named Marketing in the same workbook.

default.aspx?assetid=za010939481033 Refers to the worksheet named Marketing default.aspx?assetid=za010939491033 Refers to the range of cells between C1 and C10, inclusively
  1. Click the cell in which you want to enter the formula.
  2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) default.aspx?assetid=za060515351033, type = (equal sign).
  3. Click the tab for the worksheet to be referenced.
  4. Select the cell or range of cells to be referenced.

Jan 01, 2008 | Microsoft Office Standard for PC

1 Answer

Consolidate few sheets under 1 excel


What version of Excel are you working with. Newer versions allow you to have multiple spreadsheets grouped together into what is called a, "Workbook." To view the sheets separately, you simply click on the tabs at the bottom of the workbook. The easiest way I know of to join spreadsheets together into a single workbook is to open all of them at the same time, then choose, "View / Arrange All," and they'll be small, but you can grab each one by its tab and drag it to the workbook you want them in. Then you save the workbook (give it a new name like, "Accounting Roll-UP," or, "Consolidated Books," or whatever best describes it) making sure to close all the (now empty) spreadsheets without saving your changes to them (or else you'll lose your 'back-up' data). Voila! You open one file, and all your spreadsheets are available with the click of a mouse.

Dec 18, 2007 | Microsoft Office Standard for PC

3 Answers

Shared Microsoft Excel Wokbook problem


You copy and paste that excel file with another name in your local hard disk. Make your necessary changes and then paste it with same name on your network.

Sep 09, 2007 | Microsoft Office 2003 Basic Edition...

Not finding what you are looking for?
Microsoft Excel for PC Logo

118 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

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