Search results

Thanks Luke that works perfect!

OK, I know this is simple, but I have 3 named ranges in worksheet1 and want to combine data from 3 named ranges into one and paste value that into worksheet2. Range 1 = COID Range 2 = CoSet Range 3 = Service New Range = COID&CoSet&Service I would end up with something like this in columnA of...

Thanks! That works perfect!

Hello fellow excel users! This morning I am having brain fog and need a little help. Perhaps I am overthinking this. I have a pricing scale where in range B2:B7 I have the following: 1,2,3,4,5,All In range C1:G1 (Qty size) I have 1 to 250, 251 to 1000, 1001 to 3000, 3001 to 5000, 5001+...

Is there a way to set a cell value to a default value when a workbook is closed without VBA? I have a dropdown list in cell A14 that has a list of names. When a user closes the workbook I would like for that cell to say, "Select your name." when the next user opens the workbook. Is this...

Never thought of that. It works perfect! Thanks Nebu!

I have a list of ID numbers in column A of a spreadsheet. I have an Access Query called Billing Details. In this query, "co" matches the ID numbers in column A of the spreadsheet. What I want to do is have VBA in the spreadsheet loop through each ID number and return all the data associated...

What I am looking to do is for 0069, eliminate the high end value of 18,302 and any value below 8,000 to get an average of 10,132 instead if 5,485. And with 0024, eliminate the value of 156,003. So, if there are values that are above or below what the normal average would be, then I want them...

I have some data which has some MIN values way below the average and some MAX values way above the average. How do I eliminate the MIN and MAX values to get a "True" average? Example: 150,000 110,000 90,000 20 rows between 15,000 - 25,000 5,000 1,200 1,000 How would I eliminate the...

I looked at that, I went back and re-typed the file name and I get the same error. I also checked the spelling and that was fine. I even went back and re-named the file in the folder. I also checked the name of the folder. Finally, I just saved the file as another name, re-mapped it in the...

This is just crazy, this macro has been running for a while and now it does not. For whatever reason now wbIC and wsIC shows "Nothing". The error occurs on this line of code: With wsIC 'sort asc in Col D .Cells(1).Sort Key1:=.Range("D2"), order1:=xlAscending, Header:=xlYes End With To me...

Deepak, I never thought of the SUMIFS. I like that option, it is simple and clean. Thanks a bunch!

I have some dates in C1:N1 and data in C2:N4500. I have the max value of each row of data in column O2:O4500. I would like to in column P return the corresponding date of the max value from row 1. I have this formula in column P to get the cell address of the max value...

AWESOME!!!! I had the Row with Header part but finding the empty cell after header was what was killing me! Thank you for your help!

OK, not sure how to explain this idea, so I have uploaded a workbook with what I want to do. Basically, it is a Balance Sheet that has headers for each section of data, Cash, AR, Other AR, etc., the issue is I cannot use VLOOKUP because each "section" has Total instead of Total Cash. My end...

Yep, I had to add some helper cells. For the dates in column A I added Cur. Date =MAX(A:A) Then TTM Start =EDATE(F7,-12) Next TTM End =EDATE(F8,-11) To get the Prior TTM is used: =SUMIFS(B:B,A:A,">="&F9,A:A,"<="&F8) Thanks Luke!

I have dates from 1/1/2013 thru 9/1/2015 in column A and sales data in column B. Row 1 contains headers. I can calculate a dynamic current trailing 12 months of sales easy enough (Dates 10/2014 thru 9/2015). My issue is calculating a dynamic prior 12 months of sales (Dates 10/2013 thru 9/2014)...

OK, I have this code that counts cell colors. It is in a module. What I want to do is on the worksheet where the function will be used is to have it active so when the user changes a color in a range of specified cells the function automatically runs. Much like if you have COUNT or SUM in a...

Thanks Luke! It works perfect!

I have the code below and all I want to do is have the filename copied in all rows that contain data from the copied workbook. So, if in one workbook the Accruals row count is 35 rows, then I want the filename in all 35 rows. Sub MergeAllWorkbooks() Dim SummarySheet As Worksheet Dim...

Man Luke what am I gonna to do with you? Just kidding.:) The change worked perfect! I had the code like this before asking for help so I was close! If I >= StartDate And <= EndDate Then But it was an error. I think at one time I eliminated the "And". I'm learning this stuff. At least I was...

OK Luke, I set it up and it still pulls in all the dates. I had my variables setup exactly as you. Option Explicit Sub MergeAllWorkbooks() Dim SummarySheet As Worksheet Dim FolderPath As String Dim NRow As Long, LastRow As Long Dim FileName As String Dim WorkBk As Workbook Dim...

How would I set this code up to return all data in the range between two dates? Right now it returns all the dates. For Each i In SourceRange If i.Value >= StartDate <= EndDate Then 'Set the cell in column A to be the file name. DestRange.Cells(NRow, 1).Value =...

Thanks Narayan! It worked perfect!

That is what I thought may be the issue. What stumped me was I had this code in one of the workbooks to test it and it worked fine. But, when putting it into the code to loop through several workbooks it would not work. Option Explicit Sub SumDateData() Dim DataSheet As Worksheet, SumSheet...