ANmarS - Search results

Excel/VBA expert since Sep 1997 (20 years 9 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

2 Q & A posts tagged with external

Nov 12

How do you insert external data into excel STARTER?

This question is specifically for Microsoft Excel STARTER. It's not like on other versions of excel where you have a data tab and can follow the steps from there.
I have already checked google also so please don't suggest pages on their or searching it on google. I have also checked the microsoft website.

BASICALLY, if you personally know how you insert data into Microsoft Excel STARTER I would really appreciate the steps on how to do it :) And will rate best answer for whoever tells me. Thanks


There are actually several ways, basically using VBA or macros
If you know how to do that there are several macros out there

I would suggest one of these
to read directly from MySQL DB into Excel sheet

or use…
to read from sql or Access


Again, those are macros (Using the back door for Excel) to insert these data

If none of them helped, let me know from where are you inserting the data and I would be glad to show you the way.

let me know if that helped

Saturday 11/12/2011 2:17:09 AM
May 11

How can you make an excel workbook, with about 1500 formulas that total from 3 other workbooks?

The auto fill does not work because it is pulling in information from 3 separate workbooks. Is there a quicker way then building all the formulas separately.


It looks like you have custom external links,
something like this…
This lesson will show you how to get values from several sheets

And also this one to show you how to generate external links…


Tuesday 5/11/2010 8:36:52 AM