keilah


Hi People

I am having trouble with a excel spreadsheet. I am pulling in live data from a MS Access database, that has datatwo sets of portfolio IDs.

In Col A the Portfolio Id are shown as individual (separated) in Col (say) G, the Same IDs are conbined (as shown below) for example:

ColA ColG

Barclays1 Barclays 1+2 (shown as)

Barclays2

what i need is a formula or macro to match and combine the data from col A with that of col G(as shown above) and to automatically update when required to relfect any new add-ins of data in col A (say).

PLEASE HELP.

kind regards

k





Re: Need Urgent Help from the good people

Derek Smyth


Hi mate,

I think you will find more help in the excellent VBA forum, there are a number of good people there who I believe can help with this problem.

http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=74&SiteID=1







Re: Need Urgent Help from the good people

keilah

thanks

Any ideas for using excel formulas

thanks







Re: Need Urgent Help from the good people

Rong-Chun Zhang - MSFT

Hi keilah,

Moved from Windows Forms Data Controls and Databinding.

Thanks.