• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Are Macros enough for automating reports in Microsoft Excel?

GN0001

Why wouldn't they be?
You can achieve just about anything when you start using macro's

More detail about what you want to achieve would be more helpful so we can give a more specific answer
 
GN0001

Why wouldn't they be?
You can achieve just about anything when you start using macro's

More detail about what you want to achieve would be more helpful so we can give a more specific answer
====================
If I want to create two synchronized combo boxes in Excel, can this be done by macros?
GN0001
 
Why not attach a sample file with data and whatever you have setup so we can give a more targeted response
 
I have developed systems in the past that have consolidated data from several Excel, Access, Text Files and Web sites into a Daily, Weekly, Monthly and YTD dashboard with comparison to Forecast and Budgets.

So my original answer remains, Yes
 
Hello Hui,
I have two List boxes; I want the end user select a state from a list box and only the cities for that state to show in the second list box.

To map correct cities for correct states, I had to repeat name of states.

----------------------------------------------------

Hui:

I have developed systems in the past that have consolidated data from several Excel, Access, Text Files and Web sites into a Daily, Weekly, Monthly and YTD dashboard with comparison to Forecast and Budgets.

GN0001:

I am sure I will need this very soon in the future. How can I link an Excel workbook to several data sources? How can I approach this goal?

Regards,
GN0001
 

Attachments

  • Synched ListBoxes.xlsx
    15 KB · Views: 2
GN0001

What is the output of these Controls going to be used for?

Have you considered using slicers ?
 
Hello Hui,

What is the output of these Controls going to be used for?
This technology can be used for so many subjects, for example, end user can select the entries and pull members for a state or for a specific city.

Slicers can work; but I really like learning how to build synched combo boxes.

I want to see how macros work for all the situations.

Regards,
GN0001
 
Back
Top