I have been working on the formula on the attached file, template tab cell Q5. The formula is working but it references month numbers in row 5 and I would like it to reference "X"s instead. The idea is for users to enter an "X" for the columns that apply. I could convert the "X"s to numbers...
I need help creating a formula that will take into account criteria on a different tab. I have an example on the attached file.
Any help would be appreciated.
Thanks in advance!!!
I use an Excel Add-in that drops off the menu every time I close Excel. It is very annoying. I would like to create a macro that will add the add-in automatically when I start Excel. Specially it drops the com add-in. The Record Macro doesn't capture the steps of adding the add-in. Any help...
I am a proficient Excel user. I even teach Excel classes. I have a very large Excel template I am using at my company that many people use and in the process of creating a new version a phantom link appeared. I call it a phantom link because I did not copy data from anywhere into this file...
I'm creating a report template that will be used by many people. So it has to be easy to use. It is a large file. There are 8 data tabs where the data is the same but different time frames. I created one report template with formulas to pull in the data from the data tabs and create...
I'm looking for a method to create sum formulas dynamically.
I'm creating a report where there will be a data tab and then users will be setting the report tab themselves. They want the flexibility to group information as they wish. But I want to make it as user friendly as possible. And one...
I'm being needy today. I have another question on the same spreadsheet I'm working on. I want to calculate Rank but I want it to calculate separately for each Sub. On my example file I have the reference range for the entire data table which I need but somehow I need to add a piece that takes...
I have another tricky formula I need help with. I have attached an example. I'm trying to solve for a total in cell G11. It needs to sum the locations listed in range G7..G9 for the Sub# in cell G5. It is the multiple locations as a criteria that is giving me trouble. Note: normally I would...
Hello all. I have a challenge I can't quite solve. I attached an example. I need a formula to match two criteria. I found a lot of examples on the Internet of formulas using two criteria. But in my example there is one text criteria and the second criteria is a number that I want to match...
This is a very strange issue. I have an Index/Match formula that calculates incorrectly when I update the data source. But when I troubleshoot the formula by deleting part of the formula and then clicking undo to return the cell to the original formula the cell calculates correctly.
This is...
I am looking for a quick method, formulas or VBA, to combine data from two lists. I copied a file for an example. The output needs to be a table with two columns; the first column List A and the second column List B. List B needs to be repeated for each item in List A. The total number of...
I am stuck coming up with a solution for a project I'm working on. The goal is to give users the ability to select multiple product levels for printing a report. I created a file with check boxes. I can handle creating a macro that will check where there is a "True" and then have the macro...
I need a simple macro to combine a list of numbers (rows) into one cell separated by commas. I picture a loop that starts at the first cell and continues until there is a blank.
Thanks in advance! :)
Input:
9500
9501
9502
Output:
9500,9501,9502
I have a macro for a template. In the final step I need it to do an if statement and then do one of either two actions. The macro should stop after whichever direction it goes. Will the two different actions need to be subroutines? If so how do I switch to them from an if statement? I'm...
This is a followup question to an earlier post. I decided I need to have the output on a separate tab. I have the data on "MerchList" tab and I data on "Output" tab. I tried adding two Sheets statements but I get an error after: Sheets("Output").Select
Thanks in advance!
'Start Merch...
I'm a novice VBA user. This seems like it would be easy but I can't figure out how to accomplish it. I'm trying to create a template that can be used to upload data into a system. I have half of it working. Now I need to take column of consecutive values and paste them next to another column...