Solved: VBA help needed

[Spider_Lily]

Hi all,

Thanks to MaximS and other websites, my VBA macro is able to work.

But the problem is, the data from the same workbook is copied to the summary file each time the macro is being run, even when I chose 2 differennt files when importing. What is the problem with my code?

Thanks!

[Bob Phillips]

Are you saying that you select file A say, but it actually opens and copies data from another file.

[Spider_Lily]

I mean that I have written the macro such that when I run the macro:

A dialog window will pop up and I can select multiple different workbooks that I want to copy.
But when I run the macro, I get 2 repeated rows of data from the same Workbook (even though I open 2 different Workbook)

[MaximS]

In my opinion you don't need that code in summary file.

All you need is change the code in files containing form to refere to Master Summary. Then every time form is filled in and button is pressed new line will be added in Master Summary.

[rbrhodes]

Hi Spider_Lily,

Does this help?

[Spider_Lily]

Hi Spider_Lily,

Does this help?

Hi rbrhodes,

That works fine. Thank you so much for your help.

I really appreciate it.:clap:

[Spider_Lily]

Title is changed to help others who may be in the same situation