Recent content by newguy86

Hey Skip, I'm not sure if I understand your question but the list that I provided is generated by the end user when they enter the different zone codes, or syscodes, that apply to the change being requested. There are several syscodes within a single market so each market will usually show up...

I'm trying to automate a form that was built in Excel so that the information within the form is automatically organized into a table on another sheet. I've worked out most of the process but the issue I'm having is that a part of the form lists different codes for each of the broadcast zones...

I've been running this for a while now and I've noticed an interesting issue. Whenever the code is trying to pull in the first dataset from an excel spreadsheet, it takes forever to pull the data in. But after that first dataset, all the rest of the dataset's (regardless of size) get pulled in...

Ok. I see what you're talking about. I put everything in that you said and it works perfectly now. Thanks! Travis Charter Media

Correct. The formulas are in each separate workbook table and gets copied over into the Data worksheet. I'll try to change the code to put the formulas in after I've copied the DATA over from the other files. Travis Charter Media

The data comes from a separate Excel file that we use to process and reformat the raw data that comes out of our system. The formulas are put in to that file during the reformatting. Here's the code that updates the final report: Sub Update_Report() Dim MainWkBk As Workbook Dim NextWkBk As...

Thank you for the suggestion. That seems to work with the exception that whenever I upload the new data through VBA the formulas in the first record of the table are now being changed from: =SUM(F2:L2) To something like this: =SUM(F2:L92600) It only happens in the first record of the table...

Thanks for your response Skip! Quick question...if I do this will it be able to accommodate to changes in data sizes? For example, the data right now is about 83k rows. But sometimes the data is less than 80k rows and other times it's over 85k rows. Will a Structured Table be able to capture...

Hello Everyone, I've been tasked with automating an Excel 2013 report that uses pivot tables. So far it's working except when I get to refreshing the pivot tables. Now what happens is whenever a new report needs to be run, the data in the old report is cleared out of the Data Tab (except for...

Sorry for taking so long to respond, the holidays can be hectic! :-) To answer your questions, because the worksheet is a report that's generated by a 3rd party system, we don't have a way to change how/what the worksheet is named when it's generated. Currently we are manually renaming the...

Hello Everyone, I have an Access DB that has linked tables to excel data that I'm trying to compare. When I setup the linked tables I made sure to name the excel files something relatively generic so that any new data that was generated could just overwrite the old data using the same file name...

Hello Everyone, I'm using Access 2013 and I have a query "qryTTOver24" that shows every order that took longer than 24 hours to complete. What I want to do is be able to is select a record in that query and add notes explaining why it took that long. I already have a table setup...

Well what we have is a hierarchy built to not only identify which sales offices belong to which regions (Central, Pacific, etc), but which sales offices belong to which corporate office that manages them (STL, TN). What I wanted to do was have a report that showed the average turnaround time...

What I'm trying to do is create a single report that allows the user to view overall turnaround times for all work orders in our system but also gives them the ability to drill down to specific regions and teams to see how they stack up against each other. I'm figuring that the easiest way to...

Perfect. Exactly what I was looking for. Thanks! Travis Charter Media