I've got a pivot table, in which I am using an "Ending Date" as a Report Filter. I would like to be able to apply a "Value Filter" to this, but Excel 2010 is not letting me. I understand that I can check off multiple dates, but I have a lot of dates in there. I'd like to see the information...
I'm looking at possibly running some fiber optic cable in a few of my wells to get a better representation of a production log and to try and find our if we have any thief zones. I'm looking for a way to ensure that I get the cable to the bottom perfs in these wells and I would like the fiber to...
I'm trying to generate an Excel cash flow model to determine whether or not to use chemical to help slow down the corrosion of my tubing. I was hoping to be able to run a series of scenarios, i.e. continuous injection, batch treating monthly, bi-monthly, quarterly, etc. along with different...
So here's the deal. I get emailed daily production from 9 wells, each is a separate file and each file gets renamed for each month/year. I take each of these 9 separate files, (soon to be quite a bit more) and have to take the past week's data from them and put it on another spreadsheet that I...
One thing I just thought of would be to create tabs with the names that I want and link them to tabs with the no space naming convention. I could then hide the tabs that have the no space names. That way I could name my dynamic ranges but still have the nice and clean tab names. Could there...
I have a spreadsheet with quite a few tabs, each of which is linked to multiple charts. We add data daily and I wanted to have the charts update dynamically. I am in the process of naming the dynamic ranges and found that in order to do so that the names of my tabs needed to have no spaces...
Thanks for all of the help. I ended up getting it to do what I wanted by using the sumif() function. I set it up to where the data automatically gets pulled depending on what the date is. I'll continue to tweak it though and may try to incorporate what guys suggested in this sheet or others...
Alright, I think I'm getting close here. I can't get my offset squared away. I actually want to take the last 8 rows, with data, in the spreadsheet. The dates go on for years.
Selection.End(xlDown).Select
ActiveCell.Offset(0, 1).Range("A1").Select
Selection.End(xlUp).Select...
That's kind of essentially what I'm trying to do. The thing that is making it tough is the fact that the raw data is getting updated every day and I'm just trying to get it to where it only pulls the last 7 days at any given time. Something like, "Range("A65536").End(xlup).Select". Can I do...
Hi guys. I am not the best at writing code. I typically just record simple macros. However, I have a sheet that gets updated daily and I want to be able to take the last 7 rows (a weeks worth) of data and export into a separate table on another sheet. Any help would be greatly appreciated...
I'm not the greatest at writing code. I usually just record simple macros. However I am trying to write a macro to take the last 7 rows from one spreadsheet that changes everyday, and export them to another spreadsheet. I'm trying to make some nice weekly production tables and charts. Any...
The reason I asked is because I am transferring from 3D to 2D so that we can send it off to the plastics guys for fabrication. Thanks for all of the help and I'll remember the "show spline handles" for future projects. That should help out some here and there.
Yeah, I ended up adding tangential lines and getting angles that way. I was just wondering if there were and easier/simpler way. Thanks for the reply though. Cheers.
