ok you have a list so do you have another big list of old?
ok you have a list so do you have another big list of old?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hi Martin,
Thank you for your interest.
Although I do not have e a bigger list
Each day I create a new Excel file listing the new fund prices
I name this new Excel file with the date e.g. FT110909 ( FTYYMMDD )
The order of the fund names in column B can change from day to day
On the Excel sheet “ FT110909 “ I wish to replace the symbols in column C light blue background
by the symbols in Excel sheet “ Find & Replace “ column F light green background
Would I have to give this dally Excel file a temporary name? e.g. “Daily”
I hope that I have not created confusion by the use of terms new & old symbols
Attached are copies of Excel files “ FT110909 ” and “ FIND & REPLACE ”
I hope the above is understandable.
Kind regards,
Derek
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks