Search results

I have a spreadsheet where I need to look up a value based on multiple criteria. One spreadsheet is the master, the other contains the data I need to bring into the master spreadsheet. The master spreadsheet has the Employee ID (Column A),row 1 has the Pay Date such as 9/13/19 (Column I)...

I have attached an example spreadsheet. I am trying to spread the variance into cells in column E via a formula. Currently it is manually. Cell F21 must equal 100%. Any ideas? Thanks!

I am trying to look at sales data for many stores. Some stores were not open at some points in time. For instance, maybe 3 stores did not open until 11/16 while others were open from 07/16 to present. I want to use the TREND function but want it to ignore the zeros. I did find a...

I am pulling data from a database. What I would like to do is setup a few parameters in the workbook that contains the query and use named ranges to filter the data in the query. For instance have a start and end date, service, the beginning of a billing code such as PR, CB, or FB that I enter...

Anyone have any ideas on how to calculate a trailing 12 months in Power BI to create a graph showing how the client base has changed over time during a 12 month period? My calculation in Excel is Retention Rate = (End Bal. - New)/Begin Bal. I have data where there is a start date and an end...

I have a macro that creates several folders, then takes data from one spreadsheet and creates several spreadsheets and saves them to a specific folder. Next I need to add several Call Macros to format each file in each folder, there are 9 folders, what is my best option? Should I setup a...

I have a spreadsheet with data in columns A:N, headers are in row 1. Currently my macro takes the client name (there are 24 clients) in column N and creates a spreadsheet and saves it to a folder. In column N there are the names of the vendors associated with the clients. What I would like to do...

I have a table called SInvoices that has a column called invoiceDate. I am using a slicer to select a date range. I have another table called Commissions that has a column called startDate and another called endDate. I would like to have it when the slicer is used to select the date range it...

I am kind of stuck and need an outside opinion. I have some data where the client has a specific term date, which is easy to filter. However, there is also a column where the client is either active or terminated. The issue is that in some cases the client is active but has a end date and in...

How do I create a filter that says IF column A begins with "C" and column D contains "Apples" then exclude that data from the query? Thanks!

In the example spreadsheet in column A is an ID# and in column B is the relationship. In row 2 there is the employee column B and their ID# in column A. In rows 3-5, they are related to the employee in row 2. What I am trying to do is in column C to have the ID# repeat until Employee is found...

I have a query setup with all the parameters needed. All I need now is to be able to display my data in groupings like this: 0 to 25 26 to 50 51 to 100 101 to 150 151 to 200 +200 What is the DAX counter part to COUNTIFS? Thanks, Mike

I have this macro that works but it asks for me to choose the file fName1 three or four times. Why? Sub GetFile() Dim fName1 As Variant, wbo As Workbook Dim fName2 As Variant, wba As Workbook Dim WBName As Worksheet fName1 = Application.GetOpenFilename(filefilter:="Excel Files (*.XLS)...

I am working on some code where I identify a workbook as "wbo" by way of GetOpenFileName. Set wba = Workbooks.Open(fName1) I am trying to do a VLOOKUP like this: Range("O2:O15").FormulaR1C1 = "=VLOOKUP(RC[-1],wbo R2C15:R150C15, 1, 0)" How do I reference wbo in the formula? Thanks.

I am wondering if someone can help me with this. I know very little about this type of VBA coding. I can scrap simple data, but this is a challenge. So here I will say many, many thanks! I have a list of numbers in an Excel spreadsheet and want to loop through them to extract data from the...

I have a macro that has been working for a while. For the last two months it has not been working. It pulls the data into the spreadsheet from Access and then just freezes. There are no errors, no nothing, just the little blue circle like it is doing something. But it just hangs there. Can...

The scenario: I have a workbook with140 worksheets with various names. I used a macro to extract the worksheet names. I pasted those names in M1:M140 and gave it a named range of Tabs in the Totals worksheet. In the 140 worksheets in cell B3 is one of 5 unique names that I want to sum on. The...

I have a macro that errors out on the line of code that says ActiveWorkbook. The exact same code runs well in one place but not the other. Any idea why? sFileName = "MN Packout Log " & Format(Now, "mm-dd-yy") & ".xlsm" sBasePath = "C:\General Use\UPS Daily Tracking\Logs\"...

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

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

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

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

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

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