list varying data in differen excel folder

[kurish]

good days
I want to do application which is about different excel folders. forexample there is a excel folders whose name are aa excel folder and bb excel folder . I want to transfer data in cell a1 in aa excel folder to cell c1 in bb excel folder . and the next time if I change data in aa excel folder it must be tranfer to bb excel folder in c2. in this application data in aa excel folder will be always change; but bb excel folder will list all of them.Hope this explains it alright.

Thanks in advance.

[Leith Ross]

Hello kurish,

Welcome to the Forum!

Copy this macro into Excel workbook "aa". The instructions are below. Change the name of "bb" in the code to the name you are using. It is marked in red.

Please Login or Register  to view this content.

How to Save a Worksheet Event Macro
1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
3. Left Click on View Code in the pop up menu.
4. Paste the macro code using CTRL+V
5. Make any custom changes to the macro if needed at this time.
6. Save the macro in your Workbook using CTRL+S