Ok cool!

This may require some macro's

First one:

I have 10 sheets that I would like to link it to another. This main sheet
will have a date and then a seperate row header for each one of the sheets. I
would like it to pull all the information from the row that matches the date
on the main sheet and insert it into each one of the row headers. Is this
possible??

This is what it looks like:

Date ______________

Sheet 1:
=insert row information from columns 2:7 from sheet 1 that is = to date
Sheet 2:
=insert row information from columns 2:7 from sheet 2 that is = to date
Sheet 3:
=insert row information from columns 2:7 from sheet 3 that is = to date

may be multiple rows

Second One:

I have a spreadsheet containing a list of Treasury bills that are split into
codes. My goal is to be able to punch these bills in there without having to
insert cells in between dates and codes by creating another sheet that will
auto insert the treasury bills into the right code and then into the right
date.
So let me explain the details. On the created sheet there is a bank code
cell, a maturity date cell, a cost cell, and a par value cell. The bank code
is something such as 826-c, nym- 000, or cotton-c...etc. I want to be able to
type into the bank code cell the right code, then into the maturity date
cell, the rest of the information, and then it will correctly take that
information and push it into an unmade row containing all that information.
If that makes sense? There is a catch though there are formulas on the sheet
that the information is being inserted.

Ex of main sheet:

Code:______

Date:_______

Cost:_______

Par:_______

Ex row on being inserted on sheet

Cusip__Date__Cost__Maturity__Cost-Maturity__Rate__Avg Days__AvgRate



"Schwimms" wrote:

I have a couple questions if there is anyone.