I have an excel database that is updated daily, with corresponding queries on separate sheets. I would like for the queries to update automatically...

How It Works

Get an answer in three easy steps. Here's how it works...

Ask Your Question

1. Ask Your Question

Enter your programming question at the top of this page and click Get An Answer.

Pick Your Priority

2. Pick Your Priority

Tell us how quickly you want your programming question answered.

Get An Answer

3. Get An Answer

Connect with your programmer via online chat or telephone call.

Answer

Customer

I have an excel database that is updated daily, with corresponding queries on separate sheets. I would like for the queries to update automatically anytime the database is adjusted. How do I accomplish this

Last updated
Ferdinand Aquino
Programmer

Hello and welcome to ExpertHelp.com! My name is Ferdinand Aquino and I'm going to do everything in my power to answer your question to your full satisfaction!

Before we get started, I want to remind you ExpertHelp.com is an independent professional support company. We are not associated with Microsoft / Excel nor are we paid to provide support on their behalf. However, we have helped hundreds of customers with similar questions and believe we can help you too. OK, let’s get started! :)

I’m available to chat now. Please let me know that you are ready by posting a response. I’ll leave my chat session open for the next 15 minutes or so and wait for your reply. If I don’t catch you this time, please respond with a few times (including your timezone) that work best for you and we can connect then.

Last updated
Ferdinand Aquino
Programmer

Dear Ashleigh, It was a pleasure helping you with your Excel  issue today. Here is a summary of the resolution.
Issue identified :

Assistance in how to automate the data in results page from data in Source sheet
Solution Implemented :

Call customer / remote access

Assisted customer in using Excel formula / Countif / Range Paramenters to get and filter data from sheet source to results

Issue resolved

If issue resurfaces in next 30 days, come back to this Question page and let me know. If you are unable to find your way back to this Question page or if you have billing questions, please contact our customer support either by email (s**t@experthelp.com) OR call us at ***-***-****

Posted

quoteTestimonialsquote

About ExpertHelp

ExpertHelp is changing the way you connect with service professionals.

Whether you have a quick question while preparing your taxes, troubleshooting a computer problem, or need to hire an attorney, ExpertHelp is the most convenient and affordable way to connect with the right service professional to get the job done.

ExpertHelp has been in business since 2011, is an A+ Rated Better Business Bureau accredited member, and offers a 100% satisfaction guarantee on every question you ask!

More Programming Questions...

Ask Your Programming Question & Get An Answer Now!