Search results

OK I have this code and all I want it to do is find the last cell in column P, which has a sub-total in it and reference that cell in another worksheet in the workbook. My issue is the message box says LastRow = 1, it should be 4121 in this example Worksheet M3 has the cell I want to...

BIBGO! Luke you gave me an idea. Here is the code: Sub Example() Dim colHeads As Variant Dim i As Long Dim newMonth As String Dim mBefore As Date mBefore = DateAdd("m", -1, Now) d = Format(mBefore, "mmmm") colHeads = Array("Client Name", "Service", "Start Date", "Rep", "First Year...

Thanks for the reply Luke. How would I use something like this? mBefore = Format(DateAdd("m", -1, Date), "mmmm") That way it would eliminate the user selecting a month. I will always want to use the previous month anyway. So it is May and I want to use April.

I have this macro that I want the user to be able to select a month to help fill an array. So, when they run the macro it will allow them to select a month from say a dropdown menu. Here is the line of code that I would like the selection to complete. Relpace March with the user selected...

OK, I found some code but I get this, "Syntax error (missing operator in query expression 'Start Date'. Referencing this code line: rs.Open SQL, con& Here is the line of code referencing the table names: SQL = "SELECT 2015, Service, Start Date, First Year Comm %, Residual Commission FROM " &...

OK, I have a macro I am working on, it will be pulling data from an Access DB Query. What I am trying to figure out is the Access Query has a column for each month. I want to be able to select the month I want VBA to pull into my spreadsheet. Much like checking or unchecking the Show box in the...

OK, I solved this. Diana your code helped. Thanks!

OK, I have the code to loop through the files in the folder. I am struggling with the code to match the data from the source workbook into the existing workbook by name only. Sub LoopThroughFilesInFolder() 'PURPOSE: To loop through all Excel files in a user specified folder and perform a set...

OK, Excel VBA gurus, I am trying to take data from a workbook and for each sales rep it find and copy that data into an already existing workbook in the folder. Example: Workbook (Raw Data Workbook) with VBA Module Column1 Column2 Column3 Sam ABC Inc $2500 Bill EFG Co...

OK, how do I using the Advanced Editor in Power Query, make it extract the last date entry in a field? I have about 5,000 ID numbers but have millions of dates. What I want to do is say "for each ID extract the last date they had activity". This would be the line: FilteredRows1 =...

OK, this is a pain, you have to create a filter for each character that you do not want to use. It seems like it would be much easier to allow for multiple entries.

Anyone know how to filter text based on multiple criteria? I am looking to eliminate any text that begins with C, F, H, N, or T but cannot get the text filter to do this.

Works perfect! Thanks Luke.

The following formual was provided to me: =DATE(RIGHT(A1,4),LEFT(A1,LEN(MONTH(TODAY()))),MID(A1,LEN(MONTH(TODAY()))+1,LEN(A1)-LEN(MONTH(TODAY()))-4)) It takes a date and converts it from 112015 to 1/1/2015 OR a date like this 1112015 into 1/11/2015 or 11/1/2015 depending on the current date...

dEEPAK, Thanks a lot! I am assuming the TODAY portion will take care of when I enter say November and have the number 1112015.

Good question. The only way I would know the answer to your question is that the files come in batches for each month. So, if the date were 1112015, and I received the file today then the date would be January 1, 2015. If we fast forwarded to November 2015 and I received the file, then the date...

Here is the deal, I receive a file where the date is a number like this 112015 where I need it to be 01/01/2015 or at least 01/01/15. Also, dates can be 10252014 which is 10/25/2014. How in the world do you convert this with varying lengths? I have looked but cannot find anything to address...

OK, I have this macro that I created in Excel 2010. The issue is I have used Object References and that is causing issues with Office 2007 users. So I am trying to late bind Word so I do not have to use the Object Reference. I have tried to get late binding to work but keep haging different...

I have reports that I run from other programs/software that will only export in .xls files. I have Excel 2010 on my computer. The other day I ran a report and had a raw data tab and a summary tab. As is good practice I made sure the summary tab total matched the raw data total to be sure I had...

OK, my boss wants me to extract data from a database that we have and have each sales rep be able to view their clients, commissions and so on as they choose. She is insistent that I use Access for this. Everyone has Office 2007 and I have Office 2010. I feel that extracting data is easier...

AWESOME!!!! Now I get it. I could not see the forest for the trees! Thank you for your help!

OK, so I'm lost on this formula given. What are the cell references referring to?

OK here is the file. I have not tried Narayan's formula yet but will. I am trying to do this without having to name a bunch of ranges. Thanks, Mike

First, thanks for reading my post. I have 9 sheets in a spreadsheet. The year is in column A and the month is in row 1. All the sheets are laid out the same. I have a summary sheet. You can select the month and year. How do I get the numbers from sheets 1 thru 9 based on the selection of the...

Ken, It works perfect! A little slow but it does the job. Thank you for your help! Mike