Question about Microsoft Excel for PC
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/
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
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
a 6ya Technician 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 repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
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
Dec 14, 2009 | Microsoft Office Excel 2003 for PC
Nov 18, 2009 | Computers & Internet
Sep 14, 2009 | Computers & Internet
Apr 24, 2009 | Computers & Internet
Jan 23, 2009 | Steinberg Cubase Studio 4 Upgrade Version...
Jul 14, 2008 | Microsoft Computers & Internet
Jan 01, 2008 | Microsoft Office Standard for PC
Dec 18, 2007 | Microsoft Office Standard for PC
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
120 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: