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
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.
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.
139 views
Usually answered in minutes!
have a workbook in which i want to copy date and contract no at the time of writing without copy/paste. how it works/
×