Excel Marco Vs Excel Functions

[mingali]

Hi,

Currently, all of our data in Excel are linked by using Excel Functions between workbooks and some of the files are so large that it may take 10 minutes to open and copy and paste a cell may take three minutes (which is ridiculous slow).

A friend told me that we should use Excel VBA to do the work instead of using linking.

Pardon my ignorance, my understand of Excel VBA/Marco is about automation. Even i use marco to run the excel, i still need formula in the cell in order to perform the task, right?

All comments are welcome.

Thanks

[davesexcel]

Hi Mingali,

Usually you manipulate the cells with VBA, formulas do not have to be in the cells.
Look at the simple example...click the button to add the two columns

[mingali]

Hi Davesexcel,

Thanks for your explanation and i understand it with your example. However, when it comes to my circumstances, i still not sure how VBA can benefit me.

I attached a simple example of what i normally do. Worksheet "Total" is the sum of worksheet "A1" and worksheet "B2".

As you can see, "Total" has if function in the cells. and it is to update monthly. With this example, how VBA can help me without 'if' function in the cells? and also to update it monthly?

Thanks

[mingali]

Hi

Could someone please show me how VBA can help me with the above workbook, so that i can understand better and work from there.

Thanks

[davesexcel]

Check out summing grouped worksheets.

[mingali]

i dont know what are you trying to say. Nonetheless, since no one is responding i will just treat it as solved.