Importing an exporting data

[renejo]

Hello! I need help with something...

I have 2 workbooks with a lot of info and i need a macro for copying cell contents from one wbook to the other, but i want to be able to specify which cell from a certain workbook i want to copy into another specific cell in a different workbook i choose

And another thing, i have a database with mutual funds ratings, but these ratings have different names for each category for example: triple A funds can be named as follows :

AAA
mxAAA
Aaamx

i would like a code that recognizes all those ratings as one in order to being able to sum the quantities for each fund

i hope you can help me with this thanks a loooot!

[Leith Ross]

Hello renejo,

Welcome to the Forum!

I have attached a workbook that contains an interactive copy and paste form. You can copy and paste from any open workbook to any any worksheet. Have a look at it, and let me know if you have any questions.

Sincerely,
Leith Ross