Formula help

  • Thread starter Thread starter mccrimmon
  • Start date Start date
M

mccrimmon

Heres an email ive sent to someone for some help but they havent go
back to me yet so was wondering if anyone could help me

All the information should be in the email

Anyone got any ideas?

------------------------------------------------------

Hi mate

Ok

Heres the script

Attached is 3 spreadsheets.

(1) jpmemail.xls
(2) brian fund details.xls
(3) brian revals template.xls

This is the sequence and purpose of each

JP Morgan send us an email daily with a list of deals - this can chang
from
day to day. Somedays reporting none other days reporting hundreds.

I save the email they send me to my hardrive named jpmemail.xl
(overwriting
the previous days one)

I then open my brian revals template.xls and this will automaticall
update
due to the formulas i have in place on it.

The problem is I need to manually drag down the formula each time i
order
to pick up everyday and vise versa if there is no deals and th
previous day
there was loads, i need to delete all the formula values to show this.

Im looking for a formula to say that if there is (ie 12 deals on jpm
email.xls you should drag down the formula 12times on the brian reval

template.xls) and if there is only a couple of deals i need a formul
to
delete the formula so that it is only showing the deals.

Can this be done?

I cannot amend anything on JPM email as this is sent in from a compan
and
is basically what i need to work with.

The fund details.xls is just so i can pick up what fund code it i
within
our company so nothing needs to be done with this.

Thanks agai
 
Hi
Not quites sure if this is what you're looking for:
change your formulas to something like
=IF(cell_in_JP_morgan_sheet="","",your_formula to calculate)
copy this down
 
Back
Top