Search results

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...

Hui, This will work just fine. I am cleaning up date from a report output and only need the final numbers. This is perfect! Thanks!

Unfortunately I can't control how the data is being exported.

I have a column of Days:Hours that I am trying to average. I keep getting a DIV/0 error. I have tried Text to Columns wizard with no luck. Format of columns is ddd:hh 010:22 014:02 002:21 000:03 001:23 000:01 000:00 004:23 006:23 001:21 008:05 012:20 000:02

works great! Thanks for the help!

I would like to sum the values in table 1 column [Monthly Revenue] if the follwing conditions are met: 1. Table1[Type] = "Managed Service" 2. Table1[End Date] = current month and year recorded in cell BQ1 I am using this formula but having issues. It results in a zero, which is far from the...

In order to calculate the date in H3, I am using the following formula: =EDATE($A$3,1) This changes the year to 1900 :(

I have the following columns and Rows H3: Date (on spreadsheet is 11/14/2011) E5: Contract End Date (on spreadsheet is 09/30/2012) G5: Dollar Amount I want to evaluate a cell to see if the date in H3 is less than or equal to the date in E5. I am only concerned with the month and year...

works like a charm! Thanks for your help!

I am trying to declare a variable that is the text in a cell in a hidden column on the spreadsheet. This work if I move the cell to a column that is not hidden, but not when the column is hidden. Any ideas? The value in J3 is the result of the following formula...

I just tried it on my backup spreadsheet. Go figure. It worked like a charm. I updated that copy with the changes I made since last saving to it and things are OK now. I have no idea what was going on with the last one, but it seems to work now. Thank you for your help! It is greatly...