Recent content by theath

Wow, that was simple! Thanks for the help. I added this to the full script I was working on and it works like a charm!! Thanks Hui!

I need help with a macro. When I run the macro, I need to set the current workbook as a variable. I want to then call that variable later. Here is what I have and it doesn't work. I have two workbooks open. If I name them in the macro I can see it switc focus to each one. If I try to pass...

Is there a way to change just the paste function?

I have made it a bit futher. Now I am stuck at this: I declare WB as ThisWorkbook. Later, I want to go back to WB and select the DATA tab and paste my data. When I get to the Paste sub routine it errors out Sub importData() Dim WB As Workbook Set WB = ThisWorkbook getData Copy...

Trying to write a script and having trouble getting it to work. Export.CSV Every month a CSV file will be made available. The number of rows are variable every month, but the columns contain data from A to AS. The name of this export will change and reflect the month the data is from...

Perfect. All is solved. :) This is perfect. I appreciate your help!

Can I easily modify this formula to also look at the year? =IF(SUMPRODUCT(--(MONTH(Table1[Date])=1))>0,B2,0)

OK, so I just got a little bit further. I have this working for months. Now I just need to add matching for both the month and year. Uploaded a new spreadsheet. https://docs.google.com/open?id=0BxhVKid9p8IBYXpqU1JuWHZUY2FOa2xlZ0tlOXJfZw

That was easy enough :) I have uploaded the workbook to: https://docs.google.com/open?id=0BxhVKid9p8IBZzZFM2pFSUZTdUMydjljOXdCZ0QwUQ

Sure. How do I upload the workbook?

I have been trying to make the suggested formula work by adding a helper column to the Monthly Hours sheet, and just pointing it to the data sheet. The number of rows in the Data sheet will vary so I have to copy the formula down far enough to accomodate fluctuations in the number of rows. When...

Unfortunately I am unable to create the helper column. What I forgot to mention is that in the Monthly Hours sheet, column A is the first day of the month (1/1/12, 2/1/12, etc). I have it formatted as MMMM. After thinking about this longer, I really need to identify the Monthly hours...

The "Data" tab in my spreadsheet contains a list of dates in column J (format is date, example: 1/27/2012). On the "Monthly Hours" tab column A contains each month, column B contains the workable hours in that month. ........A........B 1....Jan......176 2....Feb......168 3....Mar......176...

Is there a way in a pivot table, or using powerpivot, that I can have multiple columns of data, each filtered differently? The below output filters out name and activities that I do not want to see. I would like to add a new column that displays the sum of hours for the items that I...

I have a large amount of data that has been pulled from our company's time reporting system. I have a pivot table that shows the hours for selected resources, for selected activities. I need to now show a calculated column on the report that displays "Available Hours". Available Hours will...